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 213: from PA_DRAFT_INVOICE_DETAILS

209: projfunc_tp_rate_date = NULL,
210: projfunc_tp_exchange_rate = NULL
211: where source_expenditure_item_id in
212: ( select expenditure_item_id
213: from PA_DRAFT_INVOICE_DETAILS
214: Where Project_id = P_project_id
215: and Draft_Invoice_Num = L_draft_inv_num
216: );
217:

Line 224: Update PA_DRAFT_INVOICE_DETAILS

220: END IF;
221:
222: /*End of code changes for Bug 6651747 */
223:
224: Update PA_DRAFT_INVOICE_DETAILS
225: Set draft_invoice_num = NULL,
226: draft_invoice_line_num = NULL,
227: last_update_date = SYSDATE,
228: last_update_login = l_user_id,

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

231: Where Project_id = P_project_id
232: and Draft_Invoice_Num = L_draft_inv_num;
233:
234: IF g1_debug_mode = 'Y' THEN
235: pa_ic_inv_utils.log_message('PA_DRAFT_INVOICE_DETAILS rows updated = ' || SQL%rowcount);
236: END IF;
237:
238: /* Commented for bug 1849569
239: pa_ic_inv_utils.commit_invoice;*/