APPS.EC_MAPPING_UTILS dependencies on ECE_LEVEL_MATRICES

Line 909: INSERT INTO ece_level_matrices(

905: xMap_ID IN NUMBER) AS
906:
907: BEGIN
908: FOR v_external_levels IN c_external_levels_upg(xMap_ID) LOOP
909: INSERT INTO ece_level_matrices(
910: matrix_level_id,
911: external_level_id,
912: interface_table_id)
913: SELECT matrix_level_id,

Line 916: FROM ece_level_matrices_upg

912: interface_table_id)
913: SELECT matrix_level_id,
914: external_level_id,
915: interface_table_id
916: FROM ece_level_matrices_upg
917: WHERE external_level_id = v_external_levels.external_level_id;
918: END LOOP;
919: END ec_copy_level_matrices;
920:

Line 1122: --Deletes entries in ECE_LEVEL_MATRICES.

1118: WHERE map_id = xMap_ID;
1119: END IF;
1120: END ec_delete_interface_tables;
1121:
1122: --Deletes entries in ECE_LEVEL_MATRICES.
1123: PROCEDURE ec_delete_level_matrices(
1124: xMap_ID IN NUMBER,
1125: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1126:

Line 1129: DELETE FROM ece_level_matrices_upg

1125: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1126:
1127: BEGIN
1128: IF xUpgradeFlag = 'Y' THEN
1129: DELETE FROM ece_level_matrices_upg
1130: WHERE external_level_id IN (SELECT external_level_id
1131: FROM ece_external_levels_upg
1132: WHERE map_id = xMap_ID);
1133: ELSE

Line 1134: DELETE FROM ece_level_matrices

1130: WHERE external_level_id IN (SELECT external_level_id
1131: FROM ece_external_levels_upg
1132: WHERE map_id = xMap_ID);
1133: ELSE
1134: DELETE FROM ece_level_matrices
1135: WHERE external_level_id IN (SELECT external_level_id
1136: FROM ece_external_levels
1137: WHERE map_id = xMap_ID);
1138: END IF;