APPS.AMW_LOAD_SOD_DATA dependencies on AMW_CONSTRAINT_ENTRIES

Line 1415: -- 2. AMW_CONSTRAINT_ENTRIES.APPLICATION_ID

1411: -- Purpose
1412: -- Report the issues identified during updating of the following
1413: -- columsn the application_id
1414: -- 1. AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID
1415: -- 2. AMW_CONSTRAINT_ENTRIES.APPLICATION_ID
1416: -- 3. AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID
1417: -- 4. AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID
1418: -- 5. AMW_CONSTRAINT_WAIVERS_B.PK2
1419: -- Notes

Line 1471: AMW_CONSTRAINT_ENTRIES ace

1467: acv.CONSTRAINT_NAME,
1468: ace.OBJECT_TYPE,
1469: ace.FUNCTION_ID
1470: FROM AMW_CONSTRAINTS_VL acv,
1471: AMW_CONSTRAINT_ENTRIES ace
1472: WHERE acv.START_DATE<= SYSDATE
1473: AND (acv.END_DATE IS NULL OR acv.END_DATE>=SYSDATE)
1474: AND acv.CONSTRAINT_REV_ID=ace.CONSTRAINT_REV_ID
1475: AND ace.OBJECT_TYPE = 'RESP'

Line 1487: AMW_CONSTRAINT_ENTRIES ace

1483: acv.CONSTRAINT_NAME,
1484: ace.OBJECT_TYPE,
1485: ace.FUNCTION_ID
1486: FROM AMW_CONSTRAINTS_VL acv,
1487: AMW_CONSTRAINT_ENTRIES ace
1488: WHERE acv.START_DATE<= SYSDATE
1489: AND (acv.END_DATE IS NULL OR acv.END_DATE>=SYSDATE)
1490: AND acv.CONSTRAINT_REV_ID=ace.CONSTRAINT_REV_ID
1491: AND ace.OBJECT_TYPE = 'CP'

Line 1612: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');

1608: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1609:
1610: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1611: fnd_file.put_line(fnd_file.LOG,'| |');
1612: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1613: fnd_file.put_line(fnd_file.LOG,'| |');
1614: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1615:
1616: -- Data fix for AMW_CONSTRAINT_ENTRIES

Line 1616: -- Data fix for AMW_CONSTRAINT_ENTRIES

1612: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1613: fnd_file.put_line(fnd_file.LOG,'| |');
1614: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1615:
1616: -- Data fix for AMW_CONSTRAINT_ENTRIES
1617: -- Cleaning the lists
1618: l_cst_rev_id_list.delete();
1619: l_cst_name_list.delete();
1620: l_function_id_list.delete();

Line 1710: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');

1706: END IF; -- IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1707:
1708: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1709: fnd_file.put_line(fnd_file.LOG,'| |');
1710: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1711: fnd_file.put_line(fnd_file.LOG,'| |');
1712: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1713:
1714: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');