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 41: Job_Id Pa_Expenditure_Items_All.Job_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
41: Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE,
42: Location_Id Pa_Expenditure_Items_All.Location_ID%TYPE,
43: Pay_Element_Type_Id PA_Expenditure_Items_All.Pay_Element_Type_Id%TYPE
44: -- bug 10253400: Payroll integration enhancement for 12.2..end
45: ,Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE -- Added for CBS Enhancement Bug 16220146

Line 42: Location_Id Pa_Expenditure_Items_All.Location_ID%TYPE,

38: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,
39: Action Varchar2(30),
40: -- bug 10253400: Payroll integration enhancement for 12.2..start
41: Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE,
42: Location_Id Pa_Expenditure_Items_All.Location_ID%TYPE,
43: Pay_Element_Type_Id PA_Expenditure_Items_All.Pay_Element_Type_Id%TYPE
44: -- bug 10253400: Payroll integration enhancement for 12.2..end
45: ,Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE -- Added for CBS Enhancement Bug 16220146
46: );

Line 43: Pay_Element_Type_Id PA_Expenditure_Items_All.Pay_Element_Type_Id%TYPE

39: Action Varchar2(30),
40: -- bug 10253400: Payroll integration enhancement for 12.2..start
41: Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE,
42: Location_Id Pa_Expenditure_Items_All.Location_ID%TYPE,
43: Pay_Element_Type_Id PA_Expenditure_Items_All.Pay_Element_Type_Id%TYPE
44: -- bug 10253400: Payroll integration enhancement for 12.2..end
45: ,Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE -- Added for CBS Enhancement Bug 16220146
46: );
47:

Line 45: ,Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE -- Added for CBS Enhancement Bug 16220146

41: Job_Id Pa_Expenditure_Items_All.Job_Id%TYPE,
42: Location_Id Pa_Expenditure_Items_All.Location_ID%TYPE,
43: Pay_Element_Type_Id PA_Expenditure_Items_All.Pay_Element_Type_Id%TYPE
44: -- bug 10253400: Payroll integration enhancement for 12.2..end
45: ,Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE -- Added for CBS Enhancement Bug 16220146
46: );
47:
48: TYPE Timecard_Table IS Table OF Timecard_Rec
49: INDEX BY Binary_Integer;

Line 67: Quantity Pa_Expenditure_Items_All.Quantity%TYPE,

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

Line 68: Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,

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

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

Line 72: Attribute1 Pa_Expenditure_Items_All.Attribute1%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,
75: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
76: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,

Line 73: Attribute2 Pa_Expenditure_Items_All.Attribute2%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,
75: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
76: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
77: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,

Line 74: Attribute3 Pa_Expenditure_Items_All.Attribute3%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,
75: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
76: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
77: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
78: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,

Line 75: Attribute4 Pa_Expenditure_Items_All.Attribute4%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,
75: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
76: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
77: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
78: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
79: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,

Line 76: Attribute5 Pa_Expenditure_Items_All.Attribute5%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,
75: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
76: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
77: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
78: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
79: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
80: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,

Line 77: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,

73: Attribute2 Pa_Expenditure_Items_All.Attribute2%TYPE,
74: Attribute3 Pa_Expenditure_Items_All.Attribute3%TYPE,
75: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
76: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
77: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
78: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
79: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
80: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,
81: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,

Line 78: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,

74: Attribute3 Pa_Expenditure_Items_All.Attribute3%TYPE,
75: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
76: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
77: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
78: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
79: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
80: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,
81: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,
82: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,

Line 79: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,

75: Attribute4 Pa_Expenditure_Items_All.Attribute4%TYPE,
76: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
77: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
78: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
79: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
80: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,
81: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,
82: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
83: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,

Line 80: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,

76: Attribute5 Pa_Expenditure_Items_All.Attribute5%TYPE,
77: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
78: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
79: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
80: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,
81: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,
82: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
83: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
84: Billable_Flag_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

Line 81: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,

77: Attribute6 Pa_Expenditure_Items_All.Attribute6%TYPE,
78: Attribute7 Pa_Expenditure_Items_All.Attribute7%TYPE,
79: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
80: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,
81: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,
82: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
83: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
84: Billable_Flag_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
85: Billable_Flag_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

Line 83: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,

79: Attribute8 Pa_Expenditure_Items_All.Attribute8%TYPE,
80: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,
81: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,
82: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
83: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
84: Billable_Flag_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
85: Billable_Flag_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
86: Billable_Flag2 Pa_Expenditure_Items_All.Billable_Flag%TYPE,
87: Billable_Flag_Index Binary_Integer,

Line 86: Billable_Flag2 Pa_Expenditure_Items_All.Billable_Flag%TYPE,

82: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
83: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
84: Billable_Flag_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
85: Billable_Flag_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
86: Billable_Flag2 Pa_Expenditure_Items_All.Billable_Flag%TYPE,
87: Billable_Flag_Index Binary_Integer,
88: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,
89: Work_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
90: Work_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

Line 88: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,

84: Billable_Flag_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
85: Billable_Flag_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
86: Billable_Flag2 Pa_Expenditure_Items_All.Billable_Flag%TYPE,
87: Billable_Flag_Index Binary_Integer,
88: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,
89: Work_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
90: Work_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
91: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
92: Assignment_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

Line 91: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,

87: Billable_Flag_Index Binary_Integer,
88: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,
89: Work_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
90: Work_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
91: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
92: Assignment_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
93: Assignment_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
94: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,
95: PO_Line_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

Line 94: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,

90: Work_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
91: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
92: Assignment_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
93: Assignment_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
94: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,
95: PO_Line_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%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,

Line 97: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,

93: Assignment_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
94: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,
95: PO_Line_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%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,

Line 106: Job_Id PA_Expenditure_Items_All.Job_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
106: Job_Id PA_Expenditure_Items_All.Job_ID%TYPE,
107: Job_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
108: Location_Id PA_Expenditure_Items_All.Location_Id%TYPE,
109: Location_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
110: Pay_Element_Type_Id PA_Expenditure_Items_All.Pay_Element_Type_Id%TYPE,

Line 108: Location_Id PA_Expenditure_Items_All.Location_Id%TYPE,

104: Action Varchar2(30),
105: -- bug 10253400: Payroll integration enhancement for 12.2..start
106: Job_Id PA_Expenditure_Items_All.Job_ID%TYPE,
107: Job_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
108: Location_Id PA_Expenditure_Items_All.Location_Id%TYPE,
109: Location_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
110: Pay_Element_Type_Id PA_Expenditure_Items_All.Pay_Element_Type_Id%TYPE,
111: Pay_Element_Type_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE
112: -- bug 10253400: Payroll integration enhancement for 12.2..end

Line 110: Pay_Element_Type_Id PA_Expenditure_Items_All.Pay_Element_Type_Id%TYPE,

106: Job_Id PA_Expenditure_Items_All.Job_ID%TYPE,
107: Job_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
108: Location_Id PA_Expenditure_Items_All.Location_Id%TYPE,
109: Location_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
110: Pay_Element_Type_Id PA_Expenditure_Items_All.Pay_Element_Type_Id%TYPE,
111: Pay_Element_Type_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE
112: -- bug 10253400: Payroll integration enhancement for 12.2..end
113: ,Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE -- Added for CBS Enhancement Bug 16220146
114: );

Line 113: ,Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE -- Added for CBS Enhancement Bug 16220146

109: Location_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
110: Pay_Element_Type_Id PA_Expenditure_Items_All.Pay_Element_Type_Id%TYPE,
111: Pay_Element_Type_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE
112: -- bug 10253400: Payroll integration enhancement for 12.2..end
113: ,Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE -- Added for CBS Enhancement Bug 16220146
114: );
115:
116: G_timecard_table Timecard_Table;
117:

Line 246: -- P_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

242: -- quantity
243: --
244: -- Parameters :
245: -- IN
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

Line 247: -- P_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE

243: --
244: -- Parameters :
245: -- IN
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

Line 249: -- P_User_Id Pa_Expenditure_Items_All.Last_Updated_By%TYPE

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

Line 256: P_Old_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

252:
253: /*------------------------------------------------------------------------- */
254:
255: Procedure Build_Reverse_Item(
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,

Line 257: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

253: /*------------------------------------------------------------------------- */
254:
255: Procedure Build_Reverse_Item(
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);

Line 259: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,

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

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

277: -- D for Dff
278: -- B for Both
279: --
280: -- Parameters :
281: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
282: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
283: -- P_Comment_Or_Dff - Varchar2
284: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec
285: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE

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

278: -- B for Both
279: --
280: -- Parameters :
281: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
282: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
283: -- P_Comment_Or_Dff - Varchar2
284: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec
285: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE
286: --

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

281: -- IN P_Old_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
282: -- P_New_Orig_Txn_Ref - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
283: -- P_Comment_Or_Dff - Varchar2
284: -- P_Timecard_Rec - Pa_Otc_Api.Timecard_Rec
285: -- P_User_Id - Pa_Expenditure_Items_All.Last_Updated_By%TYPE
286: --
287: -- OUT NONE
288: --
289:

Line 293: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

289:
290: /*--------------------------------------------------------------------------*/
291:
292: Procedure UpdateChangedOrigTxn(
293: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
294: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
295: P_Comment_Or_Dff IN Varchar2,
296: P_Timecard_Rec IN Pa_Otc_Api.Timecard_Rec,
297: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE);

Line 294: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

290: /*--------------------------------------------------------------------------*/
291:
292: Procedure UpdateChangedOrigTxn(
293: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
294: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
295: P_Comment_Or_Dff IN Varchar2,
296: P_Timecard_Rec IN Pa_Otc_Api.Timecard_Rec,
297: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE);
298:

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

293: P_Old_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
294: P_New_Orig_Txn_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
295: P_Comment_Or_Dff IN Varchar2,
296: P_Timecard_Rec IN Pa_Otc_Api.Timecard_Rec,
297: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE);
298:
299: -- =======================================================================
300: -- Start of Comments
301: -- API Name : Tieback_Otc_Timecards

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

597: -- Parameters :
598: -- IN
599: -- P_System_Linkage - Pa_System_Linkages.Function%TYPE
600: -- P_Expenditure_Type - Pa_Expenditure_Types.Expenditure_Type%TYPE
601: -- P_Exp_Item_date - Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE
602: -- OUT
603: -- X_Error_Code - Varchar2
604: -- X_Error_Type - Varchar2
605:

Line 611: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,

607:
608: Procedure Validate_Exp_Type_Exists(
609: P_System_Linkage IN Pa_System_Linkages.Function%TYPE,
610: P_Expenditure_Type IN Pa_Expenditure_Types.Expenditure_Type%TYPE,
611: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
612: X_Error_Type OUT NOCOPY Varchar2,
613: X_Error_Code OUT NOCOPY Varchar2);
614:
615: Procedure Validate_Job_Exists(

Line 616: P_Job_Id IN Pa_Expenditure_items_All.Job_Id%TYPE,

612: X_Error_Type OUT NOCOPY Varchar2,
613: X_Error_Code OUT NOCOPY Varchar2);
614:
615: Procedure Validate_Job_Exists(
616: P_Job_Id IN Pa_Expenditure_items_All.Job_Id%TYPE,
617: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
618: X_Error_Code OUT NOCOPY Varchar2,
619: X_Error_Type OUT NOCOPY Varchar2);
620:

Line 617: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,

613: X_Error_Code OUT NOCOPY Varchar2);
614:
615: Procedure Validate_Job_Exists(
616: P_Job_Id IN Pa_Expenditure_items_All.Job_Id%TYPE,
617: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
618: X_Error_Code OUT NOCOPY Varchar2,
619: X_Error_Type OUT NOCOPY Varchar2);
620:
621: Procedure Validate_Work_Type_Exists(

Line 623: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,

619: X_Error_Type OUT NOCOPY Varchar2);
620:
621: Procedure Validate_Work_Type_Exists(
622: P_Work_Type_Id IN PA_Work_Types_B.Work_Type_Id%TYPE,
623: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
624: X_Error_Code OUT NOCOPY Varchar2,
625: X_Error_Type OUT NOCOPY Varchar2);
626:
627: Procedure Validate_Location_Exists(

Line 629: Pa_Expenditure_Items_All.Location_ID%TYPE,

625: X_Error_Type OUT NOCOPY Varchar2);
626:
627: Procedure Validate_Location_Exists(
628: p_location_id IN
629: Pa_Expenditure_Items_All.Location_ID%TYPE,
630: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
631: X_Error_Code OUT NOCOPY Varchar2,
632: X_Error_Type OUT NOCOPY Varchar2);
633:

Line 630: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,

626:
627: Procedure Validate_Location_Exists(
628: p_location_id IN
629: Pa_Expenditure_Items_All.Location_ID%TYPE,
630: P_Exp_Item_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
631: X_Error_Code OUT NOCOPY Varchar2,
632: X_Error_Type OUT NOCOPY Varchar2);
633:
634: -- ===========================================================================

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

714: -- has been imported into Projects can adjusted in Projects. Will be calling
715: -- an OTC API to determine this. Hxc_Integration_Layer_V1_Grp.Time_Bld_Blk_Changed().
716: --
717: -- Parameters :
718: -- IN P_Orig_Txn_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
719: -- OUT X_Flag - Boolean
720: --
721:
722: /*--------------------------------------------------------------------------*/

Line 725: P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,

721:
722: /*--------------------------------------------------------------------------*/
723:
724: Procedure AdjustAllowedToOTCItem(
725: P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
726: X_Flag OUT NOCOPY Boolean);
727:
728:
729: -- =======================================================================

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

988: -- projects does not recognize and doesn't want to, thus the ovn changes in OTL.)
989: --
990: -- Parameters :
991: -- IN
992: -- P_Orig_Transaction_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
993:
994: /*------------------------------------------------------------------------- */
995:
996: Function OrigTrxRefValueExists

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

993:
994: /*------------------------------------------------------------------------- */
995:
996: Function OrigTrxRefValueExists
997: ( P_Orig_Transaction_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) RETURN Boolean;
998: -- Pragma RESTRICT_REFERENCES ( OrigTrxRefValueExists, WNPS );
999:
1000:
1001: -- =======================================================================

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

1008: -- has been imported into Projects can adjusted in Projects by calling the
1009: -- API Hxc_Generic_Retrieval_Utils.Time_Bld_Blk_Changed.
1010: --
1011: -- Parameters :
1012: -- IN P_Orig_Txn_Reference - Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1013: --
1014: /*--------------------------------------------------------------------------*/
1015:
1016: Function ChkAdjustAllowedToOTCItem

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

1013: --
1014: /*--------------------------------------------------------------------------*/
1015:
1016: Function ChkAdjustAllowedToOTCItem
1017: (P_Orig_Txn_Reference IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) RETURN Varchar2;
1018:
1019: -- =======================================================================
1020: -- Start of Comments
1021: -- API Name : GetBatchName