DBA Data[Home] [Help]

APPS.EC_OUTBOUND_STAGE dependencies on ECE_INTERFACE_TABLES

Line 55: Transaction_type ece_interface_tables.transaction_type%TYPE,

51: Document_Id number(15),
52: Line_Number number(15),
53: Parent_Stage_Id number(15),
54: Select_Cursor number(15),
55: Transaction_type ece_interface_tables.transaction_type%TYPE,
56: Run_Id number(15),
57: Document_Number varchar2(200),
58: Status varchar2(40),
59: Stage_Id number(15),

Line 60: Key_Column_Name ece_interface_tables.key_column_name%TYPE,

56: Run_Id number(15),
57: Document_Number varchar2(200),
58: Status varchar2(40),
59: Stage_Id number(15),
60: Key_Column_Name ece_interface_tables.key_column_name%TYPE,
61: key_Column_Position number(4),
62: Key_Column_Staging ece_interface_columns.staging_column%TYPE,
63: primary_address_type ece_interface_tables.primary_address_type%TYPE,
64: tp_code_staging ece_interface_columns.staging_column%TYPE

Line 63: primary_address_type ece_interface_tables.primary_address_type%TYPE,

59: Stage_Id number(15),
60: Key_Column_Name ece_interface_tables.key_column_name%TYPE,
61: key_Column_Position number(4),
62: Key_Column_Staging ece_interface_columns.staging_column%TYPE,
63: primary_address_type ece_interface_tables.primary_address_type%TYPE,
64: tp_code_staging ece_interface_columns.staging_column%TYPE
65: );
66:
67: TYPE Level_Info IS TABLE OF start_rec INDEX by BINARY_INTEGER;

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

115: );
116:
117: /**
118: This procedures loads the mapping information between the Flat File
119: and the Staging table. This information is seeded in the ECE_INTERFACE_TABLES
120: and ECE_INTERFACE_COLUMNS. The mapping information is loaded into the Local Body
121: PL/SQL table variable for a given transaction Type and its level. This PL/SQL table
122: loaded with Mapping information is visible only to the functions and procedures
123: defined within this package.