98:
99: --===================================================================
100: TYPE ams_import_rec_type IS RECORD
101: (
102: import_list_header_id NUMBER := FND_API.G_MISS_NUM,
103: last_update_date DATE := FND_API.G_MISS_DATE,
104: last_updated_by NUMBER := FND_API.G_MISS_NUM,
105: creation_date DATE := FND_API.G_MISS_DATE,
106: created_by NUMBER := FND_API.G_MISS_NUM,
99: --===================================================================
100: TYPE ams_import_rec_type IS RECORD
101: (
102: import_list_header_id NUMBER := FND_API.G_MISS_NUM,
103: last_update_date DATE := FND_API.G_MISS_DATE,
104: last_updated_by NUMBER := FND_API.G_MISS_NUM,
105: creation_date DATE := FND_API.G_MISS_DATE,
106: created_by NUMBER := FND_API.G_MISS_NUM,
107: last_update_login NUMBER := FND_API.G_MISS_NUM,
100: TYPE ams_import_rec_type IS RECORD
101: (
102: import_list_header_id NUMBER := FND_API.G_MISS_NUM,
103: last_update_date DATE := FND_API.G_MISS_DATE,
104: last_updated_by NUMBER := FND_API.G_MISS_NUM,
105: creation_date DATE := FND_API.G_MISS_DATE,
106: created_by NUMBER := FND_API.G_MISS_NUM,
107: last_update_login NUMBER := FND_API.G_MISS_NUM,
108: object_version_number NUMBER := FND_API.G_MISS_NUM,
101: (
102: import_list_header_id NUMBER := FND_API.G_MISS_NUM,
103: last_update_date DATE := FND_API.G_MISS_DATE,
104: last_updated_by NUMBER := FND_API.G_MISS_NUM,
105: creation_date DATE := FND_API.G_MISS_DATE,
106: created_by NUMBER := FND_API.G_MISS_NUM,
107: last_update_login NUMBER := FND_API.G_MISS_NUM,
108: object_version_number NUMBER := FND_API.G_MISS_NUM,
109: view_application_id NUMBER := FND_API.G_MISS_NUM,
102: import_list_header_id NUMBER := FND_API.G_MISS_NUM,
103: last_update_date DATE := FND_API.G_MISS_DATE,
104: last_updated_by NUMBER := FND_API.G_MISS_NUM,
105: creation_date DATE := FND_API.G_MISS_DATE,
106: created_by NUMBER := FND_API.G_MISS_NUM,
107: last_update_login NUMBER := FND_API.G_MISS_NUM,
108: object_version_number NUMBER := FND_API.G_MISS_NUM,
109: view_application_id NUMBER := FND_API.G_MISS_NUM,
110: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
103: last_update_date DATE := FND_API.G_MISS_DATE,
104: last_updated_by NUMBER := FND_API.G_MISS_NUM,
105: creation_date DATE := FND_API.G_MISS_DATE,
106: created_by NUMBER := FND_API.G_MISS_NUM,
107: last_update_login NUMBER := FND_API.G_MISS_NUM,
108: object_version_number NUMBER := FND_API.G_MISS_NUM,
109: view_application_id NUMBER := FND_API.G_MISS_NUM,
110: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
111: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
104: last_updated_by NUMBER := FND_API.G_MISS_NUM,
105: creation_date DATE := FND_API.G_MISS_DATE,
106: created_by NUMBER := FND_API.G_MISS_NUM,
107: last_update_login NUMBER := FND_API.G_MISS_NUM,
108: object_version_number NUMBER := FND_API.G_MISS_NUM,
109: view_application_id NUMBER := FND_API.G_MISS_NUM,
110: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
111: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
112: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: creation_date DATE := FND_API.G_MISS_DATE,
106: created_by NUMBER := FND_API.G_MISS_NUM,
107: last_update_login NUMBER := FND_API.G_MISS_NUM,
108: object_version_number NUMBER := FND_API.G_MISS_NUM,
109: view_application_id NUMBER := FND_API.G_MISS_NUM,
110: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
111: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
112: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: owner_user_id NUMBER := FND_API.G_MISS_NUM,
106: created_by NUMBER := FND_API.G_MISS_NUM,
107: last_update_login NUMBER := FND_API.G_MISS_NUM,
108: object_version_number NUMBER := FND_API.G_MISS_NUM,
109: view_application_id NUMBER := FND_API.G_MISS_NUM,
110: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
111: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
112: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: owner_user_id NUMBER := FND_API.G_MISS_NUM,
114: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
107: last_update_login NUMBER := FND_API.G_MISS_NUM,
108: object_version_number NUMBER := FND_API.G_MISS_NUM,
109: view_application_id NUMBER := FND_API.G_MISS_NUM,
110: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
111: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
112: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: owner_user_id NUMBER := FND_API.G_MISS_NUM,
114: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
115: country NUMBER := FND_API.G_MISS_NUM,
108: object_version_number NUMBER := FND_API.G_MISS_NUM,
109: view_application_id NUMBER := FND_API.G_MISS_NUM,
110: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
111: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
112: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: owner_user_id NUMBER := FND_API.G_MISS_NUM,
114: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
115: country NUMBER := FND_API.G_MISS_NUM,
116: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
109: view_application_id NUMBER := FND_API.G_MISS_NUM,
110: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
111: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
112: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: owner_user_id NUMBER := FND_API.G_MISS_NUM,
114: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
115: country NUMBER := FND_API.G_MISS_NUM,
116: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
117: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
111: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
112: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: owner_user_id NUMBER := FND_API.G_MISS_NUM,
114: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
115: country NUMBER := FND_API.G_MISS_NUM,
116: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
117: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: status_date DATE := FND_API.G_MISS_DATE,
111: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
112: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: owner_user_id NUMBER := FND_API.G_MISS_NUM,
114: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
115: country NUMBER := FND_API.G_MISS_NUM,
116: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
117: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: status_date DATE := FND_API.G_MISS_DATE,
119: user_status_id NUMBER := FND_API.G_MISS_NUM,
112: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: owner_user_id NUMBER := FND_API.G_MISS_NUM,
114: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
115: country NUMBER := FND_API.G_MISS_NUM,
116: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
117: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: status_date DATE := FND_API.G_MISS_DATE,
119: user_status_id NUMBER := FND_API.G_MISS_NUM,
120: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
113: owner_user_id NUMBER := FND_API.G_MISS_NUM,
114: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
115: country NUMBER := FND_API.G_MISS_NUM,
116: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
117: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: status_date DATE := FND_API.G_MISS_DATE,
119: user_status_id NUMBER := FND_API.G_MISS_NUM,
120: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
121: vendor_id NUMBER := FND_API.G_MISS_NUM,
114: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
115: country NUMBER := FND_API.G_MISS_NUM,
116: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
117: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: status_date DATE := FND_API.G_MISS_DATE,
119: user_status_id NUMBER := FND_API.G_MISS_NUM,
120: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
121: vendor_id NUMBER := FND_API.G_MISS_NUM,
122: pin_id NUMBER := FND_API.G_MISS_NUM,
115: country NUMBER := FND_API.G_MISS_NUM,
116: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
117: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: status_date DATE := FND_API.G_MISS_DATE,
119: user_status_id NUMBER := FND_API.G_MISS_NUM,
120: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
121: vendor_id NUMBER := FND_API.G_MISS_NUM,
122: pin_id NUMBER := FND_API.G_MISS_NUM,
123: org_id NUMBER := FND_API.G_MISS_NUM,
116: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
117: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: status_date DATE := FND_API.G_MISS_DATE,
119: user_status_id NUMBER := FND_API.G_MISS_NUM,
120: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
121: vendor_id NUMBER := FND_API.G_MISS_NUM,
122: pin_id NUMBER := FND_API.G_MISS_NUM,
123: org_id NUMBER := FND_API.G_MISS_NUM,
124: scheduled_time DATE := FND_API.G_MISS_DATE,
117: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: status_date DATE := FND_API.G_MISS_DATE,
119: user_status_id NUMBER := FND_API.G_MISS_NUM,
120: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
121: vendor_id NUMBER := FND_API.G_MISS_NUM,
122: pin_id NUMBER := FND_API.G_MISS_NUM,
123: org_id NUMBER := FND_API.G_MISS_NUM,
124: scheduled_time DATE := FND_API.G_MISS_DATE,
125: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
118: status_date DATE := FND_API.G_MISS_DATE,
119: user_status_id NUMBER := FND_API.G_MISS_NUM,
120: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
121: vendor_id NUMBER := FND_API.G_MISS_NUM,
122: pin_id NUMBER := FND_API.G_MISS_NUM,
123: org_id NUMBER := FND_API.G_MISS_NUM,
124: scheduled_time DATE := FND_API.G_MISS_DATE,
125: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
126: loaded_date DATE := FND_API.G_MISS_DATE,
119: user_status_id NUMBER := FND_API.G_MISS_NUM,
120: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
121: vendor_id NUMBER := FND_API.G_MISS_NUM,
122: pin_id NUMBER := FND_API.G_MISS_NUM,
123: org_id NUMBER := FND_API.G_MISS_NUM,
124: scheduled_time DATE := FND_API.G_MISS_DATE,
125: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
126: loaded_date DATE := FND_API.G_MISS_DATE,
127: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
120: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
121: vendor_id NUMBER := FND_API.G_MISS_NUM,
122: pin_id NUMBER := FND_API.G_MISS_NUM,
123: org_id NUMBER := FND_API.G_MISS_NUM,
124: scheduled_time DATE := FND_API.G_MISS_DATE,
125: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
126: loaded_date DATE := FND_API.G_MISS_DATE,
127: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
128: processed_rows NUMBER := FND_API.G_MISS_NUM,
121: vendor_id NUMBER := FND_API.G_MISS_NUM,
122: pin_id NUMBER := FND_API.G_MISS_NUM,
123: org_id NUMBER := FND_API.G_MISS_NUM,
124: scheduled_time DATE := FND_API.G_MISS_DATE,
125: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
126: loaded_date DATE := FND_API.G_MISS_DATE,
127: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
128: processed_rows NUMBER := FND_API.G_MISS_NUM,
129: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: pin_id NUMBER := FND_API.G_MISS_NUM,
123: org_id NUMBER := FND_API.G_MISS_NUM,
124: scheduled_time DATE := FND_API.G_MISS_DATE,
125: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
126: loaded_date DATE := FND_API.G_MISS_DATE,
127: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
128: processed_rows NUMBER := FND_API.G_MISS_NUM,
129: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: expiry_date DATE := FND_API.G_MISS_DATE,
123: org_id NUMBER := FND_API.G_MISS_NUM,
124: scheduled_time DATE := FND_API.G_MISS_DATE,
125: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
126: loaded_date DATE := FND_API.G_MISS_DATE,
127: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
128: processed_rows NUMBER := FND_API.G_MISS_NUM,
129: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: expiry_date DATE := FND_API.G_MISS_DATE,
131: purge_date DATE := FND_API.G_MISS_DATE,
124: scheduled_time DATE := FND_API.G_MISS_DATE,
125: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
126: loaded_date DATE := FND_API.G_MISS_DATE,
127: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
128: processed_rows NUMBER := FND_API.G_MISS_NUM,
129: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: expiry_date DATE := FND_API.G_MISS_DATE,
131: purge_date DATE := FND_API.G_MISS_DATE,
132: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
125: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
126: loaded_date DATE := FND_API.G_MISS_DATE,
127: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
128: processed_rows NUMBER := FND_API.G_MISS_NUM,
129: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: expiry_date DATE := FND_API.G_MISS_DATE,
131: purge_date DATE := FND_API.G_MISS_DATE,
132: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
133: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
126: loaded_date DATE := FND_API.G_MISS_DATE,
127: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
128: processed_rows NUMBER := FND_API.G_MISS_NUM,
129: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: expiry_date DATE := FND_API.G_MISS_DATE,
131: purge_date DATE := FND_API.G_MISS_DATE,
132: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
133: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: transactional_cost NUMBER := FND_API.G_MISS_NUM,
127: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
128: processed_rows NUMBER := FND_API.G_MISS_NUM,
129: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: expiry_date DATE := FND_API.G_MISS_DATE,
131: purge_date DATE := FND_API.G_MISS_DATE,
132: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
133: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: transactional_cost NUMBER := FND_API.G_MISS_NUM,
135: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
128: processed_rows NUMBER := FND_API.G_MISS_NUM,
129: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: expiry_date DATE := FND_API.G_MISS_DATE,
131: purge_date DATE := FND_API.G_MISS_DATE,
132: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
133: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: transactional_cost NUMBER := FND_API.G_MISS_NUM,
135: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
136: functional_cost NUMBER := FND_API.G_MISS_NUM,
129: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130: expiry_date DATE := FND_API.G_MISS_DATE,
131: purge_date DATE := FND_API.G_MISS_DATE,
132: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
133: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: transactional_cost NUMBER := FND_API.G_MISS_NUM,
135: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
136: functional_cost NUMBER := FND_API.G_MISS_NUM,
137: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
130: expiry_date DATE := FND_API.G_MISS_DATE,
131: purge_date DATE := FND_API.G_MISS_DATE,
132: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
133: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: transactional_cost NUMBER := FND_API.G_MISS_NUM,
135: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
136: functional_cost NUMBER := FND_API.G_MISS_NUM,
137: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
138: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
131: purge_date DATE := FND_API.G_MISS_DATE,
132: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
133: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: transactional_cost NUMBER := FND_API.G_MISS_NUM,
135: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
136: functional_cost NUMBER := FND_API.G_MISS_NUM,
137: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
138: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
132: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
133: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: transactional_cost NUMBER := FND_API.G_MISS_NUM,
135: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
136: functional_cost NUMBER := FND_API.G_MISS_NUM,
137: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
138: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
140: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
133: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: transactional_cost NUMBER := FND_API.G_MISS_NUM,
135: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
136: functional_cost NUMBER := FND_API.G_MISS_NUM,
137: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
138: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
140: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
141: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
134: transactional_cost NUMBER := FND_API.G_MISS_NUM,
135: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
136: functional_cost NUMBER := FND_API.G_MISS_NUM,
137: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
138: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
140: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
141: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
142: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
135: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
136: functional_cost NUMBER := FND_API.G_MISS_NUM,
137: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
138: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
140: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
141: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
142: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
143: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
136: functional_cost NUMBER := FND_API.G_MISS_NUM,
137: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
138: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
140: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
141: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
142: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
143: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
138: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
140: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
141: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
142: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
143: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
139: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
140: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
141: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
142: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
143: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
140: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
141: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
142: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
143: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
141: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
142: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
143: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
142: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
143: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
143: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: usage NUMBER := FND_API.G_MISS_NUM,
152: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: usage NUMBER := FND_API.G_MISS_NUM,
160: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
153: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: usage NUMBER := FND_API.G_MISS_NUM,
160: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
154: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: usage NUMBER := FND_API.G_MISS_NUM,
160: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: log_file_name NUMBER := FND_API.G_MISS_NUM,
155: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: usage NUMBER := FND_API.G_MISS_NUM,
160: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: log_file_name NUMBER := FND_API.G_MISS_NUM,
163: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
156: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: usage NUMBER := FND_API.G_MISS_NUM,
160: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: log_file_name NUMBER := FND_API.G_MISS_NUM,
163: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
164: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
157: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: usage NUMBER := FND_API.G_MISS_NUM,
160: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: log_file_name NUMBER := FND_API.G_MISS_NUM,
163: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
164: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
165: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
158: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: usage NUMBER := FND_API.G_MISS_NUM,
160: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: log_file_name NUMBER := FND_API.G_MISS_NUM,
163: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
164: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
165: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
166: );
159: usage NUMBER := FND_API.G_MISS_NUM,
160: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: log_file_name NUMBER := FND_API.G_MISS_NUM,
163: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
164: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
165: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
166: );
167:
160: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: log_file_name NUMBER := FND_API.G_MISS_NUM,
163: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
164: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
165: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
166: );
167:
168: g_miss_ams_import_rec ams_import_rec_type;
161: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162: log_file_name NUMBER := FND_API.G_MISS_NUM,
163: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
164: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
165: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
166: );
167:
168: g_miss_ams_import_rec ams_import_rec_type;
169: TYPE ams_import_tbl_type IS TABLE OF ams_import_rec_type INDEX BY BINARY_INTEGER;
187: -- Parameters
188: --
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_ams_import_rec IN ams_import_rec_type Required
194: --
195: -- OUT
188: --
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_ams_import_rec IN ams_import_rec_type Required
194: --
195: -- OUT
196: -- x_return_status OUT VARCHAR2
205: --
206:
207: PROCEDURE Create_Import_List(
208: p_api_version_number IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211:
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
206:
207: PROCEDURE Create_Import_List(
208: p_api_version_number IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211:
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
229: -- Parameters
230: --
231: -- IN
232: -- p_api_version_number IN NUMBER Required
233: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
234: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
235: -- p_ams_import_rec IN ams_import_rec_type Required
236: --
237: -- OUT
230: --
231: -- IN
232: -- p_api_version_number IN NUMBER Required
233: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
234: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
235: -- p_ams_import_rec IN ams_import_rec_type Required
236: --
237: -- OUT
238: -- x_return_status OUT VARCHAR2
247: --
248:
249: PROCEDURE Update_Import_List(
250: p_api_version_number IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE,
253:
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
248:
249: PROCEDURE Update_Import_List(
250: p_api_version_number IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE,
253:
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
271: -- Parameters
272: --
273: -- IN
274: -- p_api_version_number IN NUMBER Required
275: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
276: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
277: -- p_IMPORT_LIST_HEADER_ID IN NUMBER
278: -- p_object_version_number IN NUMBER Optional Default = NULL
279: --
272: --
273: -- IN
274: -- p_api_version_number IN NUMBER Required
275: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
276: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
277: -- p_IMPORT_LIST_HEADER_ID IN NUMBER
278: -- p_object_version_number IN NUMBER Optional Default = NULL
279: --
280: -- OUT
290: --
291:
292: PROCEDURE Delete_Import_List(
293: p_api_version_number IN NUMBER,
294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
295: p_commit IN VARCHAR2 := FND_API.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
291:
292: PROCEDURE Delete_Import_List(
293: p_api_version_number IN NUMBER,
294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
295: p_commit IN VARCHAR2 := FND_API.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: p_import_list_header_id IN NUMBER,
312: -- Parameters
313: --
314: -- IN
315: -- p_api_version_number IN NUMBER Required
316: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
317: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
318: -- p_ams_import_rec IN ams_import_rec_type Required
319: --
320: -- OUT
313: --
314: -- IN
315: -- p_api_version_number IN NUMBER Required
316: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
317: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
318: -- p_ams_import_rec IN ams_import_rec_type Required
319: --
320: -- OUT
321: -- x_return_status OUT VARCHAR2
330: --
331:
332: PROCEDURE Lock_Import_List(
333: p_api_version_number IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335: x_return_status OUT NOCOPY VARCHAR2,
336: x_msg_count OUT NOCOPY NUMBER,
337: x_msg_data OUT NOCOPY VARCHAR2,
338: