APPS.PA_IC_INV_DEL dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 136: Update pa_expenditure_items_all EI

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 */
136: Update pa_expenditure_items_all EI
137: set cc_ic_processed_code = 'N',
138: denom_transfer_price = NULL,
139: denom_tp_currency_code = NULL,
140: /* Added following column updates to NULL to clear these columns when

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

188: )
189: );
190:
191: IF g1_debug_mode = 'Y' THEN
192: pa_ic_inv_utils.log_message('pa_expenditure_items_all rows updated = ' || SQL%rowcount);
193: END IF;
194:
195:
196: /* Added following code to update related item when deleting invoice associated

Line 199: Update pa_expenditure_items_all

195:
196: /* Added following code to update related item when deleting invoice associated
197: with the original transaction. Bug 6651747. */
198:
199: Update pa_expenditure_items_all
200: set cc_ic_processed_code = 'N',
201: denom_transfer_price = NULL,
202: denom_tp_currency_code = NULl,
203: acct_transfer_price = NULL,

Line 231: pa_ic_inv_utils.log_message('Related Items: pa_expenditure_items_all rows updated = ' || SQL%rowcount);

227: and Draft_Invoice_Num = L_draft_inv_num
228: );
229:
230: IF g1_debug_mode = 'Y' THEN
231: pa_ic_inv_utils.log_message('Related Items: pa_expenditure_items_all rows updated = ' || SQL%rowcount);
232: END IF;
233:
234: /*End of code changes for Bug 6651747 */
235: