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_INTERFACE_TABLES

Line 30: CURSOR c_maps (xTransactionType ece_interface_tables.transaction_type%TYPE,

26: SELECT interface_table_id
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

Line 38: CURSOR c_maps_upg(xTransactionType ece_interface_tables.transaction_type%TYPE,

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,
39: xMapType ece_mappings.map_type%TYPE) IS
40: SELECT map_id,
41: map_code
42: FROM ece_mappings_upg

Line 160: xTransactionType IN ece_interface_tables.transaction_type%TYPE,

156: --reconciliation pending or not.
157: --U = Reconciliation Pending
158: --N = Transaction Clean
159: FUNCTION ec_get_trans_upgrade_status(
160: xTransactionType IN ece_interface_tables.transaction_type%TYPE,
161: iMapId IN ece_interface_tables.map_id%TYPE) RETURN VARCHAR2 AS
162:
163: cUpgradedFlag ece_interface_tables.upgraded_flag%TYPE;
164:

Line 161: iMapId IN ece_interface_tables.map_id%TYPE) RETURN VARCHAR2 AS

157: --U = Reconciliation Pending
158: --N = Transaction Clean
159: FUNCTION ec_get_trans_upgrade_status(
160: xTransactionType IN ece_interface_tables.transaction_type%TYPE,
161: iMapId IN ece_interface_tables.map_id%TYPE) RETURN VARCHAR2 AS
162:
163: cUpgradedFlag ece_interface_tables.upgraded_flag%TYPE;
164:
165: BEGIN

Line 163: cUpgradedFlag ece_interface_tables.upgraded_flag%TYPE;

159: FUNCTION ec_get_trans_upgrade_status(
160: xTransactionType IN ece_interface_tables.transaction_type%TYPE,
161: iMapId IN ece_interface_tables.map_id%TYPE) RETURN VARCHAR2 AS
162:
163: cUpgradedFlag ece_interface_tables.upgraded_flag%TYPE;
164:
165: BEGIN
166: SELECT NVL(upgraded_flag,'N') INTO cUpgradedFlag
167: FROM ece_interface_tables

Line 167: FROM ece_interface_tables

163: cUpgradedFlag ece_interface_tables.upgraded_flag%TYPE;
164:
165: BEGIN
166: SELECT NVL(upgraded_flag,'N') INTO cUpgradedFlag
167: FROM ece_interface_tables
168: WHERE transaction_type = xTransactionType AND
169: map_id = iMapId AND
170: ROWNUM = 1;
171:

Line 185: xTransactionType IN ece_interface_tables.transaction_type%TYPE) RETURN VARCHAR2 AS

181:
182: END ec_get_trans_upgrade_status;
183:
184: FUNCTION ec_get_trans_upgrade_status(
185: xTransactionType IN ece_interface_tables.transaction_type%TYPE) RETURN VARCHAR2 AS
186:
187: cUpgradedFlag ece_interface_tables.upgraded_flag%TYPE;
188:
189: BEGIN

Line 187: cUpgradedFlag ece_interface_tables.upgraded_flag%TYPE;

183:
184: FUNCTION ec_get_trans_upgrade_status(
185: xTransactionType IN ece_interface_tables.transaction_type%TYPE) RETURN VARCHAR2 AS
186:
187: cUpgradedFlag ece_interface_tables.upgraded_flag%TYPE;
188:
189: BEGIN
190: SELECT NVL(upgraded_flag,'N') INTO cUpgradedFlag
191: FROM ece_interface_tables

Line 191: FROM ece_interface_tables

187: cUpgradedFlag ece_interface_tables.upgraded_flag%TYPE;
188:
189: BEGIN
190: SELECT NVL(upgraded_flag,'N') INTO cUpgradedFlag
191: FROM ece_interface_tables
192: WHERE transaction_type = xTransactionType AND
193: ROWNUM = 1;
194:
195: IF cUpgradedFlag = 'Y' THEN

Line 296: xDirection ece_interface_tables.direction%type;

292:
293: iCount NUMBER DEFAULT 0;
294: iMap_ID_Main NUMBER;
295: v_layout_record t_layout_record;
296: xDirection ece_interface_tables.direction%type;
297: xExt_Col_Count number;
298:
299: /* Bug 2138714 Removed the nvl conditions on Record no,position,width,conversion_sequence */
300:

Line 367: ece_interface_tables eit

363: NVL(eic.record_layout_code,' '),
364: NVL(eic.record_layout_qualifier,' ')
365: INTO v_layout_record
366: FROM ece_interface_columns eic,
367: ece_interface_tables eit
368: WHERE eic.interface_table_id = eit.interface_table_id AND
369: eit.map_id = iMap_ID_Main AND
370: eit.output_level = v_interface_columns_layout_upg.output_level AND
371: eic.interface_column_name = v_interface_columns_layout_upg.interface_column_name;

Line 487: from ece_interface_tables

483: -- the 11.0 architechure.
484: BEGIN
485: select direction
486: into xDirection
487: from ece_interface_tables
488: where map_id = iMap_ID_Main
489: and rownum=1;
490:
491: IF xDirection='OUT' THEN

Line 565: ece_interface_tables eit

561: SYSDATE,
562: 1,
563: 1
564: FROM ece_interface_columns eic,
565: ece_interface_tables eit
566: WHERE eic.map_id=iMap_ID_Main
567: AND eic.record_number like '_9__'
568: AND eic.interface_table_id = eit.interface_table_id
569: AND eic.map_id = eit.map_id

Line 851: INSERT INTO ece_interface_tables(

847: PROCEDURE ec_copy_interface_tables(
848: xMap_ID IN NUMBER) AS
849:
850: BEGIN
851: INSERT INTO ece_interface_tables(
852: interface_table_id,
853: transaction_type,
854: output_level,
855: interface_table_name,

Line 1017: xTransactionType IN ece_interface_tables.transaction_type%TYPE,

1013: END ec_copy_map_data_by_mapid;
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

Line 1043: ece_interface_tables eit

1039: ELSE
1040: DELETE FROM ece_column_rules
1041: WHERE interface_column_id IN (SELECT eic.interface_column_id
1042: FROM ece_interface_columns eic,
1043: ece_interface_tables eit
1044: WHERE eic.interface_table_id = eit.interface_table_id AND
1045: eit.map_id = xMap_ID);
1046: END IF;
1047: END ec_delete_column_rules;

Line 1102: FROM ece_interface_tables

1098: WHERE map_id = xMap_ID);
1099: ELSE
1100: DELETE FROM ece_interface_columns
1101: WHERE interface_table_id IN (SELECT interface_table_id
1102: FROM ece_interface_tables
1103: WHERE map_id = xMap_ID);
1104: END IF;
1105: END ec_delete_interface_columns;
1106:

Line 1107: --Deletes entries in ECE_INTERFACE_TABLES.

1103: WHERE map_id = xMap_ID);
1104: END IF;
1105: END ec_delete_interface_columns;
1106:
1107: --Deletes entries in ECE_INTERFACE_TABLES.
1108: PROCEDURE ec_delete_interface_tables(
1109: xMap_ID IN NUMBER,
1110: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1111:

Line 1117: DELETE FROM ece_interface_tables

1113: IF xUpgradeFlag = 'Y' THEN
1114: DELETE FROM ece_interface_tbls_upg
1115: WHERE map_id = xMap_ID;
1116: ELSE
1117: DELETE FROM ece_interface_tables
1118: WHERE map_id = xMap_ID;
1119: END IF;
1120: END ec_delete_interface_tables;
1121:

Line 1209: xTransactionType IN ece_interface_tables.transaction_type%TYPE,

1205: END ec_delete_map_data_by_mapid;
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