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_COLS_UPG

Line 20: FROM ece_interface_cols_upg eicu,

16: WHERE map_id = xMap_ID;
17:
18: CURSOR c_interface_columns_upg(xMap_ID NUMBER) IS
19: SELECT eicu.interface_column_id interface_column_id
20: FROM ece_interface_cols_upg eicu,
21: ece_interface_tbls_upg eitu
22: WHERE eicu.interface_table_id = eitu.interface_table_id AND
23: eitu.map_id = xMap_ID;
24:

Line 235: UPDATE ece_interface_cols_upg

231: FROM ece_interface_columns
232: WHERE interface_column_id = xInterface_Column_ID_Main;
233:
234: IF iXref_Category_ID IS NOT NULL THEN
235: UPDATE ece_interface_cols_upg
236: SET xref_category_id = iXref_Category_ID,
237: xref_key1_source_column = iKey1,
238: xref_key2_source_column = iKey2,
239: xref_key3_source_column = iKey3,

Line 313: FROM ece_interface_cols_upg eicu,

309: eicu.width width,
310: eicu.conversion_sequence conversion_sequence,
311: NVL(eicu.record_layout_code,' ') record_layout_code,
312: NVL(eicu.record_layout_qualifier,' ') record_layout_qualifier
313: FROM ece_interface_cols_upg eicu,
314: ece_interface_tbls_upg eitu
315: WHERE eicu.interface_table_id = eitu.interface_table_id AND
316: eitu.map_id = xMap_ID AND
317: eicu.interface_column_name IS NOT NULL

Line 327: FROM ece_interface_cols_upg eicu,

323: eicu.record_number record_number,
324: eicu.position position,
325: eitu.map_id map_id,
326: COUNT(*) count
327: FROM ece_interface_cols_upg eicu,
328: ece_interface_tbls_upg eitu
329: WHERE eitu.map_id = xMap_ID AND
330: eitu.interface_table_id = eicu.interface_table_id AND
331: eicu.record_number IS NOT NULL AND --These lines are used to filter out unmapped

Line 353: --Loop through ece_interface_cols_upg

349: BEGIN
350: iMap_ID_Main := ec_get_main_map_id(xMap_ID_Upg);
351:
352: FOR v_interface_columns_layout_upg IN c_interface_columns_layout_upg(xMap_ID_Upg) LOOP
353: --Loop through ece_interface_cols_upg
354: BEGIN
355: --Look for matching Interface Column Name
356: /* Bug 2138714 Removed the nvl conditions on Record no,position,width,conversion_sequence */
357:

Line 404: UPDATE ece_interface_cols_upg

400: v_interface_columns_layout_upg.record_number || '/' || v_interface_columns_layout_upg.position ||
401: '. old Record Number and Position: ' || v_layout_record.record_number || '/' || v_layout_record.position ||
402: ' will be preserved.');
403:
404: UPDATE ece_interface_cols_upg
405: SET record_number = v_layout_record.record_number,
406: position = v_layout_record.position
407: WHERE interface_column_id = v_interface_columns_layout_upg.interface_column_id;
408: --v_interface_columns_layout_upg.record_number := v_layout_record.record_number;

Line 420: UPDATE ece_interface_cols_upg

416: ELSE
417: ec_debug.pl(0,'*Width for Column: "' || v_interface_columns_layout_upg.interface_column_name ||
418: '" at Output Level: ' || v_interface_columns_layout_upg.output_level || ' changed to ' ||
419: v_interface_columns_layout_upg.width || '. old Width: ' || v_layout_record.width || ' will be preserved.');
420: UPDATE ece_interface_cols_upg
421: SET width = v_layout_record.width
422: WHERE interface_column_id = v_interface_columns_layout_upg.interface_column_id;
423: --v_interface_columns_layout_upg.width := v_layout_record.width;
424: END IF;

Line 435: UPDATE ece_interface_cols_upg

431: ec_debug.pl(0,'*Conversion Sequence for Column: "' || v_interface_columns_layout_upg.interface_column_name ||
432: '" at Output Level: ' || v_interface_columns_layout_upg.output_level || ' changed to ' ||
433: v_interface_columns_layout_upg.conversion_sequence || '. old Conversion Sequence: ' ||
434: v_layout_record.conversion_sequence || ' will be preserved.');
435: UPDATE ece_interface_cols_upg
436: SET conversion_sequence = v_layout_record.conversion_sequence
437: WHERE interface_column_id = v_interface_columns_layout_upg.interface_column_id;
438: --v_interface_columns_layout_upg.conversion_sequence := v_layout_record.conversion_sequence;
439: END IF;

Line 450: UPDATE ece_interface_cols_upg

446: ec_debug.pl(0,'*Record Layout Code for Column: "' || v_interface_columns_layout_upg.interface_column_name ||
447: '" at Output Level: ' || v_interface_columns_layout_upg.output_level || ' changed to ' ||
448: v_interface_columns_layout_upg.record_layout_code || '. old Record Layout Code: ' ||
449: v_layout_record.record_layout_code || ' will be preserved.');
450: UPDATE ece_interface_cols_upg
451: SET record_layout_code = v_layout_record.record_layout_code
452: WHERE interface_column_id = v_interface_columns_layout_upg.interface_column_id;
453: --v_interface_columns_layout_upg.record_layout_code := v_layout_record.record_layout_code;
454: END IF;

Line 465: UPDATE ece_interface_cols_upg

461: ec_debug.pl(0,'*Record Layout Qualifier for Column: "' || v_interface_columns_layout_upg.interface_column_name ||
462: '" at Output Level: ' || v_interface_columns_layout_upg.output_level || ' changed to ' ||
463: v_interface_columns_layout_upg.record_layout_qualifier || '. old Record Layout Qualifier: ' ||
464: v_layout_record.record_layout_qualifier || ' will be preserved.');
465: UPDATE ece_interface_cols_upg
466: SET record_layout_qualifier = v_layout_record.record_layout_qualifier
467: WHERE interface_column_id = v_interface_columns_layout_upg.interface_column_id;
468: --v_interface_columns_layout_upg.record_layout_qualifier := v_layout_record.record_layout_qualifier;
469: END IF;

Line 505: INSERT INTO ece_interface_cols_upg(

501: IF xExt_Col_Count >0 THEN
502: FOR v_interface_tables_upg IN c_interface_tables_upg2(xMap_ID_Upg)
503: LOOP
504:
505: INSERT INTO ece_interface_cols_upg(
506: interface_column_id,
507: interface_table_id,
508: interface_column_name,
509: base_table_name,

Line 572: from ece_interface_cols_upg

568: AND eic.interface_table_id = eit.interface_table_id
569: AND eic.map_id = eit.map_id
570: AND eit.output_level = v_interface_tables_upg.output_level
571: AND eic.interface_column_name not in(select interface_column_name
572: from ece_interface_cols_upg
573: where record_number like '_9__'
574: and map_id=v_interface_tables_upg.map_id);
575: END LOOP;
576: ec_debug.pl(0,'Custom Columns are presevered');

Line 587: --Now that we're done looping through ece_interface_cols_upg table, let's check to see what Record Number

583: WHEN others THEN
584: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
585: END;
586:
587: --Now that we're done looping through ece_interface_cols_upg table, let's check to see what Record Number
588: --and Positions are now duplicated because of Reconciliation Process
589: ec_debug.pl(0,'*****Following Record Numbers and Positions are duplicated due to reconciliation process.');
590: FOR v_interface_columns_dups_upg IN c_interface_columns_dups_upg(xMap_ID_Upg) LOOP
591: ec_debug.pl(0,'Output Level: ' || v_interface_columns_dups_upg.output_level ||

Line 842: FROM ece_interface_cols_upg

838: staging_column,
839: element_tag_name,
840: map_id,
841: external_level
842: FROM ece_interface_cols_upg
843: WHERE interface_table_id = v_interface_tables_upg.interface_table_id;
844: END LOOP;
845: END ec_copy_interface_columns;
846:

Line 1035: FROM ece_interface_cols_upg eic,

1031: BEGIN
1032: IF xUpgradeFlag = 'Y' THEN
1033: DELETE FROM ece_column_rules_upg
1034: WHERE interface_column_id IN (SELECT eic.interface_column_id
1035: FROM ece_interface_cols_upg eic,
1036: ece_interface_tbls_upg eit
1037: WHERE eic.interface_table_id = eit.interface_table_id AND
1038: eit.map_id = xMap_ID);
1039: ELSE

Line 1095: DELETE FROM ece_interface_cols_upg

1091: xMap_ID IN NUMBER,
1092: xUpgradeFlag IN VARCHAR2 DEFAULT 'N') AS
1093: BEGIN
1094: IF xUpgradeFlag = 'Y' THEN
1095: DELETE FROM ece_interface_cols_upg
1096: WHERE interface_table_id IN (SELECT interface_table_id
1097: FROM ece_interface_tbls_upg
1098: WHERE map_id = xMap_ID);
1099: ELSE