30: * SOURCE_SYSTEM_ID EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE
31: * , BATCH_TYPE EGO_IMPORT_BATCHES_B.BATCH_TYPE%TYPE
32: * , ASSIGNEE EGO_IMPORT_BATCHES_B.ASSIGNEE%TYPE
33: * , BATCH_STATUS EGO_IMPORT_BATCHES_B.BATCH_STATUS%TYPE
34: * , MATCH_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.MATCH_ON_DATA_LOAD%TYPE
35: * , IMPORT_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.IMPORT_ON_DATA_LOAD%TYPE
36: * , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
37: * , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
38: * , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
31: * , BATCH_TYPE EGO_IMPORT_BATCHES_B.BATCH_TYPE%TYPE
32: * , ASSIGNEE EGO_IMPORT_BATCHES_B.ASSIGNEE%TYPE
33: * , BATCH_STATUS EGO_IMPORT_BATCHES_B.BATCH_STATUS%TYPE
34: * , MATCH_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.MATCH_ON_DATA_LOAD%TYPE
35: * , IMPORT_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.IMPORT_ON_DATA_LOAD%TYPE
36: * , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
37: * , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
38: * , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
39: * , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
32: * , ASSIGNEE EGO_IMPORT_BATCHES_B.ASSIGNEE%TYPE
33: * , BATCH_STATUS EGO_IMPORT_BATCHES_B.BATCH_STATUS%TYPE
34: * , MATCH_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.MATCH_ON_DATA_LOAD%TYPE
35: * , IMPORT_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.IMPORT_ON_DATA_LOAD%TYPE
36: * , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
37: * , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
38: * , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
39: * , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
40: * , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
33: * , BATCH_STATUS EGO_IMPORT_BATCHES_B.BATCH_STATUS%TYPE
34: * , MATCH_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.MATCH_ON_DATA_LOAD%TYPE
35: * , IMPORT_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.IMPORT_ON_DATA_LOAD%TYPE
36: * , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
37: * , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
38: * , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
39: * , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
40: * , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
41: * , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
34: * , MATCH_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.MATCH_ON_DATA_LOAD%TYPE
35: * , IMPORT_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.IMPORT_ON_DATA_LOAD%TYPE
36: * , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
37: * , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
38: * , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
39: * , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
40: * , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
41: * , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
42: * , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
35: * , IMPORT_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.IMPORT_ON_DATA_LOAD%TYPE
36: * , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
37: * , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
38: * , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
39: * , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
40: * , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
41: * , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
42: * , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
43: * , CHANGE_NOTICE EGO_IMPORT_OPTION_SETS.CHANGE_NOTICE%TYPE
36: * , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
37: * , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
38: * , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
39: * , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
40: * , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
41: * , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
42: * , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
43: * , CHANGE_NOTICE EGO_IMPORT_OPTION_SETS.CHANGE_NOTICE%TYPE
44: * , CHANGE_ORDER_CREATION EGO_IMPORT_OPTION_SETS.CHANGE_ORDER_CREATION%TYPE
37: * , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
38: * , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
39: * , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
40: * , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
41: * , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
42: * , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
43: * , CHANGE_NOTICE EGO_IMPORT_OPTION_SETS.CHANGE_NOTICE%TYPE
44: * , CHANGE_ORDER_CREATION EGO_IMPORT_OPTION_SETS.CHANGE_ORDER_CREATION%TYPE
45: * , PDH_BATCH varchar2(1)
38: * , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
39: * , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
40: * , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
41: * , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
42: * , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
43: * , CHANGE_NOTICE EGO_IMPORT_OPTION_SETS.CHANGE_NOTICE%TYPE
44: * , CHANGE_ORDER_CREATION EGO_IMPORT_OPTION_SETS.CHANGE_ORDER_CREATION%TYPE
45: * , PDH_BATCH varchar2(1)
46: *
39: * , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
40: * , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
41: * , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
42: * , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
43: * , CHANGE_NOTICE EGO_IMPORT_OPTION_SETS.CHANGE_NOTICE%TYPE
44: * , CHANGE_ORDER_CREATION EGO_IMPORT_OPTION_SETS.CHANGE_ORDER_CREATION%TYPE
45: * , PDH_BATCH varchar2(1)
46: *
47: * ----------------
40: * , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
41: * , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
42: * , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
43: * , CHANGE_NOTICE EGO_IMPORT_OPTION_SETS.CHANGE_NOTICE%TYPE
44: * , CHANGE_ORDER_CREATION EGO_IMPORT_OPTION_SETS.CHANGE_ORDER_CREATION%TYPE
45: * , PDH_BATCH varchar2(1)
46: *
47: * ----------------
48: * Parameters
102: ( SOURCE_SYSTEM_ID EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE
103: , BATCH_TYPE EGO_IMPORT_BATCHES_B.BATCH_TYPE%TYPE
104: , ASSIGNEE EGO_IMPORT_BATCHES_B.ASSIGNEE%TYPE
105: , BATCH_STATUS EGO_IMPORT_BATCHES_B.BATCH_STATUS%TYPE
106: , MATCH_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.MATCH_ON_DATA_LOAD%TYPE
107: , IMPORT_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.IMPORT_ON_DATA_LOAD%TYPE
108: , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
109: , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
110: , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
103: , BATCH_TYPE EGO_IMPORT_BATCHES_B.BATCH_TYPE%TYPE
104: , ASSIGNEE EGO_IMPORT_BATCHES_B.ASSIGNEE%TYPE
105: , BATCH_STATUS EGO_IMPORT_BATCHES_B.BATCH_STATUS%TYPE
106: , MATCH_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.MATCH_ON_DATA_LOAD%TYPE
107: , IMPORT_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.IMPORT_ON_DATA_LOAD%TYPE
108: , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
109: , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
110: , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
111: , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
104: , ASSIGNEE EGO_IMPORT_BATCHES_B.ASSIGNEE%TYPE
105: , BATCH_STATUS EGO_IMPORT_BATCHES_B.BATCH_STATUS%TYPE
106: , MATCH_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.MATCH_ON_DATA_LOAD%TYPE
107: , IMPORT_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.IMPORT_ON_DATA_LOAD%TYPE
108: , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
109: , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
110: , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
111: , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
112: , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
105: , BATCH_STATUS EGO_IMPORT_BATCHES_B.BATCH_STATUS%TYPE
106: , MATCH_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.MATCH_ON_DATA_LOAD%TYPE
107: , IMPORT_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.IMPORT_ON_DATA_LOAD%TYPE
108: , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
109: , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
110: , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
111: , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
112: , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
113: , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
106: , MATCH_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.MATCH_ON_DATA_LOAD%TYPE
107: , IMPORT_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.IMPORT_ON_DATA_LOAD%TYPE
108: , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
109: , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
110: , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
111: , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
112: , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
113: , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
114: , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
107: , IMPORT_ON_DATA_LOAD EGO_IMPORT_OPTION_SETS.IMPORT_ON_DATA_LOAD%TYPE
108: , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
109: , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
110: , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
111: , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
112: , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
113: , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
114: , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
115: , CHANGE_NOTICE EGO_IMPORT_OPTION_SETS.CHANGE_NOTICE%TYPE
108: , IMPORT_XREF_ONLY EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE
109: , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
110: , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
111: , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
112: , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
113: , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
114: , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
115: , CHANGE_NOTICE EGO_IMPORT_OPTION_SETS.CHANGE_NOTICE%TYPE
116: , CHANGE_ORDER_CREATION EGO_IMPORT_OPTION_SETS.CHANGE_ORDER_CREATION%TYPE
109: , STRUCTURE_TYPE_ID EGO_IMPORT_OPTION_SETS.STRUCTURE_TYPE_ID%TYPE
110: , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
111: , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
112: , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
113: , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
114: , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
115: , CHANGE_NOTICE EGO_IMPORT_OPTION_SETS.CHANGE_NOTICE%TYPE
116: , CHANGE_ORDER_CREATION EGO_IMPORT_OPTION_SETS.CHANGE_ORDER_CREATION%TYPE
117: , PDH_BATCH varchar2(1)
110: , STRUCTURE_NAME EGO_IMPORT_OPTION_SETS.STRUCTURE_NAME%TYPE
111: , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
112: , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
113: , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
114: , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
115: , CHANGE_NOTICE EGO_IMPORT_OPTION_SETS.CHANGE_NOTICE%TYPE
116: , CHANGE_ORDER_CREATION EGO_IMPORT_OPTION_SETS.CHANGE_ORDER_CREATION%TYPE
117: , PDH_BATCH varchar2(1)
118: , ADD_ALL_TO_CHANGE_FLAG EGO_IMPORT_OPTION_SETS.ADD_ALL_TO_CHANGE_FLAG%TYPE
111: , STRUCTURE_EFFECTIVITY_TYPE EGO_IMPORT_OPTION_SETS.STRUCTURE_EFFECTIVITY_TYPE%TYPE
112: , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
113: , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
114: , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
115: , CHANGE_NOTICE EGO_IMPORT_OPTION_SETS.CHANGE_NOTICE%TYPE
116: , CHANGE_ORDER_CREATION EGO_IMPORT_OPTION_SETS.CHANGE_ORDER_CREATION%TYPE
117: , PDH_BATCH varchar2(1)
118: , ADD_ALL_TO_CHANGE_FLAG EGO_IMPORT_OPTION_SETS.ADD_ALL_TO_CHANGE_FLAG%TYPE
119: );
112: , EFFECTIVITY_DATE EGO_IMPORT_OPTION_SETS.EFFECTIVITY_DATE%TYPE
113: , FROM_END_ITEM_UNIT_NUMBER EGO_IMPORT_OPTION_SETS.FROM_END_ITEM_UNIT_NUMBER%TYPE
114: , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
115: , CHANGE_NOTICE EGO_IMPORT_OPTION_SETS.CHANGE_NOTICE%TYPE
116: , CHANGE_ORDER_CREATION EGO_IMPORT_OPTION_SETS.CHANGE_ORDER_CREATION%TYPE
117: , PDH_BATCH varchar2(1)
118: , ADD_ALL_TO_CHANGE_FLAG EGO_IMPORT_OPTION_SETS.ADD_ALL_TO_CHANGE_FLAG%TYPE
119: );
120:
114: , STRUCTURE_CONTENT EGO_IMPORT_OPTION_SETS.STRUCTURE_CONTENT%TYPE
115: , CHANGE_NOTICE EGO_IMPORT_OPTION_SETS.CHANGE_NOTICE%TYPE
116: , CHANGE_ORDER_CREATION EGO_IMPORT_OPTION_SETS.CHANGE_ORDER_CREATION%TYPE
117: , PDH_BATCH varchar2(1)
118: , ADD_ALL_TO_CHANGE_FLAG EGO_IMPORT_OPTION_SETS.ADD_ALL_TO_CHANGE_FLAG%TYPE
119: );
120:
121: --TYPE VARCHAR2_VARRAY is VARRAY(3) OF VARCHAR2(25); we have an xdf for this
122: