APPS.AMW_LOAD_SOD_DATA dependencies on AMW_CONSTRAINT_WAIVERS_TL

Line 261: -- AMW_CONSTRAINT_WAIVERS_TL

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: -- ===============================================================
265: PROCEDURE create_constraint_waivers (

Line 952: Insert the valid constraint wavers into the amw_constraint_waivers_tl

948: AND (acwi.process_flag IS NULL OR acwi.process_flag = 'N');
949:
950:
951: /*
952: Insert the valid constraint wavers into the amw_constraint_waivers_tl
953: */
954: INSERT INTO amw_constraint_waivers_tl (
955: constraint_waiver_id,
956: justification,

Line 954: INSERT INTO amw_constraint_waivers_tl (

950:
951: /*
952: Insert the valid constraint wavers into the amw_constraint_waivers_tl
953: */
954: INSERT INTO amw_constraint_waivers_tl (
955: constraint_waiver_id,
956: justification,
957: language,
958: source_lang,

Line 983: FROM amw_constraint_waivers_tl t

979: AND acwi.error_flag IS NULL
980: AND acwi.batch_id = p_batch_id
981: AND (acwi.process_flag IS NULL OR acwi.process_flag = 'N')
982: AND NOT EXISTS ( SELECT NULL
983: FROM amw_constraint_waivers_tl t
984: WHERE t.constraint_waiver_id = acwi.constraint_waiver_id
985: AND t.language = l.language_code);
986:
987: IF p_del_after_import = 'Y' THEN

Line 1315: Insert the valid constraint wavers into the amw_constraint_waivers_tl

1311: AND (acwi.process_flag IS NULL OR acwi.process_flag = 'N');
1312:
1313:
1314: /*
1315: Insert the valid constraint wavers into the amw_constraint_waivers_tl
1316: */
1317: INSERT INTO amw_constraint_waivers_tl (
1318: constraint_waiver_id,
1319: justification,

Line 1317: INSERT INTO amw_constraint_waivers_tl (

1313:
1314: /*
1315: Insert the valid constraint wavers into the amw_constraint_waivers_tl
1316: */
1317: INSERT INTO amw_constraint_waivers_tl (
1318: constraint_waiver_id,
1319: justification,
1320: language,
1321: source_lang,

Line 1345: FROM amw_constraint_waivers_tl t

1341: WHERE l.installed_flag IN ('I', 'B')
1342: AND acwi.error_flag IS NULL
1343: AND (acwi.process_flag IS NULL OR acwi.process_flag = 'N')
1344: AND NOT EXISTS ( SELECT NULL
1345: FROM amw_constraint_waivers_tl t
1346: WHERE t.constraint_waiver_id = acwi.constraint_waiver_id
1347: AND t.language = l.language_code);
1348:
1349: IF p_del_after_import = 'Y' THEN