DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on PA_EXPENDITURES_ALL

Line 12: Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,

8: Task_Id Pa_Tasks.Task_Id%TYPE,
9: Expenditure_Type Pa_Expenditure_Types.Expenditure_Type%TYPE,
10: System_Linkage_Function Pa_System_Linkages.Function%TYPE,
11: Quantity Pa_Expenditure_Items_All.quantity%TYPE,
12: Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
13: Override_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
14: Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
15: Expenditure_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
16: Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,

Line 13: Override_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,

9: Expenditure_Type Pa_Expenditure_Types.Expenditure_Type%TYPE,
10: System_Linkage_Function Pa_System_Linkages.Function%TYPE,
11: Quantity Pa_Expenditure_Items_All.quantity%TYPE,
12: Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
13: Override_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
14: Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
15: Expenditure_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
16: Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
17: Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,

Line 15: Expenditure_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,

11: Quantity Pa_Expenditure_Items_All.quantity%TYPE,
12: Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
13: Override_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
14: Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
15: Expenditure_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
16: Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
17: Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,
18: Attribute2 Pa_Expenditure_Items_All.Attribute1%TYPE,
19: Attribute3 Pa_Expenditure_Items_All.Attribute1%TYPE,

Line 29: Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,

25: Attribute9 Pa_Expenditure_Items_All.Attribute1%TYPE,
26: Attribute10 Pa_Expenditure_Items_All.Attribute1%TYPE,
27: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
28: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
29: Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,
30: Status Varchar2(2000),
31: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,
32: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
33: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,

Line 35: Person_Type Pa_Expenditures_All.Person_Type%TYPE,

31: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,
32: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
33: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,
34: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,
35: Person_Type Pa_Expenditures_All.Person_Type%TYPE,
36: Vendor_Id Pa_Expenditures_All.Vendor_Id%TYPE,
37: PO_Header_Id Number,
38: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,
39: Action Varchar2(30));

Line 36: Vendor_Id Pa_Expenditures_All.Vendor_Id%TYPE,

32: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
33: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,
34: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,
35: Person_Type Pa_Expenditures_All.Person_Type%TYPE,
36: Vendor_Id Pa_Expenditures_All.Vendor_Id%TYPE,
37: PO_Header_Id Number,
38: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,
39: Action Varchar2(30));
40:

Line 62: Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,

58: Sys_Link_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
59: Sys_Link_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
60: Quantity Pa_Expenditure_Items_All.Quantity%TYPE,
61: Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
62: Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
63: Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
64: Attrib_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
65: Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,
66: Attribute2 Pa_Expenditure_Items_All.Attribute2%TYPE,

Line 63: Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,

59: Sys_Link_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
60: Quantity Pa_Expenditure_Items_All.Quantity%TYPE,
61: Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
62: Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
63: Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
64: Attrib_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
65: Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,
66: Attribute2 Pa_Expenditure_Items_All.Attribute2%TYPE,
67: Attribute3 Pa_Expenditure_Items_All.Attribute3%TYPE,

Line 93: Person_Type Pa_Expenditures_All.Person_Type%TYPE,

89: PO_Line_Id_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
90: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,
91: PO_Price_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
92: PO_Price_Type_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
93: Person_Type Pa_Expenditures_All.Person_Type%TYPE,
94: Vendor_Id Pa_EXpenditures_All.Vendor_Id%TYPE,
95: PO_Header_Id Number,
96: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,
97: Action Varchar2(30));

Line 94: Vendor_Id Pa_EXpenditures_All.Vendor_Id%TYPE,

90: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,
91: PO_Price_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
92: PO_Price_Type_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
93: Person_Type Pa_Expenditures_All.Person_Type%TYPE,
94: Vendor_Id Pa_EXpenditures_All.Vendor_Id%TYPE,
95: PO_Header_Id Number,
96: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,
97: Action Varchar2(30));
98:

Line 233: -- P_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE

229: -- P_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
230: -- P_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
231: -- P_Batch_Name Varchar2
232: -- P_User_Id Pa_Expenditure_Items_All.Last_Updated_By%TYPE
233: -- P_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE
234: -- P_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
235:
236: /*------------------------------------------------------------------------- */
237:

Line 243: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,

239: P_Old_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
240: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
241: P_Batch_Name IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
242: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,
243: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,
244: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE);
245:
246: -- =======================================================================
247: -- Start of Comments

Line 857: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE

853: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
854: -- OUT
855: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
856: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
857: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
858: -- X_Pass_Val_Flag - Varchar2
859: -- X_Approval_Status - Hxc_Time_Building_Blocks.Approval_Status%TYPE
860:
861: /*--------------------------------------------------------------------------*/

Line 869: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,

865: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
866: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
867: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table,-- 2672653
868: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
869: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
870: X_Pass_Val_Flag OUT NOCOPY Varchar2,
871: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE);
872:
873: -- =======================================================================

Line 930: -- X_Inc_By_Person_Id - Pa_Expenditures_All.Incurred_By_Person_Id%TYPE

926: -- project friendly format.
927: --
928: -- Parameters :
929: -- OUT
930: -- X_Inc_By_Person_Id - Pa_Expenditures_All.Incurred_By_Person_Id%TYPE
931: -- X_Timecard_Table - Pa_Otc_Api.Timecard_Table
932: -- X_Overriding_Approver_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
933:
934: /*------------------------------------------------------------------------- */

Line 932: -- X_Overriding_Approver_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE

928: -- Parameters :
929: -- OUT
930: -- X_Inc_By_Person_Id - Pa_Expenditures_All.Incurred_By_Person_Id%TYPE
931: -- X_Timecard_Table - Pa_Otc_Api.Timecard_Table
932: -- X_Overriding_Approver_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
933:
934: /*------------------------------------------------------------------------- */
935:
936: Procedure CreateProjTimecardTable

Line 937: (X_Inc_By_Person_Id OUT NOCOPY Pa_Expenditures_All.Incurred_By_Person_Id%TYPE

933:
934: /*------------------------------------------------------------------------- */
935:
936: Procedure CreateProjTimecardTable
937: (X_Inc_By_Person_Id OUT NOCOPY Pa_Expenditures_All.Incurred_By_Person_Id%TYPE
938: ,X_Timecard_Table OUT NOCOPY Pa_Otc_Api.Timecard_Table --2672653
939: ,X_Overriding_Approver_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE);
940:
941:

Line 939: ,X_Overriding_Approver_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE);

935:
936: Procedure CreateProjTimecardTable
937: (X_Inc_By_Person_Id OUT NOCOPY Pa_Expenditures_All.Incurred_By_Person_Id%TYPE
938: ,X_Timecard_Table OUT NOCOPY Pa_Otc_Api.Timecard_Table --2672653
939: ,X_Overriding_Approver_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE);
940:
941:
942: -- =======================================================================
943: -- Start of Comments