eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_OTC_API dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 11: Quantity Pa_Expenditure_Items_All.quantity%TYPE,

7: Task_Number Pa_Tasks.Task_Number%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,

Line 14: Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%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,
18: Attribute2 Pa_Expenditure_Items_All.Attribute1%TYPE,

Line 16: Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%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,
20: Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,

Line 17: Attribute1 Pa_Expenditure_Items_All.Attribute1%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,
20: Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
21: Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,

Line 18: Attribute2 Pa_Expenditure_Items_All.Attribute1%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,
20: Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
21: Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
22: Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,

Line 19: Attribute3 Pa_Expenditure_Items_All.Attribute1%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,
20: Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
21: Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
22: Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
23: Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,

Line 20: Attribute4 Pa_Expenditure_Items_All.Attribute1%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,
20: Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
21: Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
22: Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
23: Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
24: Attribute8 Pa_Expenditure_Items_All.Attribute1%TYPE,

Line 21: Attribute5 Pa_Expenditure_Items_All.Attribute1%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,
20: Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
21: Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
22: Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
23: Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
24: Attribute8 Pa_Expenditure_Items_All.Attribute1%TYPE,
25: Attribute9 Pa_Expenditure_Items_All.Attribute1%TYPE,

Line 22: Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,

18: Attribute2 Pa_Expenditure_Items_All.Attribute1%TYPE,
19: Attribute3 Pa_Expenditure_Items_All.Attribute1%TYPE,
20: Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
21: Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
22: Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
23: Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
24: Attribute8 Pa_Expenditure_Items_All.Attribute1%TYPE,
25: Attribute9 Pa_Expenditure_Items_All.Attribute1%TYPE,
26: Attribute10 Pa_Expenditure_Items_All.Attribute1%TYPE,

Line 23: Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,

19: Attribute3 Pa_Expenditure_Items_All.Attribute1%TYPE,
20: Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
21: Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
22: Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
23: Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
24: Attribute8 Pa_Expenditure_Items_All.Attribute1%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,

Line 24: Attribute8 Pa_Expenditure_Items_All.Attribute1%TYPE,

20: Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
21: Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
22: Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
23: Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
24: Attribute8 Pa_Expenditure_Items_All.Attribute1%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,

Line 25: Attribute9 Pa_Expenditure_Items_All.Attribute1%TYPE,

21: Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
22: Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
23: Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
24: Attribute8 Pa_Expenditure_Items_All.Attribute1%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,

Line 26: Attribute10 Pa_Expenditure_Items_All.Attribute1%TYPE,

22: Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
23: Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
24: Attribute8 Pa_Expenditure_Items_All.Attribute1%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),

Line 27: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,

23: Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
24: Attribute8 Pa_Expenditure_Items_All.Attribute1%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,

Line 31: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%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,
34: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,
35: Person_Type Pa_Expenditures_All.Person_Type%TYPE,

Line 32: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%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,
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,

Line 33: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%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,
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,

Line 34: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%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,
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,

Line 60: Quantity Pa_Expenditure_Items_All.Quantity%TYPE,

56: Exp_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
57: Sys_Linkage_Func Pa_Expenditure_Types.System_Linkage_Function%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,

Line 61: Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,

57: Sys_Linkage_Func Pa_Expenditure_Types.System_Linkage_Function%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,

Line 64: Attrib_Category Pa_Expenditure_Items_All.Attribute_Category%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,
68: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,

Line 65: Attribute1 Pa_Expenditure_Items_All.Attribute1%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,
68: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
69: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,

Line 66: Attribute2 Pa_Expenditure_Items_All.Attribute2%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,
68: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
69: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
70: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,

Line 67: Attribute3 Pa_Expenditure_Items_All.Attribute3%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,
68: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
69: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
70: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
71: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,

Line 68: Attribute4 Pa_Expenditure_Items_All.Attribute4%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,
68: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
69: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
70: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
71: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
72: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,

Line 69: Attribute5 Pa_Expenditure_Items_All.Attribute5%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,
68: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
69: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
70: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
71: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
72: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
73: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,

Line 70: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,

66: Attribute2 Pa_Expenditure_Items_All.Attribute2%TYPE,
67: Attribute3 Pa_Expenditure_Items_All.Attribute3%TYPE,
68: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
69: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
70: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
71: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
72: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
73: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,
74: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,

Line 71: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,

67: Attribute3 Pa_Expenditure_Items_All.Attribute3%TYPE,
68: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
69: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
70: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
71: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
72: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
73: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,
74: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,
75: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,

Line 72: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,

68: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
69: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
70: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
71: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
72: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
73: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,
74: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,
75: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
76: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,

Line 73: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,

69: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
70: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
71: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
72: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
73: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,
74: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,
75: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
76: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
77: Billable_Flag_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

Line 74: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,

70: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
71: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
72: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
73: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,
74: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,
75: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
76: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
77: Billable_Flag_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
78: Billable_Flag_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

Line 76: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,

72: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
73: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,
74: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,
75: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
76: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
77: Billable_Flag_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
78: Billable_Flag_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
79: Billable_Flag2 Pa_Expenditure_Items_All.Billable_Flag%TYPE,
80: Billable_Flag_Index Binary_Integer,

Line 79: Billable_Flag2 Pa_Expenditure_Items_All.Billable_Flag%TYPE,

75: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
76: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
77: Billable_Flag_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
78: Billable_Flag_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
79: Billable_Flag2 Pa_Expenditure_Items_All.Billable_Flag%TYPE,
80: Billable_Flag_Index Binary_Integer,
81: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,
82: Work_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
83: Work_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

Line 81: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,

77: Billable_Flag_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
78: Billable_Flag_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
79: Billable_Flag2 Pa_Expenditure_Items_All.Billable_Flag%TYPE,
80: Billable_Flag_Index Binary_Integer,
81: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,
82: Work_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
83: Work_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
84: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
85: Assignment_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

Line 84: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,

80: Billable_Flag_Index Binary_Integer,
81: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,
82: Work_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
83: Work_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
84: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
85: Assignment_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
86: Assignment_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
87: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,
88: PO_Line_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

Line 87: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,

83: Work_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
84: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
85: Assignment_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
86: Assignment_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
87: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,
88: PO_Line_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%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,

Line 90: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,

86: Assignment_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
87: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,
88: PO_Line_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%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,

Line 229: -- P_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

225: -- quantity
226: --
227: -- Parameters :
228: -- IN
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

Line 230: -- P_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

226: --
227: -- Parameters :
228: -- IN
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

Line 232: -- P_User_Id Pa_Expenditure_Items_All.Last_Updated_By%TYPE

228: -- IN
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: /*------------------------------------------------------------------------- */

Line 239: P_Old_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

235:
236: /*------------------------------------------------------------------------- */
237:
238: Procedure Build_Reverse_Item(
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,

Line 240: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

236: /*------------------------------------------------------------------------- */
237:
238: Procedure Build_Reverse_Item(
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);

Line 242: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,

238: Procedure Build_Reverse_Item(
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: -- =======================================================================

Line 264: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

260: -- D for Dff
261: -- B for Both
262: --
263: -- Parameters :
264: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
265: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
266: -- P_Comment_Or_Dff - Varchar2
267: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec
268: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE

Line 265: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

261: -- B for Both
262: --
263: -- Parameters :
264: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
265: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
266: -- P_Comment_Or_Dff - Varchar2
267: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec
268: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE
269: --

Line 268: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE

264: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
265: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
266: -- P_Comment_Or_Dff - Varchar2
267: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec
268: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE
269: --
270: -- OUT NONE
271: --
272:

Line 276: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

272:
273: /*--------------------------------------------------------------------------*/
274:
275: Procedure UpdateChangedOrigTxn(
276: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
277: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
278: P_Comment_Or_Dff IN Varchar2,
279: P_Timecard_Rec IN Pa_Otc_Api.Timecard_Rec,
280: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE);

Line 277: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

273: /*--------------------------------------------------------------------------*/
274:
275: Procedure UpdateChangedOrigTxn(
276: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
277: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
278: P_Comment_Or_Dff IN Varchar2,
279: P_Timecard_Rec IN Pa_Otc_Api.Timecard_Rec,
280: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE);
281:

Line 280: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE);

276: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
277: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
278: P_Comment_Or_Dff IN Varchar2,
279: P_Timecard_Rec IN Pa_Otc_Api.Timecard_Rec,
280: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE);
281:
282: -- =======================================================================
283: -- Start of Comments
284: -- API Name : Tieback_Otc_Timecards

Line 584: -- P_Exp_Item_date - Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE

580: -- Parameters :
581: -- IN
582: -- P_System_Linkage - Pa_System_Linkages.Function%TYPE
583: -- P_Expenditure_Type - Pa_Expenditure_Types.Expenditure_Type%TYPE
584: -- P_Exp_Item_date - Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE
585: -- OUT
586: -- X_Error_Code - Varchar2
587: -- X_Error_Type - Varchar2
588:

Line 594: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,

590:
591: Procedure Validate_Exp_Type_Exists(
592: P_System_Linkage IN Pa_System_Linkages.Function%TYPE,
593: P_Expenditure_Type IN Pa_Expenditure_Types.Expenditure_Type%TYPE,
594: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
595: X_Error_Type OUT NOCOPY Varchar2,
596: X_Error_Code OUT NOCOPY Varchar2);
597:
598:

Line 683: -- IN P_Orig_Txn_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

679: -- has been imported into Projects can adjusted in Projects. Will be calling
680: -- an OTC API to determine this. Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed().
681: --
682: -- Parameters :
683: -- IN P_Orig_Txn_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
684: -- OUT X_Flag - Boolean
685: --
686:
687: /*--------------------------------------------------------------------------*/

Line 690: P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

686:
687: /*--------------------------------------------------------------------------*/
688:
689: Procedure AdjustAllowedToOTCItem(
690: P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
691: X_Flag OUT NOCOPY Boolean);
692:
693:
694: -- =======================================================================

Line 957: -- P_Orig_Transaction_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

953: -- projects does not recognize and doesn't want to, thus the ovn changes in OTL.)
954: --
955: -- Parameters :
956: -- IN
957: -- P_Orig_Transaction_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
958:
959: /*------------------------------------------------------------------------- */
960:
961: Function OrigTrxRefValueExists

Line 962: ( P_Orig_Transaction_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) RETURN Boolean;

958:
959: /*------------------------------------------------------------------------- */
960:
961: Function OrigTrxRefValueExists
962: ( P_Orig_Transaction_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) RETURN Boolean;
963: -- Pragma RESTRICT_REFERENCES ( OrigTrxRefValueExists, WNPS );
964:
965:
966: -- =======================================================================

Line 977: -- IN P_Orig_Txn_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

973: -- has been imported into Projects can adjusted in Projects by calling the
974: -- API Hxc_Generic_Retrieval_Utils.Time_Bld_Blk_Changed.
975: --
976: -- Parameters :
977: -- IN P_Orig_Txn_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
978: --
979: /*--------------------------------------------------------------------------*/
980:
981: Function ChkAdjustAllowedToOTCItem

Line 982: (P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) RETURN Varchar2;

978: --
979: /*--------------------------------------------------------------------------*/
980:
981: Function ChkAdjustAllowedToOTCItem
982: (P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) RETURN Varchar2;
983:
984: -- =======================================================================
985: -- Start of Comments
986: -- API Name : GetBatchName