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_ALL

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 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 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: