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: -- bug 10253400: Payroll integration enhancement for 12.2..start

Line 69: Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,

65: Sys_Link_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
66: Sys_Link_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
67: Quantity Pa_Expenditure_Items_All.Quantity%TYPE,
68: Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
69: Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
70: Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
71: Attrib_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
72: Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,
73: Attribute2 Pa_Expenditure_Items_All.Attribute2%TYPE,

Line 70: Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,

66: Sys_Link_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
67: Quantity Pa_Expenditure_Items_All.Quantity%TYPE,
68: Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
69: Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
70: Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
71: Attrib_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
72: Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,
73: Attribute2 Pa_Expenditure_Items_All.Attribute2%TYPE,
74: Attribute3 Pa_Expenditure_Items_All.Attribute3%TYPE,

Line 100: Person_Type Pa_Expenditures_All.Person_Type%TYPE,

96: PO_Line_Id_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
97: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,
98: PO_Price_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
99: PO_Price_Type_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
100: Person_Type Pa_Expenditures_All.Person_Type%TYPE,
101: Vendor_Id Pa_EXpenditures_All.Vendor_Id%TYPE,
102: PO_Header_Id Number,
103: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,
104: Action Varchar2(30),

Line 101: Vendor_Id Pa_EXpenditures_All.Vendor_Id%TYPE,

97: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,
98: PO_Price_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
99: PO_Price_Type_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
100: Person_Type Pa_Expenditures_All.Person_Type%TYPE,
101: Vendor_Id Pa_EXpenditures_All.Vendor_Id%TYPE,
102: PO_Header_Id Number,
103: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,
104: Action Varchar2(30),
105: -- bug 10253400: Payroll integration enhancement for 12.2..start

Line 250: -- P_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE

246: -- P_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
247: -- P_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
248: -- P_Batch_Name Varchar2
249: -- P_User_Id Pa_Expenditure_Items_All.Last_Updated_By%TYPE
250: -- P_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE
251: -- P_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
252:
253: /*------------------------------------------------------------------------- */
254:

Line 260: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,

256: P_Old_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
257: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
258: P_Batch_Name IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
259: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,
260: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,
261: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE);
262:
263: -- =======================================================================
264: -- Start of Comments

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

888: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
889: -- OUT
890: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
891: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
892: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
893: -- X_Pass_Val_Flag - Varchar2
894: -- X_Approval_Status - Hxc_Time_Building_Blocks.Approval_Status%TYPE
895:
896: /*--------------------------------------------------------------------------*/

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

900: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
901: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
902: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table,-- 2672653
903: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
904: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
905: X_Pass_Val_Flag OUT NOCOPY Varchar2,
906: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE);
907:
908: -- =======================================================================

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

961: -- project friendly format.
962: --
963: -- Parameters :
964: -- OUT
965: -- X_Inc_By_Person_Id - Pa_Expenditures_All.Incurred_By_Person_Id%TYPE
966: -- X_Timecard_Table - Pa_Otc_Api.Timecard_Table
967: -- X_Overriding_Approver_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
968:
969: /*------------------------------------------------------------------------- */

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

963: -- Parameters :
964: -- OUT
965: -- X_Inc_By_Person_Id - Pa_Expenditures_All.Incurred_By_Person_Id%TYPE
966: -- X_Timecard_Table - Pa_Otc_Api.Timecard_Table
967: -- X_Overriding_Approver_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
968:
969: /*------------------------------------------------------------------------- */
970:
971: Procedure CreateProjTimecardTable

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

968:
969: /*------------------------------------------------------------------------- */
970:
971: Procedure CreateProjTimecardTable
972: (X_Inc_By_Person_Id OUT NOCOPY Pa_Expenditures_All.Incurred_By_Person_Id%TYPE
973: ,X_Timecard_Table OUT NOCOPY Pa_Otc_Api.Timecard_Table --2672653
974: ,X_Overriding_Approver_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE);
975:
976:

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

970:
971: Procedure CreateProjTimecardTable
972: (X_Inc_By_Person_Id OUT NOCOPY Pa_Expenditures_All.Incurred_By_Person_Id%TYPE
973: ,X_Timecard_Table OUT NOCOPY Pa_Otc_Api.Timecard_Table --2672653
974: ,X_Overriding_Approver_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE);
975:
976:
977: -- =======================================================================
978: -- Start of Comments