APPS.EC_MAPPING_UTILS dependencies on ECE_INTERFACE_TBLS_UPG

Line 21: ece_interface_tbls_upg eitu

17:
18: CURSOR c_interface_columns_upg(xMap_ID NUMBER) IS
19: SELECT eicu.interface_column_id interface_column_id
20: FROM ece_interface_cols_upg eicu,
21: ece_interface_tbls_upg eitu
22: WHERE eicu.interface_table_id = eitu.interface_table_id AND
23: eitu.map_id = xMap_ID;
24:
25: CURSOR c_interface_tables_upg(xMap_ID NUMBER) IS

Line 27: FROM ece_interface_tbls_upg

23: eitu.map_id = xMap_ID;
24:
25: CURSOR c_interface_tables_upg(xMap_ID NUMBER) IS
26: SELECT interface_table_id
27: FROM ece_interface_tbls_upg
28: WHERE map_id = xMap_ID;
29:
30: CURSOR c_maps (xTransactionType ece_interface_tables.transaction_type%TYPE,
31: xMapType ece_mappings.map_type%TYPE) IS

Line 314: ece_interface_tbls_upg eitu

310: eicu.conversion_sequence conversion_sequence,
311: NVL(eicu.record_layout_code,' ') record_layout_code,
312: NVL(eicu.record_layout_qualifier,' ') record_layout_qualifier
313: FROM ece_interface_cols_upg eicu,
314: ece_interface_tbls_upg eitu
315: WHERE eicu.interface_table_id = eitu.interface_table_id AND
316: eitu.map_id = xMap_ID AND
317: eicu.interface_column_name IS NOT NULL
318: ORDER BY TO_NUMBER(eitu.output_level),

Line 328: ece_interface_tbls_upg eitu

324: eicu.position position,
325: eitu.map_id map_id,
326: COUNT(*) count
327: FROM ece_interface_cols_upg eicu,
328: ece_interface_tbls_upg eitu
329: WHERE eitu.map_id = xMap_ID AND
330: eitu.interface_table_id = eicu.interface_table_id AND
331: eicu.record_number IS NOT NULL AND --These lines are used to filter out unmapped
332: eicu.position IS NOT NULL --records which are not true duplicates.

Line 346: FROM ece_interface_tbls_upg eitu

342: CURSOR c_interface_tables_upg2(xMap_ID NUMBER) IS
343: SELECT eitu.interface_table_id interface_table_id,
344: eitu.output_level output_level,
345: eitu.map_id map_id
346: FROM ece_interface_tbls_upg eitu
347: WHERE eitu.map_id = xMap_ID;
348:
349: BEGIN
350: iMap_ID_Main := ec_get_main_map_id(xMap_ID_Upg);

Line 900: FROM ece_interface_tbls_upg

896: installed_flag,
897: map_id,
898: enabled,
899: upgraded_flag
900: FROM ece_interface_tbls_upg
901: WHERE map_id = xMap_ID;
902: END ec_copy_interface_tables;
903:
904: PROCEDURE ec_copy_level_matrices(

Line 1036: ece_interface_tbls_upg eit

1032: IF xUpgradeFlag = 'Y' THEN
1033: DELETE FROM ece_column_rules_upg
1034: WHERE interface_column_id IN (SELECT eic.interface_column_id
1035: FROM ece_interface_cols_upg eic,
1036: ece_interface_tbls_upg eit
1037: WHERE eic.interface_table_id = eit.interface_table_id AND
1038: eit.map_id = xMap_ID);
1039: ELSE
1040: DELETE FROM ece_column_rules

Line 1097: FROM ece_interface_tbls_upg

1093: BEGIN
1094: IF xUpgradeFlag = 'Y' THEN
1095: DELETE FROM ece_interface_cols_upg
1096: WHERE interface_table_id IN (SELECT interface_table_id
1097: FROM ece_interface_tbls_upg
1098: WHERE map_id = xMap_ID);
1099: ELSE
1100: DELETE FROM ece_interface_columns
1101: WHERE interface_table_id IN (SELECT interface_table_id

Line 1114: DELETE FROM ece_interface_tbls_upg

1110: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1111:
1112: BEGIN
1113: IF xUpgradeFlag = 'Y' THEN
1114: DELETE FROM ece_interface_tbls_upg
1115: WHERE map_id = xMap_ID;
1116: ELSE
1117: DELETE FROM ece_interface_tables
1118: WHERE map_id = xMap_ID;