91: --file_size,
92: file_size
93: --last_updated_by
94: ) VALUES (
95: DECODE( px_imp_document_id, FND_API.G_MISS_NUM, NULL, px_imp_document_id),
96: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: file_size
93: --last_updated_by
94: ) VALUES (
95: DECODE( px_imp_document_id, FND_API.G_MISS_NUM, NULL, px_imp_document_id),
96: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: --last_updated_by
94: ) VALUES (
95: DECODE( px_imp_document_id, FND_API.G_MISS_NUM, NULL, px_imp_document_id),
96: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
94: ) VALUES (
95: DECODE( px_imp_document_id, FND_API.G_MISS_NUM, NULL, px_imp_document_id),
96: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
95: DECODE( px_imp_document_id, FND_API.G_MISS_NUM, NULL, px_imp_document_id),
96: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
96: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
97: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
98: --DECODE( p_last_update_by, FND_API.G_MISS_NUM, NULL, p_last_update_by),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
99: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
100: --DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
101: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
102: --DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
103: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
104: --DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
105: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
106: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
107: --DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
108: DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
109: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),
110: --DECODE( p_content_text, FND_API.g_miss_char, NULL, p_content_text),
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),
118: DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size));
111: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),
118: DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size));
119: --DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by));
112: --DECODE( p_dtd_text, FND_API.g_miss_char, NULL, p_dtd_text),
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),
118: DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size));
119: --DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by));
120:
113: DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),
118: DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size));
119: --DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by));
120:
121: END Insert_Row;
114: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),
118: DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size));
119: --DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by));
120:
121: END Insert_Row;
122:
115: --DECODE( p_filter_content_text, FND_API.g_miss_char, NULL, p_filter_content_text),
116: --DECODE( p_file_type, FND_API.g_miss_char, NULL, p_file_type),
117: --DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size),
118: DECODE( p_file_size, FND_API.G_MISS_NUM, NULL, p_file_size));
119: --DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by));
120:
121: END Insert_Row;
122:
123:
152: IS
153: BEGIN
154: Update ams_imp_documents
155: SET
156: imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
153: BEGIN
154: Update ams_imp_documents
155: SET
156: imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
154: Update ams_imp_documents
155: SET
156: imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
155: SET
156: imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
156: imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
159: --last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
160: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
161: --last_update_by = DECODE( p_last_update_by, null, last_update_by, FND_API.G_MISS_NUM, null, p_last_update_by),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
162: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
163: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
171: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
171: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
165: -- created_by = DECODE( p_created_by, null, created_by, FND_API.G_MISS_NUM, null, p_created_by),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
171: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
166: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
171: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
167: --last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
171: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
168: -- creation_date = DECODE( p_creation_date, null, creation_date, FND_API.G_MISS_DATE, null, p_creation_date),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
171: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
169: -- object_version_number = DECODE( px_object_version_number, null , nvl(object_version_number,1), FND_API.G_MISS_NUM, 1, p_object_version_number),
170: --import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
171: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
170: --import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
171: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
171: import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
172: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),
173: --content_text = DECODE( p_content_text, null, content_text, FND_API.g_miss_char, null, p_content_text),
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),
181: file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size)
174: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),
181: file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size)
182: --last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
175: --dtd_text = DECODE( p_dtd_text, null, dtd_text, FND_API.g_miss_char, null, p_dtd_text),
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),
181: file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size)
182: --last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
183: WHERE imp_document_id = p_imp_document_id
176: file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),
181: file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size)
182: --last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
183: WHERE imp_document_id = p_imp_document_id
184: AND object_version_number = px_object_version_number;
177: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),
181: file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size)
182: --last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
183: WHERE imp_document_id = p_imp_document_id
184: AND object_version_number = px_object_version_number;
185:
178: --filter_content_text = DECODE( p_filter_content_text, null, filter_content_text, FND_API.g_miss_char, null, p_filter_content_text),
179: --file_type = DECODE( p_file_type, null, file_type, FND_API.g_miss_char, null, p_file_type),
180: --file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size),
181: file_size = DECODE( p_file_size, null, file_size, FND_API.G_MISS_NUM, null, p_file_size)
182: --last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
183: WHERE imp_document_id = p_imp_document_id
184: AND object_version_number = px_object_version_number;
185:
186:
184: AND object_version_number = px_object_version_number;
185:
186:
187: IF (SQL%NOTFOUND) THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: END IF;
190:
191: px_object_version_number := nvl(px_object_version_number,0) + 1;
192:
215: DELETE FROM ams_imp_documents
216: WHERE imp_document_id = p_imp_document_id
217: AND object_version_number = p_object_version_number;
218: If (SQL%NOTFOUND) then
219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: End If;
221: END Delete_Row ;
222:
223: