APPS.EC_MAPPING_UTILS dependencies on ECE_EXTERNAL_LEVELS

Line 15: FROM ece_external_levels_upg

11: record_layout_qualifier ece_interface_columns.record_layout_qualifier%TYPE);
12:
13: CURSOR c_external_levels_upg(xMap_ID NUMBER) IS
14: SELECT external_level_id
15: FROM ece_external_levels_upg
16: WHERE map_id = xMap_ID;
17:
18: CURSOR c_interface_columns_upg(xMap_ID NUMBER) IS
19: SELECT eicu.interface_column_id interface_column_id

Line 733: INSERT INTO ece_external_levels(

729: PROCEDURE ec_copy_external_levels(
730: xMap_ID IN NUMBER) AS
731:
732: BEGIN
733: INSERT INTO ece_external_levels(
734: external_level_id,
735: external_level,
736: description,
737: map_id,

Line 760: FROM ece_external_levels_upg

756: last_updated_by,
757: start_element,
758: parent_level,
759: enabled_flag
760: FROM ece_external_levels_upg
761: WHERE map_id = xMap_ID;
762: END ec_copy_external_levels;
763:
764: PROCEDURE ec_copy_interface_columns(

Line 1072: --Deletes entries in ECE_EXTERNAL_LEVELS.

1068: WHERE map_id = xMap_ID;
1069: END IF;
1070: END ec_delete_dynamic_action;
1071:
1072: --Deletes entries in ECE_EXTERNAL_LEVELS.
1073: PROCEDURE ec_delete_external_levels(
1074: xMap_ID IN NUMBER,
1075: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1076:

Line 1079: DELETE FROM ece_external_levels_upg

1075: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1076:
1077: BEGIN
1078: IF xUpgradeFlag = 'Y' THEN
1079: DELETE FROM ece_external_levels_upg
1080: WHERE map_id = xMap_ID;
1081: ELSE
1082: DELETE FROM ece_external_levels
1083: WHERE map_id = xMap_ID;

Line 1082: DELETE FROM ece_external_levels

1078: IF xUpgradeFlag = 'Y' THEN
1079: DELETE FROM ece_external_levels_upg
1080: WHERE map_id = xMap_ID;
1081: ELSE
1082: DELETE FROM ece_external_levels
1083: WHERE map_id = xMap_ID;
1084: END IF;
1085: END ec_delete_external_levels;
1086:

Line 1131: FROM ece_external_levels_upg

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
1134: DELETE FROM ece_level_matrices
1135: WHERE external_level_id IN (SELECT external_level_id

Line 1136: FROM ece_external_levels

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;
1139: END ec_delete_level_matrices;
1140: