top of page

PM Data Item Lov User Where in IFS10 [PM_DataItemLovUserWhere]

Writer's picture: Rumesh Aponso (RMAX)Rumesh Aponso (RMAX)

Example 1:


private void tableWindow_colsBucketId_WindowActions(object sender, WindowActionsEventArgs e)
{
	#region Actions
	switch (e.ActionType)
	{
		case Ifs.Fnd.ApplicationForms.Const.PM_DataItemLovUserWhere:
			this.tableWindow_colsBucketId_OnPM_DataItemLovUserWhere(sender, e);
			break;
	}
	#endregion
}

private void tableWindow_colsBucketId_OnPM_DataItemLovUserWhere(object sender, WindowActionsEventArgs e)
{
	#region Local Variables
	SalString sLovUserWhere = "";
	#endregion

	#region Actions
	e.Handled = true;
	sLovUserWhere = @"(block_for_use_db = 'FALSE')";
	e.Return = sLovUserWhere.ToHandle();
	#endregion
}

Example 2:


private void cChildTableDetail_colsActivityId_WindowActions(object sender, WindowActionsEventArgs e)
{
	#region Actions
	switch (e.ActionType)
	{
		case Ifs.Fnd.ApplicationForms.Const.PM_DataItemLovUserWhere:
			this.cChildTableDetail_colsActivityId_OnPM_DataItemLovUserWhere(sender, e);
			break;
	}
	#endregion
}

private void cChildTableDetail_colsActivityId_OnPM_DataItemLovUserWhere(object sender, WindowActionsEventArgs e)
{
	#region Local Variables
	SalString sLovUserWhere = "";
	#endregion

	#region Actions
	e.Handled = true;
	if (this.cChildTableDetail_colsSubProjectId.Text != "")
	{
		sLovUserWhere = @"(project_id = '" + this.dfsProjectId.Text + "' AND sub_project_id = '" + this.cChildTableDetail_colsSubProjectId.Text + "')";
	}
	else
	{
		sLovUserWhere = @"(project_id = '" + this.dfsProjectId.Text + "' AND sub_project_id IS NOT NULL)";
	}
	e.Return = sLovUserWhere.ToHandle();
	#endregion
}

Example 3:


#region Methods
public virtual SalString SetOperationNoLovUserWhere()
{
	#region Local Variables
	SalString sCUserWhere = "";
	#endregion

    #region Action
	sCUserWhere = this.i_lsUserWhere;
	sCUserWhere = sCUserWhere + " (OPERATION_NO != " + this.tblRoutingOperation_colnOperationNo.Text + ")";
	return sCUserWhere;
	#endregion
}
#endregion

#region Window Actions
private void tblRoutingOperation_colnCParRoutingOperations_WindowActions(object sender, WindowActionsEventArgs e)
{
	switch (e.ActionType)
	{
		case Ifs.Fnd.ApplicationForms.Const.PM_DataItemLovUserWhere:
			e.Handled = true;
			e.Return = this.SetOperationNoLovUserWhere().ToHandle();
			break;
   }
}


0 views0 comments

Related Posts

See All

Fnd Dynamic Tab Page in IEE Client

[FndWindowRegistration("YVVDA_COMPANY_ADDR", "YvvdaCompanyAddr", FndWindowRegistrationFlags.HomePage)] [FndDynamicTabPage("frmCompanyAddr...

LISTAGG in PLSQL

Example 1: SELECT DISTINCT LISTAGG(t.commission_receiver, ';') WITHIN GROUP (ORDER BY t.commission_receiver) FROM...

Get Foundation Error from ORA Error

FUNCTION Strip_Ora_Error ( sqlerrm_        IN VARCHAR2,    sqlcode_        IN NUMBER DEFAULT NULL,    strip_ora_only_ IN BOOLEAN DEFAULT...

Comments


Copyright © 2025 RMAXOneNote

  • Online CV
  • LinkedIn
  • Youtube
  • GitHub
  • Blogger
bottom of page