DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on FND_LOOKUPS

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

4445: l_Inc_By_Org_Id Pa_Expenditures_All.Incurred_By_Organization_Id%TYPE := Null;
4446: l_Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE:= Null;
4447: l_Ovr_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE := Null;
4448:
4449: l_Bill_Flag_Meaning Fnd_Lookups.Meaning%TYPE := Null;
4450:
4451: l_Proj_Attrib_Rec Pa_Otc_Api.Project_Attribution_Rec;
4452:
4453: l_Msg_Name VARCHAR2(30) := Null;

Line 4509: Fnd_Lookups

4505: Cursor GetBillFlagMeaning(P_Lookup_Code IN VARCHAR2) Is
4506: Select
4507: Meaning
4508: From
4509: Fnd_Lookups
4510: Where
4511: Lookup_Type = 'YES_NO'
4512: And Lookup_Code = P_Lookup_Code;
4513:

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

5315: * in update phase of validation logic and billable no longer
5316: * matches what patc returns.
5317: */
5318:
5319: G_Stage := 'Get translated value for Billable_flag code using fnd_lookups.';
5320: l_Bill_Flag_Meaning := Null;
5321:
5322: G_Stage := 'Open cursor getBillFlagMeaning.';
5323: Open GetBillFlagMeaning(l_Proj_Attrib_Rec.Billable_Flag);

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

5361: * in update phase of validation logic and billable no longer
5362: * matches what patc returns.
5363: */
5364:
5365: G_Stage := 'Get translated value for Billable_flag code using fnd_lookups.';
5366: l_Bill_Flag_Meaning := Null;
5367:
5368: G_Stage := 'Open cursor getBillFlagMeaning.';
5369: Open GetBillFlagMeaning(l_Proj_Attrib_Rec.Billable_Flag);