eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EC_MAPPING_UTILS dependencies on ECE_MAPPINGS

Line 31: xMapType ece_mappings.map_type%TYPE) IS

27: FROM ece_interface_tbls_upg
28: WHERE map_id = xMap_ID;
29:
30: CURSOR c_maps (xTransactionType ece_interface_tables.transaction_type%TYPE,
31: xMapType ece_mappings.map_type%TYPE) IS
32: SELECT map_id,
33: map_code
34: FROM ece_mappings
35: WHERE transaction_type = xTransactionType AND

Line 34: FROM ece_mappings

30: CURSOR c_maps (xTransactionType ece_interface_tables.transaction_type%TYPE,
31: xMapType ece_mappings.map_type%TYPE) IS
32: SELECT map_id,
33: map_code
34: FROM ece_mappings
35: WHERE transaction_type = xTransactionType AND
36: map_type = NVL(xMapType,map_type);
37:
38: CURSOR c_maps_upg(xTransactionType ece_interface_tables.transaction_type%TYPE,

Line 39: xMapType ece_mappings.map_type%TYPE) IS

35: WHERE transaction_type = xTransactionType AND
36: map_type = NVL(xMapType,map_type);
37:
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

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 65: xMapCode IN ece_mappings.map_code%TYPE,

61: WHERE map_id = xMap_ID;
62:
63: --Return map_id based on map_code
64: FUNCTION ec_get_map_id(
65: xMapCode IN ece_mappings.map_code%TYPE,
66: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') RETURN NUMBER AS
67:
68: iMap_ID NUMBER;
69:

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 77: FROM ece_mappings

73: FROM ece_mappings_upg
74: WHERE map_code = xMapCode;
75: ELSE
76: SELECT map_id INTO iMap_ID
77: FROM ece_mappings
78: WHERE map_code = xMapCode;
79: END IF;
80:
81: RETURN iMap_ID;

Line 92: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') RETURN ece_mappings.map_code%TYPE AS

88:
89: --Return map_code based on map_id
90: FUNCTION ec_get_map_code(
91: xMap_ID IN NUMBER,
92: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') RETURN ece_mappings.map_code%TYPE AS
93:
94: cMapCode ece_mappings.map_code%TYPE;
95:
96: BEGIN

Line 94: cMapCode ece_mappings.map_code%TYPE;

90: FUNCTION ec_get_map_code(
91: xMap_ID IN NUMBER,
92: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') RETURN ece_mappings.map_code%TYPE AS
93:
94: cMapCode ece_mappings.map_code%TYPE;
95:
96: BEGIN
97: IF xUpgradeFlag = 'Y' THEN
98: SELECT map_code INTO cMapCode

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 103: FROM ece_mappings

99: FROM ece_mappings_upg
100: WHERE map_id = xMap_ID;
101: ELSE
102: SELECT map_code INTO cMapCode
103: FROM ece_mappings
104: WHERE map_id = xMap_ID;
105: END IF;
106:
107: RETURN cMapCode;

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 123: ece_mappings ecm

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:
127: RETURN iMap_ID;

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 143: ece_mappings ecm

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:
147: RETURN iMap_ID;

Line 925: INSERT INTO ece_mappings(

921: PROCEDURE ec_copy_mappings(
922: xMap_ID IN NUMBER) AS
923:
924: BEGIN
925: INSERT INTO ece_mappings(
926: map_id,
927: description,
928: map_type,
929: transaction_type,

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 983: xMapCode IN ece_mappings.map_code%TYPE) AS

979: END ec_copy_process_rules;
980:
981: --Copy all data for a given Map Code.
982: PROCEDURE ec_copy_map_data_by_mapcode(
983: xMapCode IN ece_mappings.map_code%TYPE) AS
984:
985: iMap_ID NUMBER;
986:
987: BEGIN

Line 1018: xMapType IN ece_mappings.map_type%TYPE) AS

1014:
1015: --Copies all maps/data for a given transaction, optionally by Map Type.
1016: PROCEDURE ec_copy_map_data_by_trans(
1017: xTransactionType IN ece_interface_tables.transaction_type%TYPE,
1018: xMapType IN ece_mappings.map_type%TYPE) AS
1019:
1020: BEGIN
1021: FOR v_maps_upg IN c_maps_upg(xTransactionType,xMapType) LOOP
1022: ec_copy_map_data_by_mapid(v_maps_upg.map_id);

Line 1141: --Deletes entries in ECE_MAPPINGS.

1137: WHERE map_id = xMap_ID);
1138: END IF;
1139: END ec_delete_level_matrices;
1140:
1141: --Deletes entries in ECE_MAPPINGS.
1142: PROCEDURE ec_delete_mappings(
1143: xMap_ID IN NUMBER,
1144: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1145:

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;

Line 1151: DELETE FROM ece_mappings

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;
1153: END IF;
1154: END ec_delete_mappings;
1155:

Line 1173: xMapCode IN ece_mappings.map_code%TYPE,

1169: END ec_delete_process_rules;
1170:
1171: --Delete all data for a given Map Code.
1172: PROCEDURE ec_delete_map_data_by_mapcode(
1173: xMapCode IN ece_mappings.map_code%TYPE,
1174: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1175:
1176: iMap_ID NUMBER;
1177:

Line 1210: xMapType IN ece_mappings.map_type%TYPE,

1206:
1207: --Deletes all maps/data for a given transaction, optionally by Map Type.
1208: PROCEDURE ec_delete_map_data_by_trans(
1209: xTransactionType IN ece_interface_tables.transaction_type%TYPE,
1210: xMapType IN ece_mappings.map_type%TYPE,
1211: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1212:
1213: BEGIN
1214: IF xUpgradeFlag = 'Y' THEN

Line 1226: xMapCode IN ece_mappings.map_code%TYPE,

1222: END IF;
1223: END ec_delete_map_data_by_trans;
1224:
1225: PROCEDURE ec_migrate_map_to_production(
1226: xMapCode IN ece_mappings.map_code%TYPE,
1227: xTransExists IN BOOLEAN) AS
1228:
1229: BEGIN
1230: --DELETE from PRODUCTION

Line 1276: FROM ece_mappings

1272: ec_debug.pl(0,'Processing Map: ' || v_maps_upg.map_code);
1273:
1274: --Let's check to see if map exists in main tables...
1275: SELECT COUNT(*) INTO n_map_count
1276: FROM ece_mappings
1277: WHERE map_code = v_maps_upg.map_code;
1278:
1279: IF n_map_count > 0 THEN
1280: b_trans_exists := TRUE;