APPS.PA_IC_INV_DEL dependencies on PA_DRAFT_INVOICE_DETAILS

Line 164: from PA_DRAFT_INVOICE_DETAILS

160: projfunc_tp_rate_date = NULL,
161: projfunc_tp_exchange_rate = NULL
162: where expenditure_item_id in
163: ( select expenditure_item_id
164: from PA_DRAFT_INVOICE_DETAILS
165: Where Project_id = P_project_id
166: and Draft_Invoice_Num = L_draft_inv_num
167: )
168: and (adjusted_expenditure_item_id is null /*Clause added for Bug 6899120*/

Line 172: from PA_DRAFT_INVOICE_DETAILS

168: and (adjusted_expenditure_item_id is null /*Clause added for Bug 6899120*/
169: or (adjusted_expenditure_item_id is not null and
170: /* adjusted_expenditure_item_id in
171: ( select expenditure_item_id
172: from PA_DRAFT_INVOICE_DETAILS
173: Where Project_id = P_project_id
174: and Draft_Invoice_Num = L_draft_inv_num
175: )
176: )

Line 180: from PA_DRAFT_INVOICE_DETAILS PADI,

176: )
177: ); 9203389 */
178: expenditure_item_id in /* 9203389 */
179: ( select PADI.expenditure_item_id
180: from PA_DRAFT_INVOICE_DETAILS PADI,
181: PA_DRAFT_INVOICE_DETAILS PADI2
182: Where PADI2.expenditure_item_id = EI.adjusted_expenditure_item_id
183: and PADI.orig_draft_invoice_num = PADI2.draft_invoice_num
184: and PADI2.project_id = P_project_id

Line 181: PA_DRAFT_INVOICE_DETAILS PADI2

177: ); 9203389 */
178: expenditure_item_id in /* 9203389 */
179: ( select PADI.expenditure_item_id
180: from PA_DRAFT_INVOICE_DETAILS PADI,
181: PA_DRAFT_INVOICE_DETAILS PADI2
182: Where PADI2.expenditure_item_id = EI.adjusted_expenditure_item_id
183: and PADI.orig_draft_invoice_num = PADI2.draft_invoice_num
184: and PADI2.project_id = P_project_id
185: and PADI.project_id = P_project_id

Line 225: from PA_DRAFT_INVOICE_DETAILS

221: projfunc_tp_rate_date = NULL,
222: projfunc_tp_exchange_rate = NULL
223: where source_expenditure_item_id in
224: ( select expenditure_item_id
225: from PA_DRAFT_INVOICE_DETAILS
226: Where Project_id = P_project_id
227: and Draft_Invoice_Num = L_draft_inv_num
228: );
229:

Line 236: Update PA_DRAFT_INVOICE_DETAILS

232: END IF;
233:
234: /*End of code changes for Bug 6651747 */
235:
236: Update PA_DRAFT_INVOICE_DETAILS
237: Set draft_invoice_num = NULL,
238: draft_invoice_line_num = NULL,
239: last_update_date = SYSDATE,
240: last_update_login = l_user_id,

Line 247: pa_ic_inv_utils.log_message('PA_DRAFT_INVOICE_DETAILS rows updated = ' || SQL%rowcount);

243: Where Project_id = P_project_id
244: and Draft_Invoice_Num = L_draft_inv_num;
245:
246: IF g1_debug_mode = 'Y' THEN
247: pa_ic_inv_utils.log_message('PA_DRAFT_INVOICE_DETAILS rows updated = ' || SQL%rowcount);
248: END IF;
249:
250: /* Commented for bug 1849569
251: pa_ic_inv_utils.commit_invoice;*/