APPS.AMW_DELETE_OBJECT_PVT dependencies on AMW_AUDIT_PROCEDURES_B

Line 354: FROM AMW_AUDIT_PROCEDURES_B

350: BEGIN
351: IF (p_ap_id IS NOT NULL) THEN
352: SELECT audit_procedure_rev_id
353: BULK COLLECT INTO l_ap_rev_id_list
354: FROM AMW_AUDIT_PROCEDURES_B
355: WHERE audit_procedure_id = p_ap_id;
356:
357: -- Step
358: DELETE FROM AMW_AP_STEPS_TL WHERE ap_step_id in (SELECT ap_step_id FROM amw_ap_steps_b WHERE audit_procedure_id = p_ap_id);

Line 382: DELETE FROM AMW_AUDIT_PROCEDURES_B WHERE audit_procedure_id = p_ap_id;

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:
385: FND_FILE.put_line(fnd_file.log, 'Delete Audit Procedure : audit_procedure_id = '||p_ap_id);
386: