APPS.EC_MAPPING_UTILS dependencies on ECE_COLUMN_RULES

Line 266: FROM ece_column_rules

262: interface_column_id,
263: sequence,
264: rule_type,
265: action_code
266: FROM ece_column_rules
267: WHERE interface_column_id = xInterface_Column_ID
268: ORDER BY sequence;
269:
270: BEGIN

Line 272: UPDATE ece_column_rules

268: ORDER BY sequence;
269:
270: BEGIN
271: FOR v_column_rules IN c_column_rules(xInterface_Column_ID_Main) LOOP
272: UPDATE ece_column_rules
273: SET interface_column_id = xInterface_Column_ID_Upg
274: WHERE column_rule_id = v_column_rules.column_rule_id;
275: --v_column_rules.interface_column_id := xInterface_Column_ID_Upg;
276: ec_debug.pl(0,'*Column Rule Sequence: ' || v_column_rules.sequence || ', Rule Type: ' ||

Line 619: --Copy data from ECE_COLUMN_RULES_UPG to ECE_COLUMN_RULES.

615: rule_type = v_process_rules.rule_type;
616: END LOOP;
617: END ec_upgrade_process_rules;
618:
619: --Copy data from ECE_COLUMN_RULES_UPG to ECE_COLUMN_RULES.
620: PROCEDURE ec_copy_column_rules(
621: xMap_ID IN NUMBER) AS
622:
623: BEGIN

Line 625: INSERT INTO ece_column_rules(

621: xMap_ID IN NUMBER) AS
622:
623: BEGIN
624: FOR v_interface_columns_upg IN c_interface_columns_upg(xMap_ID) LOOP
625: INSERT INTO ece_column_rules(
626: column_rule_id,
627: interface_column_id,
628: sequence,
629: rule_type,

Line 654: FROM ece_column_rules_upg

650: request_id,
651: program_application_id,
652: program_id,
653: program_update_date
654: FROM ece_column_rules_upg
655: WHERE interface_column_id = v_interface_columns_upg.interface_column_id;
656: END LOOP;
657:
658: END ec_copy_column_rules;

Line 1026: --Deletes entries in ECE_COLUMN_RULES.

1022: ec_copy_map_data_by_mapid(v_maps_upg.map_id);
1023: END LOOP;
1024: END ec_copy_map_data_by_trans;
1025:
1026: --Deletes entries in ECE_COLUMN_RULES.
1027: PROCEDURE ec_delete_column_rules(
1028: xMap_ID IN NUMBER,
1029: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1030:

Line 1033: DELETE FROM ece_column_rules_upg

1029: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1030:
1031: BEGIN
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

Line 1040: DELETE FROM ece_column_rules

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
1041: WHERE interface_column_id IN (SELECT eic.interface_column_id
1042: FROM ece_interface_columns eic,
1043: ece_interface_tables eit
1044: WHERE eic.interface_table_id = eit.interface_table_id AND

Line 1088: --WARNING: If you're going to delete from ECE_COLUMN_RULES, do that first or the

1084: END IF;
1085: END ec_delete_external_levels;
1086:
1087: --Deletes from ECE_INTERFACE_COLUMNS.
1088: --WARNING: If you're going to delete from ECE_COLUMN_RULES, do that first or the
1089: -- records in that table will become orphaned!
1090: PROCEDURE ec_delete_interface_columns(
1091: xMap_ID IN NUMBER,
1092: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS