DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on FND_LOOKUPS

Line 4750: l_Bill_Flag_Meaning Fnd_Lookups.Meaning%TYPE := Null;

4746: l_Inc_By_Org_Id Pa_Expenditures_All.Incurred_By_Organization_Id%TYPE := Null;
4747: l_Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE:= Null;
4748: l_Ovr_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE := Null;
4749:
4750: l_Bill_Flag_Meaning Fnd_Lookups.Meaning%TYPE := Null;
4751:
4752: l_Proj_Attrib_Rec Pa_Otc_Api.Project_Attribution_Rec;
4753:
4754: l_Msg_Name VARCHAR2(30) := Null;

Line 4810: Fnd_Lookups

4806: Cursor GetBillFlagMeaning(P_Lookup_Code IN VARCHAR2) Is
4807: Select
4808: Meaning
4809: From
4810: Fnd_Lookups
4811: Where
4812: Lookup_Type = 'YES_NO'
4813: And Lookup_Code = P_Lookup_Code;
4814:

Line 5779: G_Stage := 'Get translated value for Billable_flag code using fnd_lookups.';

5775: * in update phase of validation logic and billable no longer
5776: * matches what patc returns.
5777: */
5778:
5779: G_Stage := 'Get translated value for Billable_flag code using fnd_lookups.';
5780: l_Bill_Flag_Meaning := Null;
5781:
5782: G_Stage := 'Open cursor getBillFlagMeaning.';
5783: Open GetBillFlagMeaning(l_Proj_Attrib_Rec.Billable_Flag);

Line 5825: G_Stage := 'Get translated value for Billable_flag code using fnd_lookups.';

5821: * in update phase of validation logic and billable no longer
5822: * matches what patc returns.
5823: */
5824:
5825: G_Stage := 'Get translated value for Billable_flag code using fnd_lookups.';
5826: l_Bill_Flag_Meaning := Null;
5827:
5828: G_Stage := 'Open cursor getBillFlagMeaning.';
5829: Open GetBillFlagMeaning(l_Proj_Attrib_Rec.Billable_Flag);