APPS.PA_IC_INV_CNL dependencies on PA_DRAFT_INVOICES

Line 106: Update pa_draft_invoices

102: */
103:
104: -- This update statement also returns the agreement_id
105: --
106: Update pa_draft_invoices
107: Set canceled_flag = 'Y',
108: invoice_comment =
109: (select rtrim(upper(l.meaning)||' '||
110: rtrim(substrb(i.invoice_comment,1,232)))

Line 112: pa_draft_invoices i

108: invoice_comment =
109: (select rtrim(upper(l.meaning)||' '||
110: rtrim(substrb(i.invoice_comment,1,232)))
111: from pa_lookups l,
112: pa_draft_invoices i
113: where i.project_id = p_project_id
114: and i.draft_invoice_num = p_draft_inv_num
115: and l.lookup_type = 'INVOICE_CREDIT_TYPE'
116: AND l.lookup_code = 'CANCEL'

Line 129: from pa_draft_invoices di

125: and nvl(canceled_flag, 'N') <> 'Y'
126: and not exists
127: (
128: select null
129: from pa_draft_invoices di
130: where di.project_id = P_PROJECT_ID
131: and di.draft_invoice_num_credited = P_DRAFT_INV_NUM
132: )
133: returning agreement_id into l_agreement_id;

Line 148: pa_ic_inv_utils.log_message('Updating pa_draft_invoices rows = '||

144: RAISE INV_CANCELED_OR_CREDIT_MEMO ;
145: end if;
146:
147: IF g1_debug_mode = 'Y' THEN
148: pa_ic_inv_utils.log_message('Updating pa_draft_invoices rows = '||
149: SQL%ROWCOUNT);
150: pa_ic_inv_utils.log_message('cancel_invoice: ' || 'Agreement id returned = '||
151: l_agreement_id);
152: END IF;

Line 171: INSERT INTO PA_DRAFT_INVOICES

167: Issue: As part of the MOAC changes, the org_id insertion is missing
168: Fix : Org Id is inserted for the new invoices */
169:
170:
171: INSERT INTO PA_DRAFT_INVOICES
172: (
173: DRAFT_INVOICE_NUM,
174: PROJECT_ID,
175: AGREEMENT_ID,

Line 262: FROM PA_DRAFT_INVOICES I2, PA_PROJECTS P

258: I2.PROJFUNC_INVTRANS_RATE_TYPE, /* Added below columns for bug 4500281*/
259: I2.PROJFUNC_INVTRANS_RATE_DATE,
260: I2.PROJFUNC_INVTRANS_EX_RATE,
261: I2.ORG_ID
262: FROM PA_DRAFT_INVOICES I2, PA_PROJECTS P
263: WHERE I2.DRAFT_INVOICE_NUM = P_DRAFT_INV_NUM
264: AND I2.PROJECT_ID = P_PROJECT_ID
265: AND P.PROJECT_ID = P_PROJECT_ID;
266:

Line 268: pa_ic_inv_utils.log_message('Inserting pa_draft_invoices rows = '||

264: AND I2.PROJECT_ID = P_PROJECT_ID
265: AND P.PROJECT_ID = P_PROJECT_ID;
266:
267: IF g1_debug_mode = 'Y' THEN
268: pa_ic_inv_utils.log_message('Inserting pa_draft_invoices rows = '||
269: SQL%ROWCOUNT);
270: END IF;
271:
272: /* A new line will be created in the canceling Invoice for every line