APPS.PA_IC_INV_DEL dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 136: Update pa_expenditure_items_all

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
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 180: pa_ic_inv_utils.log_message('pa_expenditure_items_all rows updated = ' || SQL%rowcount);

176: )
177: );
178:
179: IF g1_debug_mode = 'Y' THEN
180: pa_ic_inv_utils.log_message('pa_expenditure_items_all rows updated = ' || SQL%rowcount);
181: END IF;
182:
183:
184: /* Added following code to update related item when deleting invoice associated

Line 187: Update pa_expenditure_items_all

183:
184: /* Added following code to update related item when deleting invoice associated
185: with the original transaction. Bug 6651747. */
186:
187: Update pa_expenditure_items_all
188: set cc_ic_processed_code = 'N',
189: denom_transfer_price = NULL,
190: denom_tp_currency_code = NULl,
191: acct_transfer_price = NULL,

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

215: and Draft_Invoice_Num = L_draft_inv_num
216: );
217:
218: IF g1_debug_mode = 'Y' THEN
219: pa_ic_inv_utils.log_message('Related Items: pa_expenditure_items_all rows updated = ' || SQL%rowcount);
220: END IF;
221:
222: /*End of code changes for Bug 6651747 */
223: