DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM_UTILS_PKG dependencies on AD_PARALLEL_UPDATES

Line 533: --helper to DELETE_UNIT to delete AD parallel updates info when splitting was involved.

529: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
530: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
531: END;
532:
533: --helper to DELETE_UNIT to delete AD parallel updates info when splitting was involved.
534: FUNCTION DELETE_AD_DATA(p_run_id IN NUMBER,
535: p_unit_id IN NUMBER,
536: p_owner IN VARCHAR2,
537: p_table_name IN VARCHAR2)

Line 552: FROM ad_parallel_updates

548: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
549: --fnd_oam_debug.log(1, l_ctxt, 'Deleting args...');
550: SELECT update_id
551: BULK COLLECT INTO l_ids
552: FROM ad_parallel_updates
553: WHERE owner = p_owner
554: AND table_name = p_table_name
555: AND script_name = l_script_key;
556:

Line 565: DELETE FROM ad_parallel_updates

561: DELETE FROM ad_parallel_workers
562: WHERE update_id = l_id;
563: DELETE FROM ad_parallel_update_units
564: WHERE update_id = l_id;
565: DELETE FROM ad_parallel_updates
566: WHERE update_id = l_id;
567: k := l_ids.NEXT(k);
568: END LOOP;
569: