DBA Data[Home] [Help]

APPS.EC_INBOUND_STAGE dependencies on ECE_INTERFACE_TABLES

Line 42: from ece_interface_tables eit,

38: eel.external_level,
39: eit.interface_table_id,
40: eit.key_column_name,
41: eit.primary_address_type
42: from ece_interface_tables eit,
43: ece_level_matrices elm,
44: ece_external_levels eel
45: where eit.transaction_type = p_transaction_type
46: and eit.interface_table_id = elm.interface_table_id

Line 811: and the Staging table. This information is seeded in the ECE_INTERFACE_TABLES

807: end load_data_from_file;
808:
809: /**
810: This procedures loads the mapping information between the Flat File
811: and the Staging table. This information is seeded in the ECE_INTERFACE_TABLES
812: and ECE_INTERFACE_COLUMNS. The mapping information is loaded into the Local Body
813: PL/SQL table variable for a given transaction Type and its level. This PL/SQL table
814: loaded with Mapping information is visible only to the functions and procedures
815: defined within this package.