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_TXN_INTERFACE_ITEMS_PKG dependencies on PA_TRANSACTION_INTERFACE

Line 71: -- used to populate PA_TRANSACTION_INTERFACE table's

67: X_project_rate_date IN DATE,
68: X_project_rate_type IN VARCHAR2,
69: X_project_exchange_rate IN NUMBER,
70: -- Trx_import enhancement: These new parameters are
71: -- used to populate PA_TRANSACTION_INTERFACE table's
72: -- new columns
73: X_orig_exp_txn_reference1 IN VARCHAR2,
74: X_orig_exp_txn_reference2 IN VARCHAR2,
75: X_orig_exp_txn_reference3 IN VARCHAR2,

Line 97: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,

93: x_cdl_sys_ref4 IN VARCHAR2 DEFAULT NULL,
94: -- PA-J changes
95: x_Accrual_flag IN VARCHAR2 DEFAULT NULL,
96: -- Pa-K Changes
97: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,

Line 98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,

94: -- PA-J changes
95: x_Accrual_flag IN VARCHAR2 DEFAULT NULL,
96: -- Pa-K Changes
97: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,

Line 99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,

95: x_Accrual_flag IN VARCHAR2 DEFAULT NULL,
96: -- Pa-K Changes
97: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,

Line 100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,

96: -- Pa-K Changes
97: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,

Line 101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,

97: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,

Line 102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,

98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,

Line 103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,

99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes

Line 104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,

100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,

Line 105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,

101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,

Line 106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,

102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,

Line 108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,

104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,

Line 109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,

105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,

Line 110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,

106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes

Line 111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,

107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes
115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,

Line 112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,

108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes
115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,

Line 113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,

109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes
115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,

Line 115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,

111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes
115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
118: -- 12i MOAC changes
119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL

Line 116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,

112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes
115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
118: -- 12i MOAC changes
119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL
120: --P_Agreement_Id IN Pa_Transaction_Interface_All.Agreement_Id%TYPE DEFAULT NULL,--FSIO Changes

Line 117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,

113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes
115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
118: -- 12i MOAC changes
119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL
120: --P_Agreement_Id IN Pa_Transaction_Interface_All.Agreement_Id%TYPE DEFAULT NULL,--FSIO Changes
121: --P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL

Line 119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL

115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
118: -- 12i MOAC changes
119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL
120: --P_Agreement_Id IN Pa_Transaction_Interface_All.Agreement_Id%TYPE DEFAULT NULL,--FSIO Changes
121: --P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
122: , P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
123: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL

Line 120: --P_Agreement_Id IN Pa_Transaction_Interface_All.Agreement_Id%TYPE DEFAULT NULL,--FSIO Changes

116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
118: -- 12i MOAC changes
119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL
120: --P_Agreement_Id IN Pa_Transaction_Interface_All.Agreement_Id%TYPE DEFAULT NULL,--FSIO Changes
121: --P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
122: , P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
123: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
124: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL

Line 121: --P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL

117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
118: -- 12i MOAC changes
119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL
120: --P_Agreement_Id IN Pa_Transaction_Interface_All.Agreement_Id%TYPE DEFAULT NULL,--FSIO Changes
121: --P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
122: , P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
123: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
124: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
125: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL

Line 122: , P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL

118: -- 12i MOAC changes
119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL
120: --P_Agreement_Id IN Pa_Transaction_Interface_All.Agreement_Id%TYPE DEFAULT NULL,--FSIO Changes
121: --P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
122: , P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
123: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
124: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
125: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
126: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL

Line 123: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL

119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL
120: --P_Agreement_Id IN Pa_Transaction_Interface_All.Agreement_Id%TYPE DEFAULT NULL,--FSIO Changes
121: --P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
122: , P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
123: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
124: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
125: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
126: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
127: -- Start: Added for CBS Enhancement Bug 16220146

Line 124: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL

120: --P_Agreement_Id IN Pa_Transaction_Interface_All.Agreement_Id%TYPE DEFAULT NULL,--FSIO Changes
121: --P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
122: , P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
123: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
124: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
125: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
126: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
127: -- Start: Added for CBS Enhancement Bug 16220146
128: ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL

Line 125: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL

121: --P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
122: , P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
123: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
124: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
125: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
126: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
127: -- Start: Added for CBS Enhancement Bug 16220146
128: ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL
129: ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL

Line 126: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL

122: , P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
123: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
124: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
125: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
126: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
127: -- Start: Added for CBS Enhancement Bug 16220146
128: ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL
129: ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL
130: -- End: Added for CBS Enhancement Bug 16220146

Line 128: ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL

124: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
125: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
126: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
127: -- Start: Added for CBS Enhancement Bug 16220146
128: ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL
129: ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL
130: -- End: Added for CBS Enhancement Bug 16220146
131: )
132:

Line 129: ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL

125: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
126: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
127: -- Start: Added for CBS Enhancement Bug 16220146
128: ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL
129: ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL
130: -- End: Added for CBS Enhancement Bug 16220146
131: )
132:
133: IS

Line 137: from pa_transaction_interface_all

133: IS
134:
135: cursor return_rowid is
136: select rowid
137: from pa_transaction_interface_all
138: where txn_interface_id = X_txn_interface_id;
139:
140: cursor get_itemid is
141: select pa_txn_interface_s.nextval

Line 154: Insert INTO Pa_Transaction_Interface (

150: Close Get_ItemId;
151:
152: End If;
153:
154: Insert INTO Pa_Transaction_Interface (
155: TRANSACTION_SOURCE ,
156: BATCH_NAME ,
157: EXPENDITURE_ENDING_DATE ,
158: EMPLOYEE_NUMBER ,

Line 470: -- to populate PA_TRANSACTION_INTERFACE table's new

466: x_project_rate_date IN DATE,
467: x_project_rate_type IN VARCHAR2,
468: x_project_exchange_rate IN NUMBER,
469: -- Trx_import enhancement: These parameters are needed
470: -- to populate PA_TRANSACTION_INTERFACE table's new
471: -- columns
472: X_orig_exp_txn_reference1 IN VARCHAR2,
473: X_orig_exp_txn_reference2 IN VARCHAR2,
474: X_orig_exp_txn_reference3 IN VARCHAR2,

Line 495: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,

491: X_Cdl_Sys_Ref4 IN VARCHAR2 DEFAULT NULL,
492: -- PA-J changes
493: X_Accrual_flag IN VARCHAR2 DEFAULT NULL,
494: -- PA-K Changes
495: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
496: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
497: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
498: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
499: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,

Line 496: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,

492: -- PA-J changes
493: X_Accrual_flag IN VARCHAR2 DEFAULT NULL,
494: -- PA-K Changes
495: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
496: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
497: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
498: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
499: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
500: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,

Line 497: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,

493: X_Accrual_flag IN VARCHAR2 DEFAULT NULL,
494: -- PA-K Changes
495: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
496: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
497: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
498: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
499: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
500: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
501: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,

Line 498: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,

494: -- PA-K Changes
495: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
496: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
497: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
498: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
499: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
500: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
501: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
502: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,

Line 499: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,

495: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
496: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
497: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
498: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
499: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
500: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
501: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
502: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
503: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,

Line 500: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,

496: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
497: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
498: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
499: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
500: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
501: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
502: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
503: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
504: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,

Line 501: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,

497: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
498: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
499: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
500: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
501: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
502: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
503: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
504: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
505: -- Begin PA.M/CWK changes

Line 502: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,

498: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
499: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
500: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
501: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
502: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
503: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
504: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
505: -- Begin PA.M/CWK changes
506: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,

Line 503: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,

499: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
500: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
501: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
502: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
503: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
504: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
505: -- Begin PA.M/CWK changes
506: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
507: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,

Line 504: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,

500: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
501: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
502: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
503: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
504: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
505: -- Begin PA.M/CWK changes
506: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
507: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
508: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,

Line 506: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,

502: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
503: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
504: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
505: -- Begin PA.M/CWK changes
506: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
507: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
508: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
509: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
510: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,

Line 507: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,

503: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
504: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
505: -- Begin PA.M/CWK changes
506: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
507: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
508: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
509: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
510: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
511: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,

Line 508: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,

504: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
505: -- Begin PA.M/CWK changes
506: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
507: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
508: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
509: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
510: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
511: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
512: -- End PA.M/CWK changes

Line 509: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,

505: -- Begin PA.M/CWK changes
506: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
507: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
508: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
509: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
510: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
511: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
512: -- End PA.M/CWK changes
513: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,

Line 510: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,

506: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
507: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
508: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
509: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
510: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
511: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
512: -- End PA.M/CWK changes
513: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
514: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,

Line 511: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,

507: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
508: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
509: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
510: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
511: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
512: -- End PA.M/CWK changes
513: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
514: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
515: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,

Line 513: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,

509: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
510: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
511: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
512: -- End PA.M/CWK changes
513: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
514: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
515: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
516: -- P_Agreement_id IN Pa_Transaction_Interface_All.Agreement_id%TYPE DEFAULT NULL, --FSIO Chnages
517: -- P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL

Line 514: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,

510: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
511: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
512: -- End PA.M/CWK changes
513: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
514: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
515: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
516: -- P_Agreement_id IN Pa_Transaction_Interface_All.Agreement_id%TYPE DEFAULT NULL, --FSIO Chnages
517: -- P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
518: P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL

Line 515: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,

511: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
512: -- End PA.M/CWK changes
513: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
514: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
515: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
516: -- P_Agreement_id IN Pa_Transaction_Interface_All.Agreement_id%TYPE DEFAULT NULL, --FSIO Chnages
517: -- P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
518: P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
519: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL

Line 516: -- P_Agreement_id IN Pa_Transaction_Interface_All.Agreement_id%TYPE DEFAULT NULL, --FSIO Chnages

512: -- End PA.M/CWK changes
513: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
514: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
515: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
516: -- P_Agreement_id IN Pa_Transaction_Interface_All.Agreement_id%TYPE DEFAULT NULL, --FSIO Chnages
517: -- P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
518: P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
519: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
520: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL

Line 517: -- P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL

513: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
514: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
515: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
516: -- P_Agreement_id IN Pa_Transaction_Interface_All.Agreement_id%TYPE DEFAULT NULL, --FSIO Chnages
517: -- P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
518: P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
519: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
520: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
521: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL

Line 518: P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL

514: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
515: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
516: -- P_Agreement_id IN Pa_Transaction_Interface_All.Agreement_id%TYPE DEFAULT NULL, --FSIO Chnages
517: -- P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
518: P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
519: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
520: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
521: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
522: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL

Line 519: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL

515: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
516: -- P_Agreement_id IN Pa_Transaction_Interface_All.Agreement_id%TYPE DEFAULT NULL, --FSIO Chnages
517: -- P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
518: P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
519: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
520: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
521: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
522: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
523: -- Start: Added for CBS Enhancement Bug 16220146

Line 520: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL

516: -- P_Agreement_id IN Pa_Transaction_Interface_All.Agreement_id%TYPE DEFAULT NULL, --FSIO Chnages
517: -- P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
518: P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
519: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
520: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
521: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
522: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
523: -- Start: Added for CBS Enhancement Bug 16220146
524: ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL

Line 521: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL

517: -- P_Agreement_number IN Pa_Transaction_Interface_All.Agreement_number%TYPE DEFAULT NULL
518: P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
519: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
520: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
521: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
522: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
523: -- Start: Added for CBS Enhancement Bug 16220146
524: ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL
525: ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL

Line 522: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL

518: P_JOB_ID PA_TRANSACTION_INTERFACE_ALL.JOB_ID%TYPE DEFAULT NULL
519: ,P_JOB_NAME PA_TRANSACTION_INTERFACE_ALL.JOB_NAME%TYPE DEFAULT NULL
520: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
521: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
522: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
523: -- Start: Added for CBS Enhancement Bug 16220146
524: ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL
525: ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL
526: -- End: Added for CBS Enhancement Bug 16220146

Line 524: ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL

520: ,P_LOCATION_ID PA_TRANSACTION_INTERFACE_ALL.LOCATION_ID%TYPE DEFAULT NULL
521: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
522: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
523: -- Start: Added for CBS Enhancement Bug 16220146
524: ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL
525: ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL
526: -- End: Added for CBS Enhancement Bug 16220146
527: )
528: IS

Line 525: ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL

521: ,P_LOCATION_CODE PA_TRANSACTION_INTERFACE_ALL.LOCATION_CODE%TYPE DEFAULT NULL
522: ,P_PAY_ELEMENT_TYPE_ID PA_TRANSACTION_INTERFACE_ALL.PAY_ELEMENT_TYPE_ID%TYPE DEFAULT NULL
523: -- Start: Added for CBS Enhancement Bug 16220146
524: ,P_Cbs_Element_id IN Pa_Transaction_Interface_All.Cbs_Element_Id%TYPE DEFAULT NULL
525: ,P_Cbs_Element_Name IN Pa_Transaction_Interface_All.Cbs_Element_Name%TYPE DEFAULT NULL
526: -- End: Added for CBS Enhancement Bug 16220146
527: )
528: IS
529:

Line 532: Update Pa_Transaction_Interface

528: IS
529:
530: Begin
531:
532: Update Pa_Transaction_Interface
533: Set Transaction_Source = X_transaction_source ,
534: Batch_Name = X_batch_name ,
535: Expenditure_Ending_Date = X_expenditure_end_date ,
536: Employee_Number = X_employee_number ,

Line 656: Delete From Pa_Transaction_Interface_All

652: Is
653:
654: Begin
655:
656: Delete From Pa_Transaction_Interface_All
657: Where RowId = X_RowId ;
658:
659: End Delete_Row;
660:

Line 793: Insert Into Pa_Transaction_Interface(

789:
790: Begin
791:
792: ForAll i in P_Txn_Interface_Id_Tbl.First .. P_Txn_Interface_Id_Tbl.Last
793: Insert Into Pa_Transaction_Interface(
794: Transaction_Source ,
795: Batch_Name ,
796: Expenditure_Ending_Date ,
797: Employee_Number ,

Line 1156: Update Pa_Transaction_Interface

1152:
1153: Begin
1154:
1155: ForAll i in P_Txn_Interface_Id_Tbl.First .. P_Txn_Interface_Id_Tbl.Last
1156: Update Pa_Transaction_Interface
1157: Set Transaction_Source = P_Transaction_Source_Tbl(i) ,
1158: Batch_Name = P_Batch_Name_Tbl(i) ,
1159: Expenditure_Ending_Date = P_Expenditure_End_Date_Tbl(i) ,
1160: Employee_Number = P_Employee_Number_Tbl(i) ,