APPS.EC_MAPPING_UTILS dependencies on ECE_MAPPINGS_UPG

Line 42: FROM ece_mappings_upg

38: CURSOR c_maps_upg(xTransactionType ece_interface_tables.transaction_type%TYPE,
39: xMapType ece_mappings.map_type%TYPE) IS
40: SELECT map_id,
41: map_code
42: FROM ece_mappings_upg
43: WHERE transaction_type = xTransactionType AND
44: map_type = NVL(xMapType,map_type);
45:
46: CURSOR c_process_rules(xMap_ID NUMBER) IS

Line 73: FROM ece_mappings_upg

69:
70: BEGIN
71: IF xUpgradeFlag = 'Y' THEN
72: SELECT map_id INTO iMap_ID
73: FROM ece_mappings_upg
74: WHERE map_code = xMapCode;
75: ELSE
76: SELECT map_id INTO iMap_ID
77: FROM ece_mappings

Line 99: FROM ece_mappings_upg

95:
96: BEGIN
97: IF xUpgradeFlag = 'Y' THEN
98: SELECT map_code INTO cMapCode
99: FROM ece_mappings_upg
100: WHERE map_id = xMap_ID;
101: ELSE
102: SELECT map_code INTO cMapCode
103: FROM ece_mappings

Line 122: FROM ece_mappings_upg ecmu,

118: iMap_ID NUMBER;
119:
120: BEGIN
121: SELECT ecmu.map_id INTO iMap_ID
122: FROM ece_mappings_upg ecmu,
123: ece_mappings ecm
124: WHERE ecmu.map_code = ecm.map_code AND
125: ecm.map_id = xMap_ID;
126:

Line 142: FROM ece_mappings_upg ecmu,

138: iMap_ID NUMBER;
139:
140: BEGIN
141: SELECT ecm.map_id INTO iMap_ID
142: FROM ece_mappings_upg ecmu,
143: ece_mappings ecm
144: WHERE ecm.map_code = ecmu.map_code AND
145: ecmu.map_id = xMap_ID;
146:

Line 940: FROM ece_mappings_upg

936: transaction_type,
937: root_element,
938: enabled,
939: map_code
940: FROM ece_mappings_upg
941: WHERE map_id = xMap_ID;
942: END ec_copy_mappings;
943:
944: PROCEDURE ec_copy_process_rules(

Line 1148: DELETE FROM ece_mappings_upg

1144: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1145:
1146: BEGIN
1147: IF xUpgradeFlag = 'Y' THEN
1148: DELETE FROM ece_mappings_upg
1149: WHERE map_id = xMap_ID;
1150: ELSE
1151: DELETE FROM ece_mappings
1152: WHERE map_id = xMap_ID;