APPS.PA_IC_INV_DEL dependencies on PA_DISTRIBUTION_WARNINGS

Line 79: Delete from pa_distribution_warnings ;

75: For each Draft_Invoice_num
76: Loop
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;

Line 105: delete from pa_distribution_warnings

101: l_agreement_id,
102: p_project_id,
103: 'DELETE' );
104:
105: delete from pa_distribution_warnings
106: where project_id = P_PROJECT_ID
107: and draft_invoice_num = l_draft_inv_num;
108:
109: IF g1_debug_mode = 'Y' THEN

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

106: where project_id = P_PROJECT_ID
107: and draft_invoice_num = l_draft_inv_num;
108:
109: IF g1_debug_mode = 'Y' THEN
110: pa_ic_inv_utils.log_message('pa_distribution_warnings rows deleted = ' || SQL%rowcount);
111: END IF;
112:
113: if p_mass_delete = 'Y' then /*Added for bug 7026205*/
114: insert_dist_warnings(p_project_id,

Line 265: INSERT INTO PA_DISTRIBUTION_WARNINGS

261: IS
262:
263: BEGIN
264:
265: INSERT INTO PA_DISTRIBUTION_WARNINGS
266: (
267: PROJECT_ID,
268: DRAFT_INVOICE_NUM,
269: LAST_UPDATE_DATE,