DBA Data[Home] [Help]

APPS.EC_MAPPING_UTILS dependencies on ECE_TRAN_STAGE_DATA_UPG

Line 60: FROM ece_tran_stage_data_upg

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(

Line 661: -- from ECE_TRAN_STAGE_DATA_UPG to ECE_TRAN_STAGE_DATA.

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

Line 685: --Copy data in ECE_TRAN_STAGE_DATA_UPG

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,

Line 725: FROM ece_tran_stage_data_upg

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(

Line 1058: FROM ece_tran_stage_data_upg

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

Line 1060: DELETE FROM ece_tran_stage_data_upg

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