APPS.EC_OUTBOUND_STAGE dependencies on ECE_INTERFACE_COLUMNS

Line 49: start_record_number ece_interface_columns.record_number%TYPE,

45: i.e. Start record Number, Document id , Document Number , Key Column name etc.
46: **/
47: TYPE start_rec is RECORD
48: (
49: start_record_number ece_interface_columns.record_number%TYPE,
50: total_records number(15),
51: Document_Id number(15),
52: Line_Number number(15),
53: Parent_Stage_Id number(15),

Line 62: Key_Column_Staging ece_interface_columns.staging_column%TYPE,

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
65: );
66:

Line 64: tp_code_staging ece_interface_columns.staging_column%TYPE

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;
68:

Line 75: record_number ece_interface_columns.record_number%TYPE,

71: i.e. record Number, position , width, and SQL select statment etc.
72: **/
73: TYPE all_rec is RECORD
74: (
75: record_number ece_interface_columns.record_number%TYPE,
76: external_level ece_external_levels.external_level%TYPE,
77: start_record_number ece_interface_columns.record_number%TYPE,
78: counter number(15),
79: select_stmt varchar2(32000)

Line 77: start_record_number ece_interface_columns.record_number%TYPE,

73: TYPE all_rec is RECORD
74: (
75: record_number ece_interface_columns.record_number%TYPE,
76: external_level ece_external_levels.external_level%TYPE,
77: start_record_number ece_interface_columns.record_number%TYPE,
78: counter number(15),
79: select_stmt varchar2(32000)
80: );
81:

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

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.
124: **/