APPS.AMW_DELETE_OBJECT_PVT dependencies on AMW_CONTROLS_B

Line 281: FROM AMW_CONTROLS_B

277: BEGIN
278: IF (p_ctrl_id IS NOT NULL) THEN
279: SELECT control_rev_id
280: BULK COLLECT INTO l_ctrl_rev_id_list
281: FROM AMW_CONTROLS_B
282: WHERE control_id = p_ctrl_id;
283:
284: -- Control Objective
285: FORALL i IN l_ctrl_rev_id_list.FIRST .. l_ctrl_rev_id_list.LAST

Line 317: DELETE FROM AMW_CONTROLS_B WHERE control_id = p_ctrl_id;

313: -- Control
314: FORALL i IN l_ctrl_rev_id_list.FIRST .. l_ctrl_rev_id_list.LAST
315: DELETE FROM AMW_CONTROLS_TL WHERE control_rev_id = l_ctrl_rev_id_list(i);
316:
317: DELETE FROM AMW_CONTROLS_B WHERE control_id = p_ctrl_id;
318:
319: FND_FILE.put_line(fnd_file.log, 'Delete Control : control_id = '||p_ctrl_id);
320:
321: IF (sql%notfound) then