APPS.EC_MAPPING_UTILS dependencies on ECE_PROCESS_RULES

Line 49: FROM ece_process_rules

45:
46: CURSOR c_process_rules(xMap_ID NUMBER) IS
47: SELECT rule_type,
48: action_code
49: FROM ece_process_rules
50: WHERE map_id = xMap_ID;
51:
52: CURSOR c_process_rules_upg(xMap_ID NUMBER) IS
53: SELECT rule_type,

Line 55: FROM ece_process_rules_upg

51:
52: CURSOR c_process_rules_upg(xMap_ID NUMBER) IS
53: SELECT rule_type,
54: action_code
55: FROM ece_process_rules_upg
56: WHERE map_id = xMap_ID;
57:
58: CURSOR c_tran_stage_data_upg(xMap_ID NUMBER) IS
59: SELECT transtage_id

Line 612: UPDATE ece_process_rules_upg

608: BEGIN
609: iMap_ID_Main := ec_get_main_map_id(xMap_ID);
610:
611: FOR v_process_rules IN c_process_rules(iMap_ID_Main) LOOP
612: UPDATE ece_process_rules_upg
613: SET action_code = v_process_rules.action_code
614: WHERE map_id = xMap_ID AND
615: rule_type = v_process_rules.rule_type;
616: END LOOP;

Line 948: INSERT INTO ece_process_rules(

944: PROCEDURE ec_copy_process_rules(
945: xMap_ID IN NUMBER) AS
946:
947: BEGIN
948: INSERT INTO ece_process_rules(
949: process_rule_id,
950: transaction_type,
951: rule_type,
952: action_code,

Line 977: FROM ece_process_rules_upg

973: program_application_id,
974: program_id,
975: program_update_date,
976: map_id
977: FROM ece_process_rules_upg
978: WHERE map_id = xMap_ID;
979: END ec_copy_process_rules;
980:
981: --Copy all data for a given Map Code.

Line 1156: --Deletes entries in ECE_PROCESS_RULES.

1152: WHERE map_id = xMap_ID;
1153: END IF;
1154: END ec_delete_mappings;
1155:
1156: --Deletes entries in ECE_PROCESS_RULES.
1157: PROCEDURE ec_delete_process_rules(
1158: xMap_ID IN NUMBER,
1159: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1160:

Line 1163: DELETE FROM ece_process_rules_upg

1159: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1160:
1161: BEGIN
1162: IF xUpgradeFlag = 'Y' THEN
1163: DELETE FROM ece_process_rules_upg
1164: WHERE map_id = xMap_ID;
1165: ELSE
1166: DELETE FROM ece_process_rules
1167: WHERE map_id = xMap_ID;

Line 1166: DELETE FROM ece_process_rules

1162: IF xUpgradeFlag = 'Y' THEN
1163: DELETE FROM ece_process_rules_upg
1164: WHERE map_id = xMap_ID;
1165: ELSE
1166: DELETE FROM ece_process_rules
1167: WHERE map_id = xMap_ID;
1168: END IF;
1169: END ec_delete_process_rules;
1170: