87: data_type,
88: load_status,
89: error_text
90: ) VALUES (
91: DECODE( px_imp_xml_element_id, FND_API.g_miss_num, NULL, px_imp_xml_element_id),
92: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
93: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: load_status,
89: error_text
90: ) VALUES (
91: DECODE( px_imp_xml_element_id, FND_API.g_miss_num, NULL, px_imp_xml_element_id),
92: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
93: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
96: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
89: error_text
90: ) VALUES (
91: DECODE( px_imp_xml_element_id, FND_API.g_miss_num, NULL, px_imp_xml_element_id),
92: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
93: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
96: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
97: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
90: ) VALUES (
91: DECODE( px_imp_xml_element_id, FND_API.g_miss_num, NULL, px_imp_xml_element_id),
92: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
93: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
96: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
97: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
98: DECODE( p_imp_xml_document_id, FND_API.g_miss_num, NULL, p_imp_xml_document_id),
91: DECODE( px_imp_xml_element_id, FND_API.g_miss_num, NULL, px_imp_xml_element_id),
92: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
93: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
96: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
97: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
98: DECODE( p_imp_xml_document_id, FND_API.g_miss_num, NULL, p_imp_xml_document_id),
99: DECODE( p_order_initial, FND_API.g_miss_num, NULL, p_order_initial),
92: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
93: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
96: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
97: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
98: DECODE( p_imp_xml_document_id, FND_API.g_miss_num, NULL, p_imp_xml_document_id),
99: DECODE( p_order_initial, FND_API.g_miss_num, NULL, p_order_initial),
100: DECODE( p_order_final, FND_API.g_miss_num, NULL, p_order_final),
93: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
96: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
97: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
98: DECODE( p_imp_xml_document_id, FND_API.g_miss_num, NULL, p_imp_xml_document_id),
99: DECODE( p_order_initial, FND_API.g_miss_num, NULL, p_order_initial),
100: DECODE( p_order_final, FND_API.g_miss_num, NULL, p_order_final),
101: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
96: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
97: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
98: DECODE( p_imp_xml_document_id, FND_API.g_miss_num, NULL, p_imp_xml_document_id),
99: DECODE( p_order_initial, FND_API.g_miss_num, NULL, p_order_initial),
100: DECODE( p_order_final, FND_API.g_miss_num, NULL, p_order_final),
101: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
102: DECODE( p_data, FND_API.g_miss_char, NULL, p_data),
95: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
96: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
97: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
98: DECODE( p_imp_xml_document_id, FND_API.g_miss_num, NULL, p_imp_xml_document_id),
99: DECODE( p_order_initial, FND_API.g_miss_num, NULL, p_order_initial),
100: DECODE( p_order_final, FND_API.g_miss_num, NULL, p_order_final),
101: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
102: DECODE( p_data, FND_API.g_miss_char, NULL, p_data),
103: DECODE( p_num_attr, FND_API.g_miss_num, NULL, p_num_attr),
96: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
97: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
98: DECODE( p_imp_xml_document_id, FND_API.g_miss_num, NULL, p_imp_xml_document_id),
99: DECODE( p_order_initial, FND_API.g_miss_num, NULL, p_order_initial),
100: DECODE( p_order_final, FND_API.g_miss_num, NULL, p_order_final),
101: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
102: DECODE( p_data, FND_API.g_miss_char, NULL, p_data),
103: DECODE( p_num_attr, FND_API.g_miss_num, NULL, p_num_attr),
104: DECODE( p_data_type, FND_API.g_miss_char, NULL, p_data_type),
97: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
98: DECODE( p_imp_xml_document_id, FND_API.g_miss_num, NULL, p_imp_xml_document_id),
99: DECODE( p_order_initial, FND_API.g_miss_num, NULL, p_order_initial),
100: DECODE( p_order_final, FND_API.g_miss_num, NULL, p_order_final),
101: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
102: DECODE( p_data, FND_API.g_miss_char, NULL, p_data),
103: DECODE( p_num_attr, FND_API.g_miss_num, NULL, p_num_attr),
104: DECODE( p_data_type, FND_API.g_miss_char, NULL, p_data_type),
105: DECODE( p_load_status, FND_API.g_miss_char, NULL, p_load_status),
98: DECODE( p_imp_xml_document_id, FND_API.g_miss_num, NULL, p_imp_xml_document_id),
99: DECODE( p_order_initial, FND_API.g_miss_num, NULL, p_order_initial),
100: DECODE( p_order_final, FND_API.g_miss_num, NULL, p_order_final),
101: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
102: DECODE( p_data, FND_API.g_miss_char, NULL, p_data),
103: DECODE( p_num_attr, FND_API.g_miss_num, NULL, p_num_attr),
104: DECODE( p_data_type, FND_API.g_miss_char, NULL, p_data_type),
105: DECODE( p_load_status, FND_API.g_miss_char, NULL, p_load_status),
106: DECODE( p_error_text, FND_API.g_miss_char, NULL, p_error_text));
99: DECODE( p_order_initial, FND_API.g_miss_num, NULL, p_order_initial),
100: DECODE( p_order_final, FND_API.g_miss_num, NULL, p_order_final),
101: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
102: DECODE( p_data, FND_API.g_miss_char, NULL, p_data),
103: DECODE( p_num_attr, FND_API.g_miss_num, NULL, p_num_attr),
104: DECODE( p_data_type, FND_API.g_miss_char, NULL, p_data_type),
105: DECODE( p_load_status, FND_API.g_miss_char, NULL, p_load_status),
106: DECODE( p_error_text, FND_API.g_miss_char, NULL, p_error_text));
107: END Insert_Row;
100: DECODE( p_order_final, FND_API.g_miss_num, NULL, p_order_final),
101: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
102: DECODE( p_data, FND_API.g_miss_char, NULL, p_data),
103: DECODE( p_num_attr, FND_API.g_miss_num, NULL, p_num_attr),
104: DECODE( p_data_type, FND_API.g_miss_char, NULL, p_data_type),
105: DECODE( p_load_status, FND_API.g_miss_char, NULL, p_load_status),
106: DECODE( p_error_text, FND_API.g_miss_char, NULL, p_error_text));
107: END Insert_Row;
108:
101: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),
102: DECODE( p_data, FND_API.g_miss_char, NULL, p_data),
103: DECODE( p_num_attr, FND_API.g_miss_num, NULL, p_num_attr),
104: DECODE( p_data_type, FND_API.g_miss_char, NULL, p_data_type),
105: DECODE( p_load_status, FND_API.g_miss_char, NULL, p_load_status),
106: DECODE( p_error_text, FND_API.g_miss_char, NULL, p_error_text));
107: END Insert_Row;
108:
109:
102: DECODE( p_data, FND_API.g_miss_char, NULL, p_data),
103: DECODE( p_num_attr, FND_API.g_miss_num, NULL, p_num_attr),
104: DECODE( p_data_type, FND_API.g_miss_char, NULL, p_data_type),
105: DECODE( p_load_status, FND_API.g_miss_char, NULL, p_load_status),
106: DECODE( p_error_text, FND_API.g_miss_char, NULL, p_error_text));
107: END Insert_Row;
108:
109:
110: ----------------------------------------------------------
144: IS
145: BEGIN
146: Update AMS_IMP_XML_ELEMENTS
147: SET
148: imp_xml_element_id = DECODE( p_imp_xml_element_id, FND_API.g_miss_num, imp_xml_element_id, p_imp_xml_element_id),
149: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
150: object_version_number = object_version_number + 1, --DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
151: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
152: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
145: BEGIN
146: Update AMS_IMP_XML_ELEMENTS
147: SET
148: imp_xml_element_id = DECODE( p_imp_xml_element_id, FND_API.g_miss_num, imp_xml_element_id, p_imp_xml_element_id),
149: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
150: object_version_number = object_version_number + 1, --DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
151: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
152: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
146: Update AMS_IMP_XML_ELEMENTS
147: SET
148: imp_xml_element_id = DECODE( p_imp_xml_element_id, FND_API.g_miss_num, imp_xml_element_id, p_imp_xml_element_id),
149: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
150: object_version_number = object_version_number + 1, --DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
151: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
152: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
147: SET
148: imp_xml_element_id = DECODE( p_imp_xml_element_id, FND_API.g_miss_num, imp_xml_element_id, p_imp_xml_element_id),
149: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
150: object_version_number = object_version_number + 1, --DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
151: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
152: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
155: imp_xml_document_id = DECODE( p_imp_xml_document_id, FND_API.g_miss_num, imp_xml_document_id, p_imp_xml_document_id),
148: imp_xml_element_id = DECODE( p_imp_xml_element_id, FND_API.g_miss_num, imp_xml_element_id, p_imp_xml_element_id),
149: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
150: object_version_number = object_version_number + 1, --DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
151: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
152: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
155: imp_xml_document_id = DECODE( p_imp_xml_document_id, FND_API.g_miss_num, imp_xml_document_id, p_imp_xml_document_id),
156: order_initial = DECODE( p_order_initial, FND_API.g_miss_num, order_initial, p_order_initial),
149: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
150: object_version_number = object_version_number + 1, --DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
151: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
152: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
155: imp_xml_document_id = DECODE( p_imp_xml_document_id, FND_API.g_miss_num, imp_xml_document_id, p_imp_xml_document_id),
156: order_initial = DECODE( p_order_initial, FND_API.g_miss_num, order_initial, p_order_initial),
157: order_final = DECODE( p_order_final, FND_API.g_miss_num, order_final, p_order_final),
150: object_version_number = object_version_number + 1, --DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
151: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
152: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
155: imp_xml_document_id = DECODE( p_imp_xml_document_id, FND_API.g_miss_num, imp_xml_document_id, p_imp_xml_document_id),
156: order_initial = DECODE( p_order_initial, FND_API.g_miss_num, order_initial, p_order_initial),
157: order_final = DECODE( p_order_final, FND_API.g_miss_num, order_final, p_order_final),
158: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
151: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
152: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
155: imp_xml_document_id = DECODE( p_imp_xml_document_id, FND_API.g_miss_num, imp_xml_document_id, p_imp_xml_document_id),
156: order_initial = DECODE( p_order_initial, FND_API.g_miss_num, order_initial, p_order_initial),
157: order_final = DECODE( p_order_final, FND_API.g_miss_num, order_final, p_order_final),
158: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
159: data = DECODE( p_data, FND_API.g_miss_char, data, p_data),
152: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
155: imp_xml_document_id = DECODE( p_imp_xml_document_id, FND_API.g_miss_num, imp_xml_document_id, p_imp_xml_document_id),
156: order_initial = DECODE( p_order_initial, FND_API.g_miss_num, order_initial, p_order_initial),
157: order_final = DECODE( p_order_final, FND_API.g_miss_num, order_final, p_order_final),
158: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
159: data = DECODE( p_data, FND_API.g_miss_char, data, p_data),
160: num_attr = DECODE( p_num_attr, FND_API.g_miss_num, num_attr, p_num_attr),
153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
155: imp_xml_document_id = DECODE( p_imp_xml_document_id, FND_API.g_miss_num, imp_xml_document_id, p_imp_xml_document_id),
156: order_initial = DECODE( p_order_initial, FND_API.g_miss_num, order_initial, p_order_initial),
157: order_final = DECODE( p_order_final, FND_API.g_miss_num, order_final, p_order_final),
158: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
159: data = DECODE( p_data, FND_API.g_miss_char, data, p_data),
160: num_attr = DECODE( p_num_attr, FND_API.g_miss_num, num_attr, p_num_attr),
161: data_type = DECODE( p_data_type, FND_API.g_miss_char, data_type, p_data_type),
154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
155: imp_xml_document_id = DECODE( p_imp_xml_document_id, FND_API.g_miss_num, imp_xml_document_id, p_imp_xml_document_id),
156: order_initial = DECODE( p_order_initial, FND_API.g_miss_num, order_initial, p_order_initial),
157: order_final = DECODE( p_order_final, FND_API.g_miss_num, order_final, p_order_final),
158: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
159: data = DECODE( p_data, FND_API.g_miss_char, data, p_data),
160: num_attr = DECODE( p_num_attr, FND_API.g_miss_num, num_attr, p_num_attr),
161: data_type = DECODE( p_data_type, FND_API.g_miss_char, data_type, p_data_type),
162: load_status = DECODE( p_load_status, FND_API.g_miss_char, load_status, p_load_status),
155: imp_xml_document_id = DECODE( p_imp_xml_document_id, FND_API.g_miss_num, imp_xml_document_id, p_imp_xml_document_id),
156: order_initial = DECODE( p_order_initial, FND_API.g_miss_num, order_initial, p_order_initial),
157: order_final = DECODE( p_order_final, FND_API.g_miss_num, order_final, p_order_final),
158: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
159: data = DECODE( p_data, FND_API.g_miss_char, data, p_data),
160: num_attr = DECODE( p_num_attr, FND_API.g_miss_num, num_attr, p_num_attr),
161: data_type = DECODE( p_data_type, FND_API.g_miss_char, data_type, p_data_type),
162: load_status = DECODE( p_load_status, FND_API.g_miss_char, load_status, p_load_status),
163: error_text = DECODE( p_error_text, FND_API.g_miss_char, error_text, p_error_text)
156: order_initial = DECODE( p_order_initial, FND_API.g_miss_num, order_initial, p_order_initial),
157: order_final = DECODE( p_order_final, FND_API.g_miss_num, order_final, p_order_final),
158: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
159: data = DECODE( p_data, FND_API.g_miss_char, data, p_data),
160: num_attr = DECODE( p_num_attr, FND_API.g_miss_num, num_attr, p_num_attr),
161: data_type = DECODE( p_data_type, FND_API.g_miss_char, data_type, p_data_type),
162: load_status = DECODE( p_load_status, FND_API.g_miss_char, load_status, p_load_status),
163: error_text = DECODE( p_error_text, FND_API.g_miss_char, error_text, p_error_text)
164: WHERE IMP_XML_ELEMENT_ID = p_IMP_XML_ELEMENT_ID
157: order_final = DECODE( p_order_final, FND_API.g_miss_num, order_final, p_order_final),
158: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
159: data = DECODE( p_data, FND_API.g_miss_char, data, p_data),
160: num_attr = DECODE( p_num_attr, FND_API.g_miss_num, num_attr, p_num_attr),
161: data_type = DECODE( p_data_type, FND_API.g_miss_char, data_type, p_data_type),
162: load_status = DECODE( p_load_status, FND_API.g_miss_char, load_status, p_load_status),
163: error_text = DECODE( p_error_text, FND_API.g_miss_char, error_text, p_error_text)
164: WHERE IMP_XML_ELEMENT_ID = p_IMP_XML_ELEMENT_ID
165: AND object_version_number = p_object_version_number;
158: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),
159: data = DECODE( p_data, FND_API.g_miss_char, data, p_data),
160: num_attr = DECODE( p_num_attr, FND_API.g_miss_num, num_attr, p_num_attr),
161: data_type = DECODE( p_data_type, FND_API.g_miss_char, data_type, p_data_type),
162: load_status = DECODE( p_load_status, FND_API.g_miss_char, load_status, p_load_status),
163: error_text = DECODE( p_error_text, FND_API.g_miss_char, error_text, p_error_text)
164: WHERE IMP_XML_ELEMENT_ID = p_IMP_XML_ELEMENT_ID
165: AND object_version_number = p_object_version_number;
166:
159: data = DECODE( p_data, FND_API.g_miss_char, data, p_data),
160: num_attr = DECODE( p_num_attr, FND_API.g_miss_num, num_attr, p_num_attr),
161: data_type = DECODE( p_data_type, FND_API.g_miss_char, data_type, p_data_type),
162: load_status = DECODE( p_load_status, FND_API.g_miss_char, load_status, p_load_status),
163: error_text = DECODE( p_error_text, FND_API.g_miss_char, error_text, p_error_text)
164: WHERE IMP_XML_ELEMENT_ID = p_IMP_XML_ELEMENT_ID
165: AND object_version_number = p_object_version_number;
166:
167: IF (SQL%NOTFOUND) THEN
164: WHERE IMP_XML_ELEMENT_ID = p_IMP_XML_ELEMENT_ID
165: AND object_version_number = p_object_version_number;
166:
167: IF (SQL%NOTFOUND) THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170: END Update_Row;
171:
172:
192: BEGIN
193: DELETE FROM AMS_IMP_XML_ELEMENTS
194: WHERE IMP_XML_ELEMENT_ID = p_IMP_XML_ELEMENT_ID;
195: If (SQL%NOTFOUND) then
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: End If;
198: END Delete_Row ;
199:
200: