1: PACKAGE ec_mapping_utils AS
2: -- $Header: ECMAPUTS.pls 120.3 2005/09/29 10:50:12 arsriniv ship $
3:
4: FUNCTION ec_get_map_id(
5: xMapCode IN ece_mappings.map_code%TYPE,
6: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') RETURN NUMBER;
7:
8: FUNCTION ec_get_map_code(
9: xMap_ID IN NUMBER,
6: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') RETURN NUMBER;
7:
8: FUNCTION ec_get_map_code(
9: xMap_ID IN NUMBER,
10: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') RETURN ece_mappings.map_code%TYPE;
11:
12: FUNCTION ec_get_upgrade_map_id(
13: xMap_ID IN NUMBER) RETURN NUMBER;
14:
58: PROCEDURE ec_copy_process_rules(
59: xMap_ID IN NUMBER);
60:
61: PROCEDURE ec_copy_map_data_by_mapcode(
62: xMapCode IN ece_mappings.map_code%TYPE);
63:
64: PROCEDURE ec_copy_map_data_by_mapid(
65: xMap_ID IN NUMBER);
66:
65: xMap_ID IN NUMBER);
66:
67: PROCEDURE ec_copy_map_data_by_trans(
68: xTransactionType IN ece_interface_tables.transaction_type%TYPE,
69: xMapType IN ece_mappings.map_type%TYPE);
70:
71: PROCEDURE ec_delete_column_rules(
72: xMap_ID IN NUMBER,
73: xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
100: xMap_ID IN NUMBER,
101: xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
102:
103: PROCEDURE ec_delete_map_data_by_mapcode(
104: xMapCode IN ece_mappings.map_code%TYPE,
105: xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
106:
107: PROCEDURE ec_delete_map_data_by_mapid(
108: xMap_ID IN NUMBER,
109: xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
110:
111: PROCEDURE ec_delete_map_data_by_trans(
112: xTransactionType IN ece_interface_tables.transaction_type%TYPE,
113: xMapType IN ece_mappings.map_type%TYPE,
114: xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
115:
116: PROCEDURE ec_migrate_map_to_production(
117: xMapCode IN ece_mappings.map_code%TYPE,
113: xMapType IN ece_mappings.map_type%TYPE,
114: xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
115:
116: PROCEDURE ec_migrate_map_to_production(
117: xMapCode IN ece_mappings.map_code%TYPE,
118: xTransExists IN BOOLEAN);
119:
120: PROCEDURE ec_reconcile_seed(
121: errbuf OUT NOCOPY VARCHAR2,