DBA Data[Home] [Help]

APPS.AR_CAO_ASSIGN_PKG dependencies on FUN_RULE_BULK_RESULT_GT

Line 294: SELECT ID, RESULT_VALUE BULK COLLECT INTO results_tab from FUN_RULE_BULK_RESULT_GT;

290: 'cash_receipt_id');
291:
292: write_debug_and_log('Returned from Rule Engine');
293:
294: SELECT ID, RESULT_VALUE BULK COLLECT INTO results_tab from FUN_RULE_BULK_RESULT_GT;
295:
296: /* Update the AR_Cash_Receipts table with the result values */
297:
298: FORALL i in results_tab.cash_receipt_id.first..results_tab.cash_receipt_id.last

Line 305: delete from FUN_RULE_BULK_RESULT_GT;

301: WORK_ITEM_ASSIGNMENT_DATE = sysdate,
302: WORK_ITEM_STATUS_CODE = 'NEW'
303: where CASH_RECEIPT_ID = results_tab.cash_receipt_id(i);
304:
305: delete from FUN_RULE_BULK_RESULT_GT;
306:
307: write_debug_and_log('ar_cao_assign_pkg.assign_work_items (-)');
308:
309: EXCEPTION