DBA Data[Home] [Help]

APPS.AMW_DELETE_OBJECT_PVT dependencies on AMW_AUDIT_PROCEDURES_TL

Line 380: DELETE FROM AMW_AUDIT_PROCEDURES_TL WHERE audit_procedure_rev_id = l_ap_rev_id_list(i);

376: null);
377:
378: -- Audit Procedure
379: FORALL i IN l_ap_rev_id_list.FIRST .. l_ap_rev_id_list.LAST
380: DELETE FROM AMW_AUDIT_PROCEDURES_TL WHERE audit_procedure_rev_id = l_ap_rev_id_list(i);
381:
382: DELETE FROM AMW_AUDIT_PROCEDURES_B WHERE audit_procedure_id = p_ap_id;
383: DELETE FROM AMW_AP_ASSOCIATIONS WHERE audit_procedure_id = p_ap_id;
384: