eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_IMP_XML_ELEMENTS_PKG dependencies on FND_API

Line 91: DECODE( px_imp_xml_element_id, FND_API.g_miss_num, NULL, px_imp_xml_element_id),

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),

Line 92: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

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),

Line 93: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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),

Line 94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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),

Line 95: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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),

Line 96: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

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),

Line 97: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

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),

Line 98: DECODE( p_imp_xml_document_id, FND_API.g_miss_num, NULL, p_imp_xml_document_id),

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),

Line 99: DECODE( p_order_initial, FND_API.g_miss_num, NULL, p_order_initial),

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),

Line 100: DECODE( p_order_final, FND_API.g_miss_num, NULL, p_order_final),

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),

Line 101: DECODE( p_column_name, FND_API.g_miss_char, NULL, p_column_name),

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),

Line 102: DECODE( p_data, FND_API.g_miss_char, NULL, p_data),

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));

Line 103: DECODE( p_num_attr, FND_API.g_miss_num, NULL, p_num_attr),

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;

Line 104: DECODE( p_data_type, FND_API.g_miss_char, NULL, p_data_type),

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:

Line 105: DECODE( p_load_status, FND_API.g_miss_char, NULL, p_load_status),

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:

Line 106: DECODE( p_error_text, FND_API.g_miss_char, NULL, p_error_text));

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: ----------------------------------------------------------

Line 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),

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),

Line 149: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

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),

Line 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),

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),

Line 151: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

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),

Line 152: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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),

Line 153: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

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),

Line 154: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

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),

Line 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),

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),

Line 156: order_initial = DECODE( p_order_initial, FND_API.g_miss_num, order_initial, p_order_initial),

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),

Line 157: order_final = DECODE( p_order_final, FND_API.g_miss_num, order_final, p_order_final),

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),

Line 158: column_name = DECODE( p_column_name, FND_API.g_miss_char, column_name, p_column_name),

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),

Line 159: data = DECODE( p_data, FND_API.g_miss_char, data, p_data),

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)

Line 160: num_attr = DECODE( p_num_attr, FND_API.g_miss_num, num_attr, p_num_attr),

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

Line 161: data_type = DECODE( p_data_type, FND_API.g_miss_char, data_type, p_data_type),

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;

Line 162: load_status = DECODE( p_load_status, FND_API.g_miss_char, load_status, p_load_status),

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:

Line 163: error_text = DECODE( p_error_text, FND_API.g_miss_char, error_text, p_error_text)

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

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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: