eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_LOAD_SOD_DATA dependencies on AMW_CONSTRAINT_WAIVERS_B

Line 260: -- from interface table to AMW_CONSTRAINT_WAIVERS_B and

256: -- Procedure name
257: -- create_constraint_waivers
258: -- Purpose
259: -- import constraint waivers
260: -- from interface table to AMW_CONSTRAINT_WAIVERS_B and
261: -- AMW_CONSTRAINT_WAIVERS_TL
262: -- Notes
263: -- this procedure is called in Concurrent Executable
264: -- ===============================================================

Line 413: amw_constraint_waivers_b cstw

409: -- as the user waiver allready existing in the constraint
410: CURSOR c_duplicate_user_waiver_batch IS
411: SELECT acwi.Interface_id
412: FROM amw_cst_waiver_interface acwi,
413: amw_constraint_waivers_b cstw
414: WHERE acwi.object_type = 'USER'
415: AND cstw.object_type = 'USER'
416: AND acwi.batch_id = p_batch_id
417: AND cstw.constraint_rev_id= acwi.constraint_rev_id

Line 445: amw_constraint_waivers_b cstw

441:
442: CURSOR c_duplicate_user_waiver IS
443: SELECT acwi.Interface_id
444: FROM amw_cst_waiver_interface acwi,
445: amw_constraint_waivers_b cstw
446: WHERE acwi.object_type = 'USER'
447: AND cstw.object_type = 'USER'
448: AND cstw.constraint_rev_id= acwi.constraint_rev_id
449: AND cstw.pk1 = acwi.pk1

Line 477: amw_constraint_waivers_b cstw

473: -- as the user waiver allready existing in the constraint
474: CURSOR c_duplicate_resp_waiver_batch IS
475: SELECT acwi.Interface_id
476: FROM amw_cst_waiver_interface acwi,
477: amw_constraint_waivers_b cstw
478: WHERE acwi.object_type = 'RESP'
479: AND cstw.object_type = 'RESP'
480: AND acwi.batch_id = p_batch_id
481: AND cstw.constraint_rev_id= acwi.constraint_rev_id

Line 513: amw_constraint_waivers_b cstw

509:
510: CURSOR c_duplicate_resp_waiver IS
511: SELECT acwi.Interface_id
512: FROM amw_cst_waiver_interface acwi,
513: amw_constraint_waivers_b cstw
514: WHERE acwi.object_type = 'RESP'
515: AND cstw.object_type = 'RESP'
516: AND cstw.constraint_rev_id= acwi.constraint_rev_id
517: AND cstw.pk1 = acwi.pk1

Line 907: Insert the valid constraint wavers into the amw_constraint_waivers_b

903: AND batch_id = p_batch_id;
904:
905:
906: /*
907: Insert the valid constraint wavers into the amw_constraint_waivers_b
908: */
909: INSERT INTO amw_constraint_waivers_b(
910: last_update_date,
911: last_updated_by,

Line 909: INSERT INTO amw_constraint_waivers_b(

905:
906: /*
907: Insert the valid constraint wavers into the amw_constraint_waivers_b
908: */
909: INSERT INTO amw_constraint_waivers_b(
910: last_update_date,
911: last_updated_by,
912: last_update_login,
913: creation_date,

Line 1271: Insert the valid constraint wavers into the amw_constraint_waivers_b

1267: WHERE error_flag IS NULL
1268: AND (process_flag IS NULL OR process_flag = 'N');
1269:
1270: /*
1271: Insert the valid constraint wavers into the amw_constraint_waivers_b
1272: */
1273: INSERT INTO amw_constraint_waivers_b(
1274: last_update_date,
1275: last_updated_by,

Line 1273: INSERT INTO amw_constraint_waivers_b(

1269:
1270: /*
1271: Insert the valid constraint wavers into the amw_constraint_waivers_b
1272: */
1273: INSERT INTO amw_constraint_waivers_b(
1274: last_update_date,
1275: last_updated_by,
1276: last_update_login,
1277: creation_date,

Line 1418: -- 5. AMW_CONSTRAINT_WAIVERS_B.PK2

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
1420: -- this procedure is called in Concurrent Executable
1421: -- ===============================================================
1422: PROCEDURE cst_table_update_report (

Line 1544: FROM AMW_CONSTRAINT_WAIVERS_B acwb,

1540: CURSOR c_amw_cst_waiver IS
1541: SELECT acwb.CONSTRAINT_REV_ID,
1542: acv.CONSTRAINT_NAME,
1543: acwb.PK1
1544: FROM AMW_CONSTRAINT_WAIVERS_B acwb,
1545: AMW_CONSTRAINTs_VL acv
1546: WHERE acwb.CONSTRAINT_REV_ID =acv.CONSTRAINT_REV_ID
1547: AND acwb.OBJECT_TYPE='RESP'
1548: AND 1 < ( SELECT COUNT(1)

Line 1829: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');

1825: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1826:
1827: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1828: fnd_file.put_line(fnd_file.LOG,'| |');
1829: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');
1830: fnd_file.put_line(fnd_file.LOG,'| |');
1831: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1832:
1833: fnd_file.put_line(fnd_file.LOG, 'Please Manaully verify the following Constraints Responsibility Waiver .');

Line 1891: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');

1887: END IF; -- end of ((l_resp_id_list IS NOT NULL) and (l_resp_id_list.FIRST IS NOT NULL)) THEN
1888:
1889: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1890: fnd_file.put_line(fnd_file.LOG,'| |');
1891: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');
1892: fnd_file.put_line(fnd_file.LOG,'| |');
1893: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1894: EXCEPTION
1895: WHEN OTHERS THEN