[Home] [Help]
74: **********************************************/
75: select distinct cat.xref_category_code
76: into cCategory_code
77: from ece_interface_tables t,
78: ece_interface_columns col,
79: ece_xref_categories cat
80: where t.interface_table_id = col.interface_table_id
81: and cat.xref_category_id = col.xref_category_id
82: and t.transaction_type = cTransaction_code
182: eic.base_column_nAme,
183: eic.data_type,
184: eic.width
185: from ece_interface_tables eit,
186: ece_interface_columns eic
187: where eit.interface_table_id = eic.interface_table_id
188: and eit.transaction_type = UPPER(cTransaction_code)
189: order by eit.interface_table_name;
190:
352: END LOOP; -- c_int_table loop
353:
354: /**********************************************************
355: Start verifying the seeded data in ece_interface_tables,
356: ece_interface_columns, and ece_source_data_loc against
357: the database.
358: **********************************************************/
359: OPEN c_inc;
360: LOOP
727: l_prv_record_num NUMBER := -1;
728:
729: /* Bug 1668518
730: ** In the following cursor,added a check on the external_level
731: ** in ece_interface_columns with the ece_external_levels table.
732: */
733: CURSOR c_file_column(
734: p_trans_type VARCHAR2,
735: p_map_id NUMBER,
745: eic.record_layout_qualifier,
746: eic.conversion_group_id,
747: eic.data_type,
748: eic.width data_length
749: FROM ece_interface_columns eic,
750: ece_interface_tables eit,
751: ece_level_matrices elm,
752: ece_external_levels eel
753: WHERE eit.interface_table_id = eic.interface_table_id AND
761:
762:
763: -- ***********************************************************************
764: -- This procedure read data from an ASCII based on the data dictionary
765: -- ECE_INTERFACE_COLUMNS table. It will then produce a report of
766: -- the value for each of the EDI element for the transaction.
767: -- ***********************************************************************
768: -- Algorithm:
769: --