DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on PA_EXPENDITURE_TYPES

Line 1585: l_Exp_Type Pa_Expenditure_Types.Expenditure_Type%TYPE;

1581: l_Inc_By_Org_Id Hr_Organization_Units.Organization_Id%TYPE;
1582: l_Exp_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE;
1583: l_Proj_Id Pa_Projects_All.Project_Id%TYPE;
1584: l_Task_Id Pa_Tasks.Task_Id%TYPE;
1585: l_Exp_Type Pa_Expenditure_Types.Expenditure_Type%TYPE;
1586: l_Sys_Link Pa_Expenditure_Items_All.System_Linkage_Function%TYPE;
1587: l_Quantity Pa_Expenditure_Items_All.Quantity%TYPE;
1588: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;
1589: l_Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE;

Line 6289: -- P_Expenditure_Type - Pa_Expenditure_Types.Expenditure_Type%TYPE

6285: -- combination exists in the database for the given date.
6286: -- Parameters :
6287: -- IN
6288: -- P_System_Linkage - Pa_System_Linkages.Function%TYPE
6289: -- P_Expenditure_Type - Pa_Expenditure_Types.Expenditure_Type%TYPE
6290: -- P_Exp_Item_date - Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE
6291: -- OUT
6292: -- X_Error_Code - Varchar2
6293: -- X_Error_Type - Varchar2

Line 6299: P_Expenditure_Type IN Pa_Expenditure_Types.Expenditure_Type%TYPE,

6295: /*--------------------------------------------------------------------------*/
6296:
6297: Procedure Validate_Exp_Type_Exists(
6298: P_System_Linkage IN Pa_System_Linkages.Function%TYPE,
6299: P_Expenditure_Type IN Pa_Expenditure_Types.Expenditure_Type%TYPE,
6300: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
6301: X_Error_Type OUT NOCOPY Varchar2,
6302: X_Error_Code OUT NOCOPY Varchar2) Is
6303:

Line 6736: l_Exp_Type Pa_Expenditure_Types.Expenditure_Type%TYPE;

6732:
6733: /*Start -changes for bug:7604482 */
6734: l_Proj_Id Pa_Projects_All.Project_Id%TYPE;
6735: l_Task_Id Pa_Tasks.Task_Id%TYPE;
6736: l_Exp_Type Pa_Expenditure_Types.Expenditure_Type%TYPE;
6737: /*End -changes for bug:7604482 */
6738:
6739: Cursor AdjustmentRecords (P_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) Is
6740: Select