APPS.EC_MAPPING_UTILS dependencies on ECE_PROCEDURE_MAPPINGS

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 668: INSERT INTO ece_procedure_mappings(

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,
671: parameter_name,
672: action_type,

Line 1049: --Deletes from ECE_TRAN_STAGE_DATA and ECE_PROCEDURE_MAPPINGS

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:

Line 1063: DELETE FROM ece_procedure_mappings

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
1065: FROM ece_tran_stage_data
1066: WHERE map_id = xMap_ID);
1067: DELETE FROM ece_tran_stage_data