DBA Data[Home] [Help]

APPS.EC_MAPPING_UTILS dependencies on ECE_PROCESS_RULES_UPG

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 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 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;