APPS.AMW_LOAD_SOD_DATA dependencies on AMW_VIOLATION_RESP

Line 1520: CURSOR c_amw_violation_resp_entries IS

1516: AND ENABLED_FLAG='Y');
1517:
1518: -- Identifies the Constraint whose Responsibility Violation has Concurrent Program
1519: -- having more than 1 Application Id
1520: CURSOR c_amw_violation_resp_entries IS
1521: SELECT DISTINCT acv.CONSTRAINT_REV_ID,
1522: acv.CONSTRAINT_NAME,
1523: avre.FUNCTION_ID
1524: FROM AMW_VIOLATIONS av,

Line 1526: AMW_VIOLATION_RESP avr,

1522: acv.CONSTRAINT_NAME,
1523: avre.FUNCTION_ID
1524: FROM AMW_VIOLATIONS av,
1525: AMW_CONSTRAINTS_VL acv,
1526: AMW_VIOLATION_RESP avr,
1527: AMW_VIOLAT_RESP_ENTRIES avre
1528: WHERE av.CONSTRAINT_REV_ID = acv.CONSTRAINT_REV_ID
1529: AND av.VIOLATION_ID = avr.VIOLATION_ID
1530: AND avr.RESP_VIOLATION_ID = avre.RESP_VIOLATION_ID

Line 1783: OPEN c_amw_violation_resp_entries;

1779: l_cst_rev_id_list.delete();
1780: l_cst_name_list.delete();
1781: l_function_id_list.delete();
1782:
1783: OPEN c_amw_violation_resp_entries;
1784: FETCH c_amw_violation_resp_entries
1785: BULK COLLECT INTO l_cst_rev_id_list,l_cst_name_list,l_function_id_list;
1786: CLOSE c_amw_violation_resp_entries;
1787:

Line 1784: FETCH c_amw_violation_resp_entries

1780: l_cst_name_list.delete();
1781: l_function_id_list.delete();
1782:
1783: OPEN c_amw_violation_resp_entries;
1784: FETCH c_amw_violation_resp_entries
1785: BULK COLLECT INTO l_cst_rev_id_list,l_cst_name_list,l_function_id_list;
1786: CLOSE c_amw_violation_resp_entries;
1787:
1788: IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN

Line 1786: CLOSE c_amw_violation_resp_entries;

1782:
1783: OPEN c_amw_violation_resp_entries;
1784: FETCH c_amw_violation_resp_entries
1785: BULK COLLECT INTO l_cst_rev_id_list,l_cst_name_list,l_function_id_list;
1786: CLOSE c_amw_violation_resp_entries;
1787:
1788: IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1789: FOR i in l_function_id_list.FIRST .. l_function_id_list.LAST
1790: LOOP