56: WHERE map_id = xMap_ID;
57:
58: CURSOR c_tran_stage_data_upg(xMap_ID NUMBER) IS
59: SELECT transtage_id
60: FROM ece_tran_stage_data_upg
61: WHERE map_id = xMap_ID;
62:
63: --Return map_id based on map_code
64: FUNCTION ec_get_map_id(
657:
658: END ec_copy_column_rules;
659:
660: --Copy data from ece_proc_mappings_upg to ECE_PROCEDURE_MAPPINGS and
661: -- from ECE_TRAN_STAGE_DATA_UPG to ECE_TRAN_STAGE_DATA.
662: PROCEDURE ec_copy_dynamic_actions(
663: xMap_ID IN NUMBER) AS
664:
665: BEGIN
681: FROM ece_proc_mappings_upg
682: WHERE transtage_id = v_tran_stage_data_upg.transtage_id;
683: END LOOP;
684:
685: --Copy data in ECE_TRAN_STAGE_DATA_UPG
686: INSERT INTO ece_tran_stage_data(
687: transaction_type,
688: transaction_level,
689: stage,
682: WHERE transtage_id = v_tran_stage_data_upg.transtage_id;
683: END LOOP;
684:
685: --Copy data in ECE_TRAN_STAGE_DATA_UPG
686: INSERT INTO ece_tran_stage_data(
687: transaction_type,
688: transaction_level,
689: stage,
690: seq_number,
721: next_variable_name,
722: where_clause,
723: map_id,
724: transtage_id
725: FROM ece_tran_stage_data_upg
726: WHERE map_id = xMap_ID;
727: END ec_copy_dynamic_actions;
728:
729: PROCEDURE ec_copy_external_levels(
1045: eit.map_id = xMap_ID);
1046: END IF;
1047: END ec_delete_column_rules;
1048:
1049: --Deletes from ECE_TRAN_STAGE_DATA and ECE_PROCEDURE_MAPPINGS
1050: PROCEDURE ec_delete_dynamic_action(
1051: xMap_ID IN NUMBER,
1052: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1053:
1054: BEGIN
1055: IF xUpgradeFlag = 'Y' THEN
1056: DELETE FROM ece_proc_mappings_upg
1057: WHERE transtage_id IN (SELECT transtage_id
1058: FROM ece_tran_stage_data_upg
1059: WHERE map_id = xMap_ID);
1060: DELETE FROM ece_tran_stage_data_upg
1061: WHERE map_id = xMap_ID;
1062: ELSE
1056: DELETE FROM ece_proc_mappings_upg
1057: WHERE transtage_id IN (SELECT transtage_id
1058: FROM ece_tran_stage_data_upg
1059: WHERE map_id = xMap_ID);
1060: DELETE FROM ece_tran_stage_data_upg
1061: WHERE map_id = xMap_ID;
1062: ELSE
1063: DELETE FROM ece_procedure_mappings
1064: WHERE transtage_id IN (SELECT transtage_id
1061: WHERE map_id = xMap_ID;
1062: ELSE
1063: DELETE FROM ece_procedure_mappings
1064: WHERE transtage_id IN (SELECT transtage_id
1065: FROM ece_tran_stage_data
1066: WHERE map_id = xMap_ID);
1067: DELETE FROM ece_tran_stage_data
1068: WHERE map_id = xMap_ID;
1069: END IF;
1063: DELETE FROM ece_procedure_mappings
1064: WHERE transtage_id IN (SELECT transtage_id
1065: FROM ece_tran_stage_data
1066: WHERE map_id = xMap_ID);
1067: DELETE FROM ece_tran_stage_data
1068: WHERE map_id = xMap_ID;
1069: END IF;
1070: END ec_delete_dynamic_action;
1071: