27: (
28: interface_level pls_integer,
29: external_level pls_integer,
30: interface_column_id pls_integer,
31: base_column_name ece_interface_columns.base_column_name%TYPE,
32: interface_column_name ece_interface_columns.interface_column_name%TYPE,
33: staging_column ece_interface_columns.staging_column%TYPE,
34: record_layout_code ECE_INTERFACE_COLUMNS.record_layout_code%TYPE,
35: record_layout_qualifier ECE_INTERFACE_COLUMNS.record_layout_qualifier%TYPE,
28: interface_level pls_integer,
29: external_level pls_integer,
30: interface_column_id pls_integer,
31: base_column_name ece_interface_columns.base_column_name%TYPE,
32: interface_column_name ece_interface_columns.interface_column_name%TYPE,
33: staging_column ece_interface_columns.staging_column%TYPE,
34: record_layout_code ECE_INTERFACE_COLUMNS.record_layout_code%TYPE,
35: record_layout_qualifier ECE_INTERFACE_COLUMNS.record_layout_qualifier%TYPE,
36: record_number pls_integer,
29: external_level pls_integer,
30: interface_column_id pls_integer,
31: base_column_name ece_interface_columns.base_column_name%TYPE,
32: interface_column_name ece_interface_columns.interface_column_name%TYPE,
33: staging_column ece_interface_columns.staging_column%TYPE,
34: record_layout_code ECE_INTERFACE_COLUMNS.record_layout_code%TYPE,
35: record_layout_qualifier ECE_INTERFACE_COLUMNS.record_layout_qualifier%TYPE,
36: record_number pls_integer,
37: element_tag_name ECE_INTERFACE_COLUMNS.element_tag_name%TYPE,
30: interface_column_id pls_integer,
31: base_column_name ece_interface_columns.base_column_name%TYPE,
32: interface_column_name ece_interface_columns.interface_column_name%TYPE,
33: staging_column ece_interface_columns.staging_column%TYPE,
34: record_layout_code ECE_INTERFACE_COLUMNS.record_layout_code%TYPE,
35: record_layout_qualifier ECE_INTERFACE_COLUMNS.record_layout_qualifier%TYPE,
36: record_number pls_integer,
37: element_tag_name ECE_INTERFACE_COLUMNS.element_tag_name%TYPE,
38: position pls_integer,
31: base_column_name ece_interface_columns.base_column_name%TYPE,
32: interface_column_name ece_interface_columns.interface_column_name%TYPE,
33: staging_column ece_interface_columns.staging_column%TYPE,
34: record_layout_code ECE_INTERFACE_COLUMNS.record_layout_code%TYPE,
35: record_layout_qualifier ECE_INTERFACE_COLUMNS.record_layout_qualifier%TYPE,
36: record_number pls_integer,
37: element_tag_name ECE_INTERFACE_COLUMNS.element_tag_name%TYPE,
38: position pls_integer,
39: width pls_integer,
33: staging_column ece_interface_columns.staging_column%TYPE,
34: record_layout_code ECE_INTERFACE_COLUMNS.record_layout_code%TYPE,
35: record_layout_qualifier ECE_INTERFACE_COLUMNS.record_layout_qualifier%TYPE,
36: record_number pls_integer,
37: element_tag_name ECE_INTERFACE_COLUMNS.element_tag_name%TYPE,
38: position pls_integer,
39: width pls_integer,
40: data_type ece_interface_columns.data_type%TYPE,
41: value varchar2(32000),
36: record_number pls_integer,
37: element_tag_name ECE_INTERFACE_COLUMNS.element_tag_name%TYPE,
38: position pls_integer,
39: width pls_integer,
40: data_type ece_interface_columns.data_type%TYPE,
41: value varchar2(32000),
42: conversion_sequence pls_integer,
43: xref_category_id pls_integer,
44: xref_category_allowed ece_interface_columns.xref_category_allowed%TYPE,
40: data_type ece_interface_columns.data_type%TYPE,
41: value varchar2(32000),
42: conversion_sequence pls_integer,
43: xref_category_id pls_integer,
44: xref_category_allowed ece_interface_columns.xref_category_allowed%TYPE,
45: conversion_group_id pls_integer,
46: xref_key1_source_column ece_interface_columns.xref_key1_source_column%TYPE,
47: xref_key2_source_column ece_interface_columns.xref_key2_source_column%TYPE,
48: xref_key3_source_column ece_interface_columns.xref_key3_source_column%TYPE,
42: conversion_sequence pls_integer,
43: xref_category_id pls_integer,
44: xref_category_allowed ece_interface_columns.xref_category_allowed%TYPE,
45: conversion_group_id pls_integer,
46: xref_key1_source_column ece_interface_columns.xref_key1_source_column%TYPE,
47: xref_key2_source_column ece_interface_columns.xref_key2_source_column%TYPE,
48: xref_key3_source_column ece_interface_columns.xref_key3_source_column%TYPE,
49: xref_key4_source_column ece_interface_columns.xref_key4_source_column%TYPE,
50: xref_key5_source_column ece_interface_columns.xref_key5_source_column%TYPE,
43: xref_category_id pls_integer,
44: xref_category_allowed ece_interface_columns.xref_category_allowed%TYPE,
45: conversion_group_id pls_integer,
46: xref_key1_source_column ece_interface_columns.xref_key1_source_column%TYPE,
47: xref_key2_source_column ece_interface_columns.xref_key2_source_column%TYPE,
48: xref_key3_source_column ece_interface_columns.xref_key3_source_column%TYPE,
49: xref_key4_source_column ece_interface_columns.xref_key4_source_column%TYPE,
50: xref_key5_source_column ece_interface_columns.xref_key5_source_column%TYPE,
51: ext_val1 VARCHAR2(500),
44: xref_category_allowed ece_interface_columns.xref_category_allowed%TYPE,
45: conversion_group_id pls_integer,
46: xref_key1_source_column ece_interface_columns.xref_key1_source_column%TYPE,
47: xref_key2_source_column ece_interface_columns.xref_key2_source_column%TYPE,
48: xref_key3_source_column ece_interface_columns.xref_key3_source_column%TYPE,
49: xref_key4_source_column ece_interface_columns.xref_key4_source_column%TYPE,
50: xref_key5_source_column ece_interface_columns.xref_key5_source_column%TYPE,
51: ext_val1 VARCHAR2(500),
52: ext_val2 VARCHAR2(500),
45: conversion_group_id pls_integer,
46: xref_key1_source_column ece_interface_columns.xref_key1_source_column%TYPE,
47: xref_key2_source_column ece_interface_columns.xref_key2_source_column%TYPE,
48: xref_key3_source_column ece_interface_columns.xref_key3_source_column%TYPE,
49: xref_key4_source_column ece_interface_columns.xref_key4_source_column%TYPE,
50: xref_key5_source_column ece_interface_columns.xref_key5_source_column%TYPE,
51: ext_val1 VARCHAR2(500),
52: ext_val2 VARCHAR2(500),
53: ext_val3 VARCHAR2(500),
46: xref_key1_source_column ece_interface_columns.xref_key1_source_column%TYPE,
47: xref_key2_source_column ece_interface_columns.xref_key2_source_column%TYPE,
48: xref_key3_source_column ece_interface_columns.xref_key3_source_column%TYPE,
49: xref_key4_source_column ece_interface_columns.xref_key4_source_column%TYPE,
50: xref_key5_source_column ece_interface_columns.xref_key5_source_column%TYPE,
51: ext_val1 VARCHAR2(500),
52: ext_val2 VARCHAR2(500),
53: ext_val3 VARCHAR2(500),
54: ext_val4 VARCHAR2(500),