APPS.EC_OUTBOUND_STAGE dependencies on ECE_INTERFACE_COLUMNS

Line 64: ece_interface_columns eic,

60: , eel.external_level external_level
61: , eel.start_element start_element
62: , COUNT(*) counter
63: from ece_interface_tables eit,
64: ece_interface_columns eic,
65: ece_level_matrices elm,
66: ece_external_levels eel
67: where eit.transaction_type = p_transaction_type
68: and eic.interface_table_id = eit.interface_table_id

Line 493: and ECE_INTERFACE_COLUMNS. The mapping information is loaded into the Local Body

489:
490: /**
491: This procedures loads the mapping information between the Flat File
492: and the Staging table. This information is seeded in the ECE_INTERFACE_TABLES
493: and ECE_INTERFACE_COLUMNS. The mapping information is loaded into the Local Body
494: PL/SQL table variable for a given transaction Type, record_number and level.
495: This PL/SQL table loaded with Mapping information is visible only to the functions
496: and procedures defined within this package.
497: **/

Line 523: ece_interface_columns eic

519: eic.width
520: FROM ece_interface_tables eit,
521: ece_level_matrices elm,
522: ece_external_levels eel,
523: ece_interface_columns eic
524: WHERE eit.interface_table_id = eic.interface_table_id
525: AND eit.transaction_type = p_transaction_type
526: AND eic.external_level = p_level
527: AND eit.interface_table_id = elm.interface_table_id

Line 650: i_rec_cd ece_interface_columns.record_layout_code%TYPE;

646: i_next_file_pos IN OUT NOCOPY number,
647: i_total_rec_unit IN number
648: )
649: IS
650: i_rec_cd ece_interface_columns.record_layout_code%TYPE;
651: i_rec_ql ece_interface_columns.record_layout_qualifier%TYPE;
652: c_local_chr_39 VARCHAR2(1) := fnd_global.local_chr(39);
653: BEGIN
654: if ec_debug.G_debug_level >= 2 then

Line 651: i_rec_ql ece_interface_columns.record_layout_qualifier%TYPE;

647: i_total_rec_unit IN number
648: )
649: IS
650: i_rec_cd ece_interface_columns.record_layout_code%TYPE;
651: i_rec_ql ece_interface_columns.record_layout_qualifier%TYPE;
652: c_local_chr_39 VARCHAR2(1) := fnd_global.local_chr(39);
653: BEGIN
654: if ec_debug.G_debug_level >= 2 then
655: ec_debug.push('EC_OUTBOUND_STAGE.GET_SELECT_STMT');