APPS.PA_IC_INV_DEL dependencies on PA_DRAFT_INVOICES

Line 35: FROM PA_DRAFT_INVOICES DI

31: CURSOR C_DEL_UNAPPROVED_INV IS
32: SELECT DI.DRAFT_INVOICE_NUM,
33: DI.AGREEMENT_ID,
34: DI.APPROVED_DATE
35: FROM PA_DRAFT_INVOICES DI
36: WHERE DI.PROJECT_ID = P_project_id
37: AND DI.RELEASED_BY_PERSON_ID IS NULL
38: AND
39: (

Line 81: Delete from pa_draft_invoices

77: Update summary project fundings reduce invoiced_amount by the
78: deleting invoice amount;
79: Delete from pa_distribution_warnings ;
80: Delete from pa_draft_invoice_items
81: Delete from pa_draft_invoices
82: // remove the reference to the Invoice from Invoice Details
83: End Loop;
84: *****/
85:

Line 126: delete from pa_draft_invoices

122: IF g1_debug_mode = 'Y' THEN
123: pa_ic_inv_utils.log_message('pa_draft_invoice_items rows deleted = ' || SQL%rowcount);
124: END IF;
125:
126: delete from pa_draft_invoices
127: where project_id = P_PROJECT_ID
128: and draft_invoice_num = l_draft_inv_num;
129:
130: IF g1_debug_mode = 'Y' THEN

Line 131: pa_ic_inv_utils.log_message('pa_draft_invoices rows deleted = ' || SQL%rowcount);

127: where project_id = P_PROJECT_ID
128: and draft_invoice_num = l_draft_inv_num;
129:
130: IF g1_debug_mode = 'Y' THEN
131: pa_ic_inv_utils.log_message('pa_draft_invoices rows deleted = ' || SQL%rowcount);
132: END IF;
133:
134: /* Added denom transfer price and denom tp_currency code for bug 2638956 */
135: /* Added acct_tp columns for bug 5276946 */

Line 310: FROM PA_DRAFT_INVOICES DIA

306: (SELECT SUM(INV_AMOUNT)
307: FROM PA_DRAFT_INVOICE_ITEMS
308: WHERE PROJECT_ID = P_PROJECT_ID
309: AND DRAFT_INVOICE_NUM = P_DRAFT_INVOICE_NUM)
310: FROM PA_DRAFT_INVOICES DIA
311: WHERE PROJECT_ID = P_PROJECT_ID
312: AND DRAFT_INVOICE_NUM = P_DRAFT_INVOICE_NUM
313: );
314: