DBA Data[Home] [Help]

APPS.EC_MAPPING_UTILS dependencies on ECE_PROC_MAPPINGS_UPG

Line 660: --Copy data from ece_proc_mappings_upg to ECE_PROCEDURE_MAPPINGS and

656: END LOOP;
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:

Line 666: --Copy data in ece_proc_mappings_upg

662: PROCEDURE ec_copy_dynamic_actions(
663: xMap_ID IN NUMBER) AS
664:
665: BEGIN
666: --Copy data in ece_proc_mappings_upg
667: FOR v_tran_stage_data_upg IN c_tran_stage_data_upg(xMap_ID) LOOP
668: INSERT INTO ece_procedure_mappings(
669: procmap_id,
670: transtage_id,

Line 681: FROM ece_proc_mappings_upg

677: parameter_name,
678: action_type,
679: variable_level,
680: variable_name
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

Line 1056: DELETE FROM ece_proc_mappings_upg

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