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.CSI_SYSTEMS_H_PKG dependencies on FND_API

Line 99: IF (px_system_history_id IS NULL) OR (px_system_history_id = fnd_api.g_miss_num) THEN

95:
96: IS
97: CURSOR c2 IS SELECT csi_systems_h_s.NEXTVAL FROM sys.dual;
98: BEGIN
99: IF (px_system_history_id IS NULL) OR (px_system_history_id = fnd_api.g_miss_num) THEN
100: OPEN c2;
101: FETCH c2 INTO px_system_history_id;
102: CLOSE c2;
103: END IF;

Line 187: DECODE( p_system_id, fnd_api.g_miss_num, NULL, p_system_id),

183: old_operating_unit_id,
184: new_operating_unit_id
185: ) VALUES (
186: px_system_history_id,
187: DECODE( p_system_id, fnd_api.g_miss_num, NULL, p_system_id),
188: DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
189: DECODE( p_old_customer_id, fnd_api.g_miss_num, NULL, p_old_customer_id),
190: DECODE( p_new_customer_id, fnd_api.g_miss_num, NULL, p_new_customer_id),
191: DECODE( p_old_system_type_code, fnd_api.g_miss_char, NULL, p_old_system_type_code),

Line 188: DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),

184: new_operating_unit_id
185: ) VALUES (
186: px_system_history_id,
187: DECODE( p_system_id, fnd_api.g_miss_num, NULL, p_system_id),
188: DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
189: DECODE( p_old_customer_id, fnd_api.g_miss_num, NULL, p_old_customer_id),
190: DECODE( p_new_customer_id, fnd_api.g_miss_num, NULL, p_new_customer_id),
191: DECODE( p_old_system_type_code, fnd_api.g_miss_char, NULL, p_old_system_type_code),
192: DECODE( p_new_system_type_code, fnd_api.g_miss_char, NULL, p_new_system_type_code),

Line 189: DECODE( p_old_customer_id, fnd_api.g_miss_num, NULL, p_old_customer_id),

185: ) VALUES (
186: px_system_history_id,
187: DECODE( p_system_id, fnd_api.g_miss_num, NULL, p_system_id),
188: DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
189: DECODE( p_old_customer_id, fnd_api.g_miss_num, NULL, p_old_customer_id),
190: DECODE( p_new_customer_id, fnd_api.g_miss_num, NULL, p_new_customer_id),
191: DECODE( p_old_system_type_code, fnd_api.g_miss_char, NULL, p_old_system_type_code),
192: DECODE( p_new_system_type_code, fnd_api.g_miss_char, NULL, p_new_system_type_code),
193: DECODE( p_old_system_number, fnd_api.g_miss_char, NULL, p_old_system_number),

Line 190: DECODE( p_new_customer_id, fnd_api.g_miss_num, NULL, p_new_customer_id),

186: px_system_history_id,
187: DECODE( p_system_id, fnd_api.g_miss_num, NULL, p_system_id),
188: DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
189: DECODE( p_old_customer_id, fnd_api.g_miss_num, NULL, p_old_customer_id),
190: DECODE( p_new_customer_id, fnd_api.g_miss_num, NULL, p_new_customer_id),
191: DECODE( p_old_system_type_code, fnd_api.g_miss_char, NULL, p_old_system_type_code),
192: DECODE( p_new_system_type_code, fnd_api.g_miss_char, NULL, p_new_system_type_code),
193: DECODE( p_old_system_number, fnd_api.g_miss_char, NULL, p_old_system_number),
194: DECODE( p_new_system_number, fnd_api.g_miss_char, NULL, p_new_system_number),

Line 191: DECODE( p_old_system_type_code, fnd_api.g_miss_char, NULL, p_old_system_type_code),

187: DECODE( p_system_id, fnd_api.g_miss_num, NULL, p_system_id),
188: DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
189: DECODE( p_old_customer_id, fnd_api.g_miss_num, NULL, p_old_customer_id),
190: DECODE( p_new_customer_id, fnd_api.g_miss_num, NULL, p_new_customer_id),
191: DECODE( p_old_system_type_code, fnd_api.g_miss_char, NULL, p_old_system_type_code),
192: DECODE( p_new_system_type_code, fnd_api.g_miss_char, NULL, p_new_system_type_code),
193: DECODE( p_old_system_number, fnd_api.g_miss_char, NULL, p_old_system_number),
194: DECODE( p_new_system_number, fnd_api.g_miss_char, NULL, p_new_system_number),
195: DECODE( p_old_parent_system_id, fnd_api.g_miss_num, NULL, p_old_parent_system_id),

Line 192: DECODE( p_new_system_type_code, fnd_api.g_miss_char, NULL, p_new_system_type_code),

188: DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
189: DECODE( p_old_customer_id, fnd_api.g_miss_num, NULL, p_old_customer_id),
190: DECODE( p_new_customer_id, fnd_api.g_miss_num, NULL, p_new_customer_id),
191: DECODE( p_old_system_type_code, fnd_api.g_miss_char, NULL, p_old_system_type_code),
192: DECODE( p_new_system_type_code, fnd_api.g_miss_char, NULL, p_new_system_type_code),
193: DECODE( p_old_system_number, fnd_api.g_miss_char, NULL, p_old_system_number),
194: DECODE( p_new_system_number, fnd_api.g_miss_char, NULL, p_new_system_number),
195: DECODE( p_old_parent_system_id, fnd_api.g_miss_num, NULL, p_old_parent_system_id),
196: DECODE( p_new_parent_system_id, fnd_api.g_miss_num, NULL, p_new_parent_system_id),

Line 193: DECODE( p_old_system_number, fnd_api.g_miss_char, NULL, p_old_system_number),

189: DECODE( p_old_customer_id, fnd_api.g_miss_num, NULL, p_old_customer_id),
190: DECODE( p_new_customer_id, fnd_api.g_miss_num, NULL, p_new_customer_id),
191: DECODE( p_old_system_type_code, fnd_api.g_miss_char, NULL, p_old_system_type_code),
192: DECODE( p_new_system_type_code, fnd_api.g_miss_char, NULL, p_new_system_type_code),
193: DECODE( p_old_system_number, fnd_api.g_miss_char, NULL, p_old_system_number),
194: DECODE( p_new_system_number, fnd_api.g_miss_char, NULL, p_new_system_number),
195: DECODE( p_old_parent_system_id, fnd_api.g_miss_num, NULL, p_old_parent_system_id),
196: DECODE( p_new_parent_system_id, fnd_api.g_miss_num, NULL, p_new_parent_system_id),
197: DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_old_ship_to_contact_id),

Line 194: DECODE( p_new_system_number, fnd_api.g_miss_char, NULL, p_new_system_number),

190: DECODE( p_new_customer_id, fnd_api.g_miss_num, NULL, p_new_customer_id),
191: DECODE( p_old_system_type_code, fnd_api.g_miss_char, NULL, p_old_system_type_code),
192: DECODE( p_new_system_type_code, fnd_api.g_miss_char, NULL, p_new_system_type_code),
193: DECODE( p_old_system_number, fnd_api.g_miss_char, NULL, p_old_system_number),
194: DECODE( p_new_system_number, fnd_api.g_miss_char, NULL, p_new_system_number),
195: DECODE( p_old_parent_system_id, fnd_api.g_miss_num, NULL, p_old_parent_system_id),
196: DECODE( p_new_parent_system_id, fnd_api.g_miss_num, NULL, p_new_parent_system_id),
197: DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_old_ship_to_contact_id),
198: DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_new_ship_to_contact_id),

Line 195: DECODE( p_old_parent_system_id, fnd_api.g_miss_num, NULL, p_old_parent_system_id),

191: DECODE( p_old_system_type_code, fnd_api.g_miss_char, NULL, p_old_system_type_code),
192: DECODE( p_new_system_type_code, fnd_api.g_miss_char, NULL, p_new_system_type_code),
193: DECODE( p_old_system_number, fnd_api.g_miss_char, NULL, p_old_system_number),
194: DECODE( p_new_system_number, fnd_api.g_miss_char, NULL, p_new_system_number),
195: DECODE( p_old_parent_system_id, fnd_api.g_miss_num, NULL, p_old_parent_system_id),
196: DECODE( p_new_parent_system_id, fnd_api.g_miss_num, NULL, p_new_parent_system_id),
197: DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_old_ship_to_contact_id),
198: DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_new_ship_to_contact_id),
199: DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_old_bill_to_contact_id),

Line 196: DECODE( p_new_parent_system_id, fnd_api.g_miss_num, NULL, p_new_parent_system_id),

192: DECODE( p_new_system_type_code, fnd_api.g_miss_char, NULL, p_new_system_type_code),
193: DECODE( p_old_system_number, fnd_api.g_miss_char, NULL, p_old_system_number),
194: DECODE( p_new_system_number, fnd_api.g_miss_char, NULL, p_new_system_number),
195: DECODE( p_old_parent_system_id, fnd_api.g_miss_num, NULL, p_old_parent_system_id),
196: DECODE( p_new_parent_system_id, fnd_api.g_miss_num, NULL, p_new_parent_system_id),
197: DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_old_ship_to_contact_id),
198: DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_new_ship_to_contact_id),
199: DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_old_bill_to_contact_id),
200: DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_new_bill_to_contact_id),

Line 197: DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_old_ship_to_contact_id),

193: DECODE( p_old_system_number, fnd_api.g_miss_char, NULL, p_old_system_number),
194: DECODE( p_new_system_number, fnd_api.g_miss_char, NULL, p_new_system_number),
195: DECODE( p_old_parent_system_id, fnd_api.g_miss_num, NULL, p_old_parent_system_id),
196: DECODE( p_new_parent_system_id, fnd_api.g_miss_num, NULL, p_new_parent_system_id),
197: DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_old_ship_to_contact_id),
198: DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_new_ship_to_contact_id),
199: DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_old_bill_to_contact_id),
200: DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_new_bill_to_contact_id),
201: DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, NULL, p_old_technical_contact_id),

Line 198: DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_new_ship_to_contact_id),

194: DECODE( p_new_system_number, fnd_api.g_miss_char, NULL, p_new_system_number),
195: DECODE( p_old_parent_system_id, fnd_api.g_miss_num, NULL, p_old_parent_system_id),
196: DECODE( p_new_parent_system_id, fnd_api.g_miss_num, NULL, p_new_parent_system_id),
197: DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_old_ship_to_contact_id),
198: DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_new_ship_to_contact_id),
199: DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_old_bill_to_contact_id),
200: DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_new_bill_to_contact_id),
201: DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, NULL, p_old_technical_contact_id),
202: DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, NULL, p_new_technical_contact_id),

Line 199: DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_old_bill_to_contact_id),

195: DECODE( p_old_parent_system_id, fnd_api.g_miss_num, NULL, p_old_parent_system_id),
196: DECODE( p_new_parent_system_id, fnd_api.g_miss_num, NULL, p_new_parent_system_id),
197: DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_old_ship_to_contact_id),
198: DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_new_ship_to_contact_id),
199: DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_old_bill_to_contact_id),
200: DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_new_bill_to_contact_id),
201: DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, NULL, p_old_technical_contact_id),
202: DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, NULL, p_new_technical_contact_id),
203: DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_old_service_admin_contact_id),

Line 200: DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_new_bill_to_contact_id),

196: DECODE( p_new_parent_system_id, fnd_api.g_miss_num, NULL, p_new_parent_system_id),
197: DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_old_ship_to_contact_id),
198: DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_new_ship_to_contact_id),
199: DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_old_bill_to_contact_id),
200: DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_new_bill_to_contact_id),
201: DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, NULL, p_old_technical_contact_id),
202: DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, NULL, p_new_technical_contact_id),
203: DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_old_service_admin_contact_id),
204: DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_new_service_admin_contact_id),

Line 201: DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, NULL, p_old_technical_contact_id),

197: DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_old_ship_to_contact_id),
198: DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_new_ship_to_contact_id),
199: DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_old_bill_to_contact_id),
200: DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_new_bill_to_contact_id),
201: DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, NULL, p_old_technical_contact_id),
202: DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, NULL, p_new_technical_contact_id),
203: DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_old_service_admin_contact_id),
204: DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_new_service_admin_contact_id),
205: DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_ship_to_site_use_id),

Line 202: DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, NULL, p_new_technical_contact_id),

198: DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_new_ship_to_contact_id),
199: DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_old_bill_to_contact_id),
200: DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_new_bill_to_contact_id),
201: DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, NULL, p_old_technical_contact_id),
202: DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, NULL, p_new_technical_contact_id),
203: DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_old_service_admin_contact_id),
204: DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_new_service_admin_contact_id),
205: DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_ship_to_site_use_id),
206: DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_ship_to_site_use_id),

Line 203: DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_old_service_admin_contact_id),

199: DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_old_bill_to_contact_id),
200: DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_new_bill_to_contact_id),
201: DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, NULL, p_old_technical_contact_id),
202: DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, NULL, p_new_technical_contact_id),
203: DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_old_service_admin_contact_id),
204: DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_new_service_admin_contact_id),
205: DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_ship_to_site_use_id),
206: DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_ship_to_site_use_id),
207: DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, NULL, p_old_install_site_use_id),

Line 204: DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_new_service_admin_contact_id),

200: DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_new_bill_to_contact_id),
201: DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, NULL, p_old_technical_contact_id),
202: DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, NULL, p_new_technical_contact_id),
203: DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_old_service_admin_contact_id),
204: DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_new_service_admin_contact_id),
205: DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_ship_to_site_use_id),
206: DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_ship_to_site_use_id),
207: DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, NULL, p_old_install_site_use_id),
208: DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, NULL, p_new_install_site_use_id),

Line 205: DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_ship_to_site_use_id),

201: DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, NULL, p_old_technical_contact_id),
202: DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, NULL, p_new_technical_contact_id),
203: DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_old_service_admin_contact_id),
204: DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_new_service_admin_contact_id),
205: DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_ship_to_site_use_id),
206: DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_ship_to_site_use_id),
207: DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, NULL, p_old_install_site_use_id),
208: DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, NULL, p_new_install_site_use_id),
209: DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_bill_to_site_use_id),

Line 206: DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_ship_to_site_use_id),

202: DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, NULL, p_new_technical_contact_id),
203: DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_old_service_admin_contact_id),
204: DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_new_service_admin_contact_id),
205: DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_ship_to_site_use_id),
206: DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_ship_to_site_use_id),
207: DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, NULL, p_old_install_site_use_id),
208: DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, NULL, p_new_install_site_use_id),
209: DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_bill_to_site_use_id),
210: DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_bill_to_site_use_id),

Line 207: DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, NULL, p_old_install_site_use_id),

203: DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_old_service_admin_contact_id),
204: DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_new_service_admin_contact_id),
205: DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_ship_to_site_use_id),
206: DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_ship_to_site_use_id),
207: DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, NULL, p_old_install_site_use_id),
208: DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, NULL, p_new_install_site_use_id),
209: DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_bill_to_site_use_id),
210: DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_bill_to_site_use_id),
211: DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, NULL, p_old_coterminate_day_month),

Line 208: DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, NULL, p_new_install_site_use_id),

204: DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_new_service_admin_contact_id),
205: DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_ship_to_site_use_id),
206: DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_ship_to_site_use_id),
207: DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, NULL, p_old_install_site_use_id),
208: DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, NULL, p_new_install_site_use_id),
209: DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_bill_to_site_use_id),
210: DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_bill_to_site_use_id),
211: DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, NULL, p_old_coterminate_day_month),
212: DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, NULL, p_new_coterminate_day_month),

Line 209: DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_bill_to_site_use_id),

205: DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_ship_to_site_use_id),
206: DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_ship_to_site_use_id),
207: DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, NULL, p_old_install_site_use_id),
208: DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, NULL, p_new_install_site_use_id),
209: DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_bill_to_site_use_id),
210: DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_bill_to_site_use_id),
211: DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, NULL, p_old_coterminate_day_month),
212: DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, NULL, p_new_coterminate_day_month),
213: DECODE( p_old_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_start_date_active),

Line 210: DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_bill_to_site_use_id),

206: DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_ship_to_site_use_id),
207: DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, NULL, p_old_install_site_use_id),
208: DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, NULL, p_new_install_site_use_id),
209: DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_bill_to_site_use_id),
210: DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_bill_to_site_use_id),
211: DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, NULL, p_old_coterminate_day_month),
212: DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, NULL, p_new_coterminate_day_month),
213: DECODE( p_old_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_start_date_active),
214: DECODE( p_new_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_start_date_active),

Line 211: DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, NULL, p_old_coterminate_day_month),

207: DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, NULL, p_old_install_site_use_id),
208: DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, NULL, p_new_install_site_use_id),
209: DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_bill_to_site_use_id),
210: DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_bill_to_site_use_id),
211: DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, NULL, p_old_coterminate_day_month),
212: DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, NULL, p_new_coterminate_day_month),
213: DECODE( p_old_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_start_date_active),
214: DECODE( p_new_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_start_date_active),
215: DECODE( p_old_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_end_date_active),

Line 212: DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, NULL, p_new_coterminate_day_month),

208: DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, NULL, p_new_install_site_use_id),
209: DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_bill_to_site_use_id),
210: DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_bill_to_site_use_id),
211: DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, NULL, p_old_coterminate_day_month),
212: DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, NULL, p_new_coterminate_day_month),
213: DECODE( p_old_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_start_date_active),
214: DECODE( p_new_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_start_date_active),
215: DECODE( p_old_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_end_date_active),
216: DECODE( p_new_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_end_date_active),

Line 213: DECODE( p_old_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_start_date_active),

209: DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_bill_to_site_use_id),
210: DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_bill_to_site_use_id),
211: DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, NULL, p_old_coterminate_day_month),
212: DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, NULL, p_new_coterminate_day_month),
213: DECODE( p_old_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_start_date_active),
214: DECODE( p_new_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_start_date_active),
215: DECODE( p_old_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_end_date_active),
216: DECODE( p_new_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_end_date_active),
217: DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, NULL, p_old_autocreated_from_system),

Line 214: DECODE( p_new_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_start_date_active),

210: DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_bill_to_site_use_id),
211: DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, NULL, p_old_coterminate_day_month),
212: DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, NULL, p_new_coterminate_day_month),
213: DECODE( p_old_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_start_date_active),
214: DECODE( p_new_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_start_date_active),
215: DECODE( p_old_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_end_date_active),
216: DECODE( p_new_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_end_date_active),
217: DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, NULL, p_old_autocreated_from_system),
218: DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, NULL, p_new_autocreated_from_system),

Line 215: DECODE( p_old_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_end_date_active),

211: DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, NULL, p_old_coterminate_day_month),
212: DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, NULL, p_new_coterminate_day_month),
213: DECODE( p_old_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_start_date_active),
214: DECODE( p_new_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_start_date_active),
215: DECODE( p_old_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_end_date_active),
216: DECODE( p_new_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_end_date_active),
217: DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, NULL, p_old_autocreated_from_system),
218: DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, NULL, p_new_autocreated_from_system),
219: DECODE( p_old_config_system_type, fnd_api.g_miss_char, NULL, p_old_config_system_type),

Line 216: DECODE( p_new_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_end_date_active),

212: DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, NULL, p_new_coterminate_day_month),
213: DECODE( p_old_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_start_date_active),
214: DECODE( p_new_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_start_date_active),
215: DECODE( p_old_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_end_date_active),
216: DECODE( p_new_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_end_date_active),
217: DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, NULL, p_old_autocreated_from_system),
218: DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, NULL, p_new_autocreated_from_system),
219: DECODE( p_old_config_system_type, fnd_api.g_miss_char, NULL, p_old_config_system_type),
220: DECODE( p_new_config_system_type, fnd_api.g_miss_char, NULL, p_new_config_system_type),

Line 217: DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, NULL, p_old_autocreated_from_system),

213: DECODE( p_old_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_start_date_active),
214: DECODE( p_new_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_start_date_active),
215: DECODE( p_old_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_end_date_active),
216: DECODE( p_new_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_end_date_active),
217: DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, NULL, p_old_autocreated_from_system),
218: DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, NULL, p_new_autocreated_from_system),
219: DECODE( p_old_config_system_type, fnd_api.g_miss_char, NULL, p_old_config_system_type),
220: DECODE( p_new_config_system_type, fnd_api.g_miss_char, NULL, p_new_config_system_type),
221: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),

Line 218: DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, NULL, p_new_autocreated_from_system),

214: DECODE( p_new_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_start_date_active),
215: DECODE( p_old_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_end_date_active),
216: DECODE( p_new_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_end_date_active),
217: DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, NULL, p_old_autocreated_from_system),
218: DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, NULL, p_new_autocreated_from_system),
219: DECODE( p_old_config_system_type, fnd_api.g_miss_char, NULL, p_old_config_system_type),
220: DECODE( p_new_config_system_type, fnd_api.g_miss_char, NULL, p_new_config_system_type),
221: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
222: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),

Line 219: DECODE( p_old_config_system_type, fnd_api.g_miss_char, NULL, p_old_config_system_type),

215: DECODE( p_old_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_end_date_active),
216: DECODE( p_new_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_end_date_active),
217: DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, NULL, p_old_autocreated_from_system),
218: DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, NULL, p_new_autocreated_from_system),
219: DECODE( p_old_config_system_type, fnd_api.g_miss_char, NULL, p_old_config_system_type),
220: DECODE( p_new_config_system_type, fnd_api.g_miss_char, NULL, p_new_config_system_type),
221: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
222: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
223: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),

Line 220: DECODE( p_new_config_system_type, fnd_api.g_miss_char, NULL, p_new_config_system_type),

216: DECODE( p_new_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_end_date_active),
217: DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, NULL, p_old_autocreated_from_system),
218: DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, NULL, p_new_autocreated_from_system),
219: DECODE( p_old_config_system_type, fnd_api.g_miss_char, NULL, p_old_config_system_type),
220: DECODE( p_new_config_system_type, fnd_api.g_miss_char, NULL, p_new_config_system_type),
221: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
222: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
223: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
224: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),

Line 221: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),

217: DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, NULL, p_old_autocreated_from_system),
218: DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, NULL, p_new_autocreated_from_system),
219: DECODE( p_old_config_system_type, fnd_api.g_miss_char, NULL, p_old_config_system_type),
220: DECODE( p_new_config_system_type, fnd_api.g_miss_char, NULL, p_new_config_system_type),
221: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
222: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
223: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
224: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
225: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),

Line 222: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),

218: DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, NULL, p_new_autocreated_from_system),
219: DECODE( p_old_config_system_type, fnd_api.g_miss_char, NULL, p_old_config_system_type),
220: DECODE( p_new_config_system_type, fnd_api.g_miss_char, NULL, p_new_config_system_type),
221: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
222: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
223: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
224: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
225: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
226: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),

Line 223: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),

219: DECODE( p_old_config_system_type, fnd_api.g_miss_char, NULL, p_old_config_system_type),
220: DECODE( p_new_config_system_type, fnd_api.g_miss_char, NULL, p_new_config_system_type),
221: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
222: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
223: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
224: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
225: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
226: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
227: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),

Line 224: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),

220: DECODE( p_new_config_system_type, fnd_api.g_miss_char, NULL, p_new_config_system_type),
221: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
222: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
223: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
224: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
225: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
226: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
227: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
228: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),

Line 225: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),

221: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
222: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
223: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
224: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
225: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
226: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
227: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
228: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
229: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),

Line 226: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),

222: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
223: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
224: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
225: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
226: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
227: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
228: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
229: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
230: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),

Line 227: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),

223: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
224: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
225: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
226: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
227: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
228: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
229: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
230: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
231: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),

Line 228: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),

224: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
225: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
226: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
227: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
228: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
229: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
230: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
231: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
232: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),

Line 229: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),

225: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
226: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
227: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
228: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
229: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
230: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
231: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
232: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
233: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),

Line 230: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),

226: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
227: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
228: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
229: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
230: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
231: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
232: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
233: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
234: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),

Line 231: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),

227: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
228: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
229: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
230: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
231: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
232: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
233: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
234: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
235: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),

Line 232: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),

228: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
229: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
230: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
231: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
232: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
233: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
234: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
235: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
236: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),

Line 233: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),

229: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
230: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
231: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
232: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
233: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
234: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
235: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
236: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
237: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),

Line 234: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),

230: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
231: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
232: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
233: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
234: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
235: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
236: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
237: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
238: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),

Line 235: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),

231: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
232: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
233: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
234: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
235: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
236: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
237: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
238: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
239: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),

Line 236: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),

232: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
233: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
234: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
235: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
236: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
237: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
238: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
239: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
240: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),

Line 237: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),

233: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
234: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
235: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
236: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
237: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
238: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
239: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
240: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
241: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),

Line 238: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),

234: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
235: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
236: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
237: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
238: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
239: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
240: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
241: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
242: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),

Line 239: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),

235: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
236: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
237: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
238: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
239: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
240: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
241: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
242: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
243: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),

Line 240: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),

236: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
237: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
238: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
239: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
240: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
241: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
242: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
243: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
244: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),

Line 241: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),

237: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
238: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
239: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
240: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
241: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
242: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
243: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
244: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
245: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),

Line 242: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),

238: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
239: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
240: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
241: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
242: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
243: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
244: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
245: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
246: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),

Line 243: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),

239: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
240: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
241: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
242: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
243: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
244: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
245: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
246: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
247: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),

Line 244: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),

240: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
241: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
242: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
243: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
244: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
245: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
246: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
247: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
248: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),

Line 245: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),

241: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
242: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
243: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
244: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
245: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
246: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
247: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
248: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
249: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),

Line 246: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),

242: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
243: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
244: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
245: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
246: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
247: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
248: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
249: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
250: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),

Line 247: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),

243: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
244: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
245: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
246: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
247: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
248: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
249: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
250: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
251: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),

Line 248: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),

244: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
245: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
246: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
247: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
248: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
249: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
250: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
251: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
252: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),

Line 249: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),

245: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
246: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
247: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
248: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
249: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
250: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
251: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
252: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
253: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),

Line 250: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),

246: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
247: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
248: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
249: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
250: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
251: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
252: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
253: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
254: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),

Line 251: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),

247: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
248: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
249: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
250: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
251: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
252: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
253: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
254: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
255: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

Line 252: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),

248: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
249: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
250: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
251: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
252: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
253: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
254: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
255: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
256: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

Line 253: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),

249: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
250: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
251: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
252: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
253: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
254: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
255: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
256: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
257: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

Line 254: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),

250: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
251: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
252: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
253: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
254: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
255: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
256: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
257: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
258: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),

Line 255: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

251: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
252: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
253: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
254: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
255: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
256: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
257: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
258: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
259: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),

Line 256: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

252: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
253: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
254: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
255: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
256: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
257: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
258: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
259: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
260: DECODE( p_old_name, fnd_api.g_miss_char, NULL, p_old_name),

Line 257: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

253: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
254: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
255: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
256: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
257: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
258: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
259: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
260: DECODE( p_old_name, fnd_api.g_miss_char, NULL, p_old_name),
261: DECODE( p_new_name, fnd_api.g_miss_char, NULL, p_new_name),

Line 258: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),

254: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
255: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
256: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
257: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
258: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
259: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
260: DECODE( p_old_name, fnd_api.g_miss_char, NULL, p_old_name),
261: DECODE( p_new_name, fnd_api.g_miss_char, NULL, p_new_name),
262: DECODE( p_old_description, fnd_api.g_miss_char, NULL, p_old_description),

Line 259: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),

255: DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
256: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
257: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
258: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
259: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
260: DECODE( p_old_name, fnd_api.g_miss_char, NULL, p_old_name),
261: DECODE( p_new_name, fnd_api.g_miss_char, NULL, p_new_name),
262: DECODE( p_old_description, fnd_api.g_miss_char, NULL, p_old_description),
263: DECODE( p_new_description, fnd_api.g_miss_char, NULL, p_new_description),

Line 260: DECODE( p_old_name, fnd_api.g_miss_char, NULL, p_old_name),

256: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
257: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
258: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
259: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
260: DECODE( p_old_name, fnd_api.g_miss_char, NULL, p_old_name),
261: DECODE( p_new_name, fnd_api.g_miss_char, NULL, p_new_name),
262: DECODE( p_old_description, fnd_api.g_miss_char, NULL, p_old_description),
263: DECODE( p_new_description, fnd_api.g_miss_char, NULL, p_new_description),
264: DECODE( p_old_operating_unit_id, fnd_api.g_miss_num, NULL, p_old_operating_unit_id),

Line 261: DECODE( p_new_name, fnd_api.g_miss_char, NULL, p_new_name),

257: DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
258: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
259: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
260: DECODE( p_old_name, fnd_api.g_miss_char, NULL, p_old_name),
261: DECODE( p_new_name, fnd_api.g_miss_char, NULL, p_new_name),
262: DECODE( p_old_description, fnd_api.g_miss_char, NULL, p_old_description),
263: DECODE( p_new_description, fnd_api.g_miss_char, NULL, p_new_description),
264: DECODE( p_old_operating_unit_id, fnd_api.g_miss_num, NULL, p_old_operating_unit_id),
265: DECODE( p_new_operating_unit_id, fnd_api.g_miss_num, NULL, p_new_operating_unit_id)

Line 262: DECODE( p_old_description, fnd_api.g_miss_char, NULL, p_old_description),

258: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
259: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
260: DECODE( p_old_name, fnd_api.g_miss_char, NULL, p_old_name),
261: DECODE( p_new_name, fnd_api.g_miss_char, NULL, p_new_name),
262: DECODE( p_old_description, fnd_api.g_miss_char, NULL, p_old_description),
263: DECODE( p_new_description, fnd_api.g_miss_char, NULL, p_new_description),
264: DECODE( p_old_operating_unit_id, fnd_api.g_miss_num, NULL, p_old_operating_unit_id),
265: DECODE( p_new_operating_unit_id, fnd_api.g_miss_num, NULL, p_new_operating_unit_id)
266: );

Line 263: DECODE( p_new_description, fnd_api.g_miss_char, NULL, p_new_description),

259: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
260: DECODE( p_old_name, fnd_api.g_miss_char, NULL, p_old_name),
261: DECODE( p_new_name, fnd_api.g_miss_char, NULL, p_new_name),
262: DECODE( p_old_description, fnd_api.g_miss_char, NULL, p_old_description),
263: DECODE( p_new_description, fnd_api.g_miss_char, NULL, p_new_description),
264: DECODE( p_old_operating_unit_id, fnd_api.g_miss_num, NULL, p_old_operating_unit_id),
265: DECODE( p_new_operating_unit_id, fnd_api.g_miss_num, NULL, p_new_operating_unit_id)
266: );
267: END insert_row;

Line 264: DECODE( p_old_operating_unit_id, fnd_api.g_miss_num, NULL, p_old_operating_unit_id),

260: DECODE( p_old_name, fnd_api.g_miss_char, NULL, p_old_name),
261: DECODE( p_new_name, fnd_api.g_miss_char, NULL, p_new_name),
262: DECODE( p_old_description, fnd_api.g_miss_char, NULL, p_old_description),
263: DECODE( p_new_description, fnd_api.g_miss_char, NULL, p_new_description),
264: DECODE( p_old_operating_unit_id, fnd_api.g_miss_num, NULL, p_old_operating_unit_id),
265: DECODE( p_new_operating_unit_id, fnd_api.g_miss_num, NULL, p_new_operating_unit_id)
266: );
267: END insert_row;
268:

Line 265: DECODE( p_new_operating_unit_id, fnd_api.g_miss_num, NULL, p_new_operating_unit_id)

261: DECODE( p_new_name, fnd_api.g_miss_char, NULL, p_new_name),
262: DECODE( p_old_description, fnd_api.g_miss_char, NULL, p_old_description),
263: DECODE( p_new_description, fnd_api.g_miss_char, NULL, p_new_description),
264: DECODE( p_old_operating_unit_id, fnd_api.g_miss_num, NULL, p_old_operating_unit_id),
265: DECODE( p_new_operating_unit_id, fnd_api.g_miss_num, NULL, p_new_operating_unit_id)
266: );
267: END insert_row;
268:
269: PROCEDURE Update_Row(

Line 354: system_id = DECODE( p_system_id, fnd_api.g_miss_num, system_id, p_system_id),

350: IS
351: BEGIN
352: Update csi_systems_h
353: SET
354: system_id = DECODE( p_system_id, fnd_api.g_miss_num, system_id, p_system_id),
355: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
356: old_customer_id = DECODE( p_old_customer_id, fnd_api.g_miss_num, old_customer_id, p_old_customer_id),
357: new_customer_id = DECODE( p_new_customer_id, fnd_api.g_miss_num, new_customer_id, p_new_customer_id),
358: old_system_type_code = DECODE( p_old_system_type_code, fnd_api.g_miss_char, old_system_type_code, p_old_system_type_code),

Line 355: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),

351: BEGIN
352: Update csi_systems_h
353: SET
354: system_id = DECODE( p_system_id, fnd_api.g_miss_num, system_id, p_system_id),
355: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
356: old_customer_id = DECODE( p_old_customer_id, fnd_api.g_miss_num, old_customer_id, p_old_customer_id),
357: new_customer_id = DECODE( p_new_customer_id, fnd_api.g_miss_num, new_customer_id, p_new_customer_id),
358: old_system_type_code = DECODE( p_old_system_type_code, fnd_api.g_miss_char, old_system_type_code, p_old_system_type_code),
359: new_system_type_code = DECODE( p_new_system_type_code, fnd_api.g_miss_char, new_system_type_code, p_new_system_type_code),

Line 356: old_customer_id = DECODE( p_old_customer_id, fnd_api.g_miss_num, old_customer_id, p_old_customer_id),

352: Update csi_systems_h
353: SET
354: system_id = DECODE( p_system_id, fnd_api.g_miss_num, system_id, p_system_id),
355: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
356: old_customer_id = DECODE( p_old_customer_id, fnd_api.g_miss_num, old_customer_id, p_old_customer_id),
357: new_customer_id = DECODE( p_new_customer_id, fnd_api.g_miss_num, new_customer_id, p_new_customer_id),
358: old_system_type_code = DECODE( p_old_system_type_code, fnd_api.g_miss_char, old_system_type_code, p_old_system_type_code),
359: new_system_type_code = DECODE( p_new_system_type_code, fnd_api.g_miss_char, new_system_type_code, p_new_system_type_code),
360: old_system_number = DECODE( p_old_system_number, fnd_api.g_miss_char, old_system_number, p_old_system_number),

Line 357: new_customer_id = DECODE( p_new_customer_id, fnd_api.g_miss_num, new_customer_id, p_new_customer_id),

353: SET
354: system_id = DECODE( p_system_id, fnd_api.g_miss_num, system_id, p_system_id),
355: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
356: old_customer_id = DECODE( p_old_customer_id, fnd_api.g_miss_num, old_customer_id, p_old_customer_id),
357: new_customer_id = DECODE( p_new_customer_id, fnd_api.g_miss_num, new_customer_id, p_new_customer_id),
358: old_system_type_code = DECODE( p_old_system_type_code, fnd_api.g_miss_char, old_system_type_code, p_old_system_type_code),
359: new_system_type_code = DECODE( p_new_system_type_code, fnd_api.g_miss_char, new_system_type_code, p_new_system_type_code),
360: old_system_number = DECODE( p_old_system_number, fnd_api.g_miss_char, old_system_number, p_old_system_number),
361: new_system_number = DECODE( p_new_system_number, fnd_api.g_miss_char, new_system_number, p_new_system_number),

Line 358: old_system_type_code = DECODE( p_old_system_type_code, fnd_api.g_miss_char, old_system_type_code, p_old_system_type_code),

354: system_id = DECODE( p_system_id, fnd_api.g_miss_num, system_id, p_system_id),
355: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
356: old_customer_id = DECODE( p_old_customer_id, fnd_api.g_miss_num, old_customer_id, p_old_customer_id),
357: new_customer_id = DECODE( p_new_customer_id, fnd_api.g_miss_num, new_customer_id, p_new_customer_id),
358: old_system_type_code = DECODE( p_old_system_type_code, fnd_api.g_miss_char, old_system_type_code, p_old_system_type_code),
359: new_system_type_code = DECODE( p_new_system_type_code, fnd_api.g_miss_char, new_system_type_code, p_new_system_type_code),
360: old_system_number = DECODE( p_old_system_number, fnd_api.g_miss_char, old_system_number, p_old_system_number),
361: new_system_number = DECODE( p_new_system_number, fnd_api.g_miss_char, new_system_number, p_new_system_number),
362: old_parent_system_id = DECODE( p_old_parent_system_id, fnd_api.g_miss_num, old_parent_system_id, p_old_parent_system_id),

Line 359: new_system_type_code = DECODE( p_new_system_type_code, fnd_api.g_miss_char, new_system_type_code, p_new_system_type_code),

355: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
356: old_customer_id = DECODE( p_old_customer_id, fnd_api.g_miss_num, old_customer_id, p_old_customer_id),
357: new_customer_id = DECODE( p_new_customer_id, fnd_api.g_miss_num, new_customer_id, p_new_customer_id),
358: old_system_type_code = DECODE( p_old_system_type_code, fnd_api.g_miss_char, old_system_type_code, p_old_system_type_code),
359: new_system_type_code = DECODE( p_new_system_type_code, fnd_api.g_miss_char, new_system_type_code, p_new_system_type_code),
360: old_system_number = DECODE( p_old_system_number, fnd_api.g_miss_char, old_system_number, p_old_system_number),
361: new_system_number = DECODE( p_new_system_number, fnd_api.g_miss_char, new_system_number, p_new_system_number),
362: old_parent_system_id = DECODE( p_old_parent_system_id, fnd_api.g_miss_num, old_parent_system_id, p_old_parent_system_id),
363: new_parent_system_id = DECODE( p_new_parent_system_id, fnd_api.g_miss_num, new_parent_system_id, p_new_parent_system_id),

Line 360: old_system_number = DECODE( p_old_system_number, fnd_api.g_miss_char, old_system_number, p_old_system_number),

356: old_customer_id = DECODE( p_old_customer_id, fnd_api.g_miss_num, old_customer_id, p_old_customer_id),
357: new_customer_id = DECODE( p_new_customer_id, fnd_api.g_miss_num, new_customer_id, p_new_customer_id),
358: old_system_type_code = DECODE( p_old_system_type_code, fnd_api.g_miss_char, old_system_type_code, p_old_system_type_code),
359: new_system_type_code = DECODE( p_new_system_type_code, fnd_api.g_miss_char, new_system_type_code, p_new_system_type_code),
360: old_system_number = DECODE( p_old_system_number, fnd_api.g_miss_char, old_system_number, p_old_system_number),
361: new_system_number = DECODE( p_new_system_number, fnd_api.g_miss_char, new_system_number, p_new_system_number),
362: old_parent_system_id = DECODE( p_old_parent_system_id, fnd_api.g_miss_num, old_parent_system_id, p_old_parent_system_id),
363: new_parent_system_id = DECODE( p_new_parent_system_id, fnd_api.g_miss_num, new_parent_system_id, p_new_parent_system_id),
364: old_ship_to_contact_id = DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, old_ship_to_contact_id, p_old_ship_to_contact_id),

Line 361: new_system_number = DECODE( p_new_system_number, fnd_api.g_miss_char, new_system_number, p_new_system_number),

357: new_customer_id = DECODE( p_new_customer_id, fnd_api.g_miss_num, new_customer_id, p_new_customer_id),
358: old_system_type_code = DECODE( p_old_system_type_code, fnd_api.g_miss_char, old_system_type_code, p_old_system_type_code),
359: new_system_type_code = DECODE( p_new_system_type_code, fnd_api.g_miss_char, new_system_type_code, p_new_system_type_code),
360: old_system_number = DECODE( p_old_system_number, fnd_api.g_miss_char, old_system_number, p_old_system_number),
361: new_system_number = DECODE( p_new_system_number, fnd_api.g_miss_char, new_system_number, p_new_system_number),
362: old_parent_system_id = DECODE( p_old_parent_system_id, fnd_api.g_miss_num, old_parent_system_id, p_old_parent_system_id),
363: new_parent_system_id = DECODE( p_new_parent_system_id, fnd_api.g_miss_num, new_parent_system_id, p_new_parent_system_id),
364: old_ship_to_contact_id = DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, old_ship_to_contact_id, p_old_ship_to_contact_id),
365: new_ship_to_contact_id = DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, new_ship_to_contact_id, p_new_ship_to_contact_id),

Line 362: old_parent_system_id = DECODE( p_old_parent_system_id, fnd_api.g_miss_num, old_parent_system_id, p_old_parent_system_id),

358: old_system_type_code = DECODE( p_old_system_type_code, fnd_api.g_miss_char, old_system_type_code, p_old_system_type_code),
359: new_system_type_code = DECODE( p_new_system_type_code, fnd_api.g_miss_char, new_system_type_code, p_new_system_type_code),
360: old_system_number = DECODE( p_old_system_number, fnd_api.g_miss_char, old_system_number, p_old_system_number),
361: new_system_number = DECODE( p_new_system_number, fnd_api.g_miss_char, new_system_number, p_new_system_number),
362: old_parent_system_id = DECODE( p_old_parent_system_id, fnd_api.g_miss_num, old_parent_system_id, p_old_parent_system_id),
363: new_parent_system_id = DECODE( p_new_parent_system_id, fnd_api.g_miss_num, new_parent_system_id, p_new_parent_system_id),
364: old_ship_to_contact_id = DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, old_ship_to_contact_id, p_old_ship_to_contact_id),
365: new_ship_to_contact_id = DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, new_ship_to_contact_id, p_new_ship_to_contact_id),
366: old_bill_to_contact_id = DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, old_bill_to_contact_id, p_old_bill_to_contact_id),

Line 363: new_parent_system_id = DECODE( p_new_parent_system_id, fnd_api.g_miss_num, new_parent_system_id, p_new_parent_system_id),

359: new_system_type_code = DECODE( p_new_system_type_code, fnd_api.g_miss_char, new_system_type_code, p_new_system_type_code),
360: old_system_number = DECODE( p_old_system_number, fnd_api.g_miss_char, old_system_number, p_old_system_number),
361: new_system_number = DECODE( p_new_system_number, fnd_api.g_miss_char, new_system_number, p_new_system_number),
362: old_parent_system_id = DECODE( p_old_parent_system_id, fnd_api.g_miss_num, old_parent_system_id, p_old_parent_system_id),
363: new_parent_system_id = DECODE( p_new_parent_system_id, fnd_api.g_miss_num, new_parent_system_id, p_new_parent_system_id),
364: old_ship_to_contact_id = DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, old_ship_to_contact_id, p_old_ship_to_contact_id),
365: new_ship_to_contact_id = DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, new_ship_to_contact_id, p_new_ship_to_contact_id),
366: old_bill_to_contact_id = DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, old_bill_to_contact_id, p_old_bill_to_contact_id),
367: new_bill_to_contact_id = DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, new_bill_to_contact_id, p_new_bill_to_contact_id),

Line 364: old_ship_to_contact_id = DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, old_ship_to_contact_id, p_old_ship_to_contact_id),

360: old_system_number = DECODE( p_old_system_number, fnd_api.g_miss_char, old_system_number, p_old_system_number),
361: new_system_number = DECODE( p_new_system_number, fnd_api.g_miss_char, new_system_number, p_new_system_number),
362: old_parent_system_id = DECODE( p_old_parent_system_id, fnd_api.g_miss_num, old_parent_system_id, p_old_parent_system_id),
363: new_parent_system_id = DECODE( p_new_parent_system_id, fnd_api.g_miss_num, new_parent_system_id, p_new_parent_system_id),
364: old_ship_to_contact_id = DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, old_ship_to_contact_id, p_old_ship_to_contact_id),
365: new_ship_to_contact_id = DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, new_ship_to_contact_id, p_new_ship_to_contact_id),
366: old_bill_to_contact_id = DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, old_bill_to_contact_id, p_old_bill_to_contact_id),
367: new_bill_to_contact_id = DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, new_bill_to_contact_id, p_new_bill_to_contact_id),
368: old_technical_contact_id = DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, old_technical_contact_id, p_old_technical_contact_id),

Line 365: new_ship_to_contact_id = DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, new_ship_to_contact_id, p_new_ship_to_contact_id),

361: new_system_number = DECODE( p_new_system_number, fnd_api.g_miss_char, new_system_number, p_new_system_number),
362: old_parent_system_id = DECODE( p_old_parent_system_id, fnd_api.g_miss_num, old_parent_system_id, p_old_parent_system_id),
363: new_parent_system_id = DECODE( p_new_parent_system_id, fnd_api.g_miss_num, new_parent_system_id, p_new_parent_system_id),
364: old_ship_to_contact_id = DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, old_ship_to_contact_id, p_old_ship_to_contact_id),
365: new_ship_to_contact_id = DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, new_ship_to_contact_id, p_new_ship_to_contact_id),
366: old_bill_to_contact_id = DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, old_bill_to_contact_id, p_old_bill_to_contact_id),
367: new_bill_to_contact_id = DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, new_bill_to_contact_id, p_new_bill_to_contact_id),
368: old_technical_contact_id = DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, old_technical_contact_id, p_old_technical_contact_id),
369: new_technical_contact_id = DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, new_technical_contact_id, p_new_technical_contact_id),

Line 366: old_bill_to_contact_id = DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, old_bill_to_contact_id, p_old_bill_to_contact_id),

362: old_parent_system_id = DECODE( p_old_parent_system_id, fnd_api.g_miss_num, old_parent_system_id, p_old_parent_system_id),
363: new_parent_system_id = DECODE( p_new_parent_system_id, fnd_api.g_miss_num, new_parent_system_id, p_new_parent_system_id),
364: old_ship_to_contact_id = DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, old_ship_to_contact_id, p_old_ship_to_contact_id),
365: new_ship_to_contact_id = DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, new_ship_to_contact_id, p_new_ship_to_contact_id),
366: old_bill_to_contact_id = DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, old_bill_to_contact_id, p_old_bill_to_contact_id),
367: new_bill_to_contact_id = DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, new_bill_to_contact_id, p_new_bill_to_contact_id),
368: old_technical_contact_id = DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, old_technical_contact_id, p_old_technical_contact_id),
369: new_technical_contact_id = DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, new_technical_contact_id, p_new_technical_contact_id),
370: old_service_admin_contact_id = DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, old_service_admin_contact_id, p_old_service_admin_contact_id),

Line 367: new_bill_to_contact_id = DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, new_bill_to_contact_id, p_new_bill_to_contact_id),

363: new_parent_system_id = DECODE( p_new_parent_system_id, fnd_api.g_miss_num, new_parent_system_id, p_new_parent_system_id),
364: old_ship_to_contact_id = DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, old_ship_to_contact_id, p_old_ship_to_contact_id),
365: new_ship_to_contact_id = DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, new_ship_to_contact_id, p_new_ship_to_contact_id),
366: old_bill_to_contact_id = DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, old_bill_to_contact_id, p_old_bill_to_contact_id),
367: new_bill_to_contact_id = DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, new_bill_to_contact_id, p_new_bill_to_contact_id),
368: old_technical_contact_id = DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, old_technical_contact_id, p_old_technical_contact_id),
369: new_technical_contact_id = DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, new_technical_contact_id, p_new_technical_contact_id),
370: old_service_admin_contact_id = DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, old_service_admin_contact_id, p_old_service_admin_contact_id),
371: new_service_admin_contact_id = DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, new_service_admin_contact_id, p_new_service_admin_contact_id),

Line 368: old_technical_contact_id = DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, old_technical_contact_id, p_old_technical_contact_id),

364: old_ship_to_contact_id = DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, old_ship_to_contact_id, p_old_ship_to_contact_id),
365: new_ship_to_contact_id = DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, new_ship_to_contact_id, p_new_ship_to_contact_id),
366: old_bill_to_contact_id = DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, old_bill_to_contact_id, p_old_bill_to_contact_id),
367: new_bill_to_contact_id = DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, new_bill_to_contact_id, p_new_bill_to_contact_id),
368: old_technical_contact_id = DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, old_technical_contact_id, p_old_technical_contact_id),
369: new_technical_contact_id = DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, new_technical_contact_id, p_new_technical_contact_id),
370: old_service_admin_contact_id = DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, old_service_admin_contact_id, p_old_service_admin_contact_id),
371: new_service_admin_contact_id = DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, new_service_admin_contact_id, p_new_service_admin_contact_id),
372: old_ship_to_site_use_id = DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, old_ship_to_site_use_id, p_old_ship_to_site_use_id),

Line 369: new_technical_contact_id = DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, new_technical_contact_id, p_new_technical_contact_id),

365: new_ship_to_contact_id = DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, new_ship_to_contact_id, p_new_ship_to_contact_id),
366: old_bill_to_contact_id = DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, old_bill_to_contact_id, p_old_bill_to_contact_id),
367: new_bill_to_contact_id = DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, new_bill_to_contact_id, p_new_bill_to_contact_id),
368: old_technical_contact_id = DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, old_technical_contact_id, p_old_technical_contact_id),
369: new_technical_contact_id = DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, new_technical_contact_id, p_new_technical_contact_id),
370: old_service_admin_contact_id = DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, old_service_admin_contact_id, p_old_service_admin_contact_id),
371: new_service_admin_contact_id = DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, new_service_admin_contact_id, p_new_service_admin_contact_id),
372: old_ship_to_site_use_id = DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, old_ship_to_site_use_id, p_old_ship_to_site_use_id),
373: new_ship_to_site_use_id = DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, new_ship_to_site_use_id, p_new_ship_to_site_use_id),

Line 370: old_service_admin_contact_id = DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, old_service_admin_contact_id, p_old_service_admin_contact_id),

366: old_bill_to_contact_id = DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, old_bill_to_contact_id, p_old_bill_to_contact_id),
367: new_bill_to_contact_id = DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, new_bill_to_contact_id, p_new_bill_to_contact_id),
368: old_technical_contact_id = DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, old_technical_contact_id, p_old_technical_contact_id),
369: new_technical_contact_id = DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, new_technical_contact_id, p_new_technical_contact_id),
370: old_service_admin_contact_id = DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, old_service_admin_contact_id, p_old_service_admin_contact_id),
371: new_service_admin_contact_id = DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, new_service_admin_contact_id, p_new_service_admin_contact_id),
372: old_ship_to_site_use_id = DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, old_ship_to_site_use_id, p_old_ship_to_site_use_id),
373: new_ship_to_site_use_id = DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, new_ship_to_site_use_id, p_new_ship_to_site_use_id),
374: old_install_site_use_id = DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, old_install_site_use_id, p_old_install_site_use_id),

Line 371: new_service_admin_contact_id = DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, new_service_admin_contact_id, p_new_service_admin_contact_id),

367: new_bill_to_contact_id = DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, new_bill_to_contact_id, p_new_bill_to_contact_id),
368: old_technical_contact_id = DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, old_technical_contact_id, p_old_technical_contact_id),
369: new_technical_contact_id = DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, new_technical_contact_id, p_new_technical_contact_id),
370: old_service_admin_contact_id = DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, old_service_admin_contact_id, p_old_service_admin_contact_id),
371: new_service_admin_contact_id = DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, new_service_admin_contact_id, p_new_service_admin_contact_id),
372: old_ship_to_site_use_id = DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, old_ship_to_site_use_id, p_old_ship_to_site_use_id),
373: new_ship_to_site_use_id = DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, new_ship_to_site_use_id, p_new_ship_to_site_use_id),
374: old_install_site_use_id = DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, old_install_site_use_id, p_old_install_site_use_id),
375: new_install_site_use_id = DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, new_install_site_use_id, p_new_install_site_use_id),

Line 372: old_ship_to_site_use_id = DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, old_ship_to_site_use_id, p_old_ship_to_site_use_id),

368: old_technical_contact_id = DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, old_technical_contact_id, p_old_technical_contact_id),
369: new_technical_contact_id = DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, new_technical_contact_id, p_new_technical_contact_id),
370: old_service_admin_contact_id = DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, old_service_admin_contact_id, p_old_service_admin_contact_id),
371: new_service_admin_contact_id = DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, new_service_admin_contact_id, p_new_service_admin_contact_id),
372: old_ship_to_site_use_id = DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, old_ship_to_site_use_id, p_old_ship_to_site_use_id),
373: new_ship_to_site_use_id = DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, new_ship_to_site_use_id, p_new_ship_to_site_use_id),
374: old_install_site_use_id = DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, old_install_site_use_id, p_old_install_site_use_id),
375: new_install_site_use_id = DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, new_install_site_use_id, p_new_install_site_use_id),
376: old_bill_to_site_use_id = DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, old_bill_to_site_use_id, p_old_bill_to_site_use_id),

Line 373: new_ship_to_site_use_id = DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, new_ship_to_site_use_id, p_new_ship_to_site_use_id),

369: new_technical_contact_id = DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, new_technical_contact_id, p_new_technical_contact_id),
370: old_service_admin_contact_id = DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, old_service_admin_contact_id, p_old_service_admin_contact_id),
371: new_service_admin_contact_id = DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, new_service_admin_contact_id, p_new_service_admin_contact_id),
372: old_ship_to_site_use_id = DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, old_ship_to_site_use_id, p_old_ship_to_site_use_id),
373: new_ship_to_site_use_id = DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, new_ship_to_site_use_id, p_new_ship_to_site_use_id),
374: old_install_site_use_id = DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, old_install_site_use_id, p_old_install_site_use_id),
375: new_install_site_use_id = DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, new_install_site_use_id, p_new_install_site_use_id),
376: old_bill_to_site_use_id = DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, old_bill_to_site_use_id, p_old_bill_to_site_use_id),
377: new_bill_to_site_use_id = DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, new_bill_to_site_use_id, p_new_bill_to_site_use_id),

Line 374: old_install_site_use_id = DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, old_install_site_use_id, p_old_install_site_use_id),

370: old_service_admin_contact_id = DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, old_service_admin_contact_id, p_old_service_admin_contact_id),
371: new_service_admin_contact_id = DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, new_service_admin_contact_id, p_new_service_admin_contact_id),
372: old_ship_to_site_use_id = DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, old_ship_to_site_use_id, p_old_ship_to_site_use_id),
373: new_ship_to_site_use_id = DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, new_ship_to_site_use_id, p_new_ship_to_site_use_id),
374: old_install_site_use_id = DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, old_install_site_use_id, p_old_install_site_use_id),
375: new_install_site_use_id = DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, new_install_site_use_id, p_new_install_site_use_id),
376: old_bill_to_site_use_id = DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, old_bill_to_site_use_id, p_old_bill_to_site_use_id),
377: new_bill_to_site_use_id = DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, new_bill_to_site_use_id, p_new_bill_to_site_use_id),
378: old_coterminate_day_month = DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, old_coterminate_day_month, p_old_coterminate_day_month),

Line 375: new_install_site_use_id = DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, new_install_site_use_id, p_new_install_site_use_id),

371: new_service_admin_contact_id = DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, new_service_admin_contact_id, p_new_service_admin_contact_id),
372: old_ship_to_site_use_id = DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, old_ship_to_site_use_id, p_old_ship_to_site_use_id),
373: new_ship_to_site_use_id = DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, new_ship_to_site_use_id, p_new_ship_to_site_use_id),
374: old_install_site_use_id = DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, old_install_site_use_id, p_old_install_site_use_id),
375: new_install_site_use_id = DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, new_install_site_use_id, p_new_install_site_use_id),
376: old_bill_to_site_use_id = DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, old_bill_to_site_use_id, p_old_bill_to_site_use_id),
377: new_bill_to_site_use_id = DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, new_bill_to_site_use_id, p_new_bill_to_site_use_id),
378: old_coterminate_day_month = DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, old_coterminate_day_month, p_old_coterminate_day_month),
379: new_coterminate_day_month = DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, new_coterminate_day_month, p_new_coterminate_day_month),

Line 376: old_bill_to_site_use_id = DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, old_bill_to_site_use_id, p_old_bill_to_site_use_id),

372: old_ship_to_site_use_id = DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, old_ship_to_site_use_id, p_old_ship_to_site_use_id),
373: new_ship_to_site_use_id = DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, new_ship_to_site_use_id, p_new_ship_to_site_use_id),
374: old_install_site_use_id = DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, old_install_site_use_id, p_old_install_site_use_id),
375: new_install_site_use_id = DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, new_install_site_use_id, p_new_install_site_use_id),
376: old_bill_to_site_use_id = DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, old_bill_to_site_use_id, p_old_bill_to_site_use_id),
377: new_bill_to_site_use_id = DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, new_bill_to_site_use_id, p_new_bill_to_site_use_id),
378: old_coterminate_day_month = DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, old_coterminate_day_month, p_old_coterminate_day_month),
379: new_coterminate_day_month = DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, new_coterminate_day_month, p_new_coterminate_day_month),
380: old_start_date_active = DECODE( p_old_start_date_active, fnd_api.g_miss_date, old_start_date_active, p_old_start_date_active),

Line 377: new_bill_to_site_use_id = DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, new_bill_to_site_use_id, p_new_bill_to_site_use_id),

373: new_ship_to_site_use_id = DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, new_ship_to_site_use_id, p_new_ship_to_site_use_id),
374: old_install_site_use_id = DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, old_install_site_use_id, p_old_install_site_use_id),
375: new_install_site_use_id = DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, new_install_site_use_id, p_new_install_site_use_id),
376: old_bill_to_site_use_id = DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, old_bill_to_site_use_id, p_old_bill_to_site_use_id),
377: new_bill_to_site_use_id = DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, new_bill_to_site_use_id, p_new_bill_to_site_use_id),
378: old_coterminate_day_month = DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, old_coterminate_day_month, p_old_coterminate_day_month),
379: new_coterminate_day_month = DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, new_coterminate_day_month, p_new_coterminate_day_month),
380: old_start_date_active = DECODE( p_old_start_date_active, fnd_api.g_miss_date, old_start_date_active, p_old_start_date_active),
381: new_start_date_active = DECODE( p_new_start_date_active, fnd_api.g_miss_date, new_start_date_active, p_new_start_date_active),

Line 378: old_coterminate_day_month = DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, old_coterminate_day_month, p_old_coterminate_day_month),

374: old_install_site_use_id = DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, old_install_site_use_id, p_old_install_site_use_id),
375: new_install_site_use_id = DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, new_install_site_use_id, p_new_install_site_use_id),
376: old_bill_to_site_use_id = DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, old_bill_to_site_use_id, p_old_bill_to_site_use_id),
377: new_bill_to_site_use_id = DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, new_bill_to_site_use_id, p_new_bill_to_site_use_id),
378: old_coterminate_day_month = DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, old_coterminate_day_month, p_old_coterminate_day_month),
379: new_coterminate_day_month = DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, new_coterminate_day_month, p_new_coterminate_day_month),
380: old_start_date_active = DECODE( p_old_start_date_active, fnd_api.g_miss_date, old_start_date_active, p_old_start_date_active),
381: new_start_date_active = DECODE( p_new_start_date_active, fnd_api.g_miss_date, new_start_date_active, p_new_start_date_active),
382: old_end_date_active = DECODE( p_old_end_date_active, fnd_api.g_miss_date, old_end_date_active, p_old_end_date_active),

Line 379: new_coterminate_day_month = DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, new_coterminate_day_month, p_new_coterminate_day_month),

375: new_install_site_use_id = DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, new_install_site_use_id, p_new_install_site_use_id),
376: old_bill_to_site_use_id = DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, old_bill_to_site_use_id, p_old_bill_to_site_use_id),
377: new_bill_to_site_use_id = DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, new_bill_to_site_use_id, p_new_bill_to_site_use_id),
378: old_coterminate_day_month = DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, old_coterminate_day_month, p_old_coterminate_day_month),
379: new_coterminate_day_month = DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, new_coterminate_day_month, p_new_coterminate_day_month),
380: old_start_date_active = DECODE( p_old_start_date_active, fnd_api.g_miss_date, old_start_date_active, p_old_start_date_active),
381: new_start_date_active = DECODE( p_new_start_date_active, fnd_api.g_miss_date, new_start_date_active, p_new_start_date_active),
382: old_end_date_active = DECODE( p_old_end_date_active, fnd_api.g_miss_date, old_end_date_active, p_old_end_date_active),
383: new_end_date_active = DECODE( p_new_end_date_active, fnd_api.g_miss_date, new_end_date_active, p_new_end_date_active),

Line 380: old_start_date_active = DECODE( p_old_start_date_active, fnd_api.g_miss_date, old_start_date_active, p_old_start_date_active),

376: old_bill_to_site_use_id = DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, old_bill_to_site_use_id, p_old_bill_to_site_use_id),
377: new_bill_to_site_use_id = DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, new_bill_to_site_use_id, p_new_bill_to_site_use_id),
378: old_coterminate_day_month = DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, old_coterminate_day_month, p_old_coterminate_day_month),
379: new_coterminate_day_month = DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, new_coterminate_day_month, p_new_coterminate_day_month),
380: old_start_date_active = DECODE( p_old_start_date_active, fnd_api.g_miss_date, old_start_date_active, p_old_start_date_active),
381: new_start_date_active = DECODE( p_new_start_date_active, fnd_api.g_miss_date, new_start_date_active, p_new_start_date_active),
382: old_end_date_active = DECODE( p_old_end_date_active, fnd_api.g_miss_date, old_end_date_active, p_old_end_date_active),
383: new_end_date_active = DECODE( p_new_end_date_active, fnd_api.g_miss_date, new_end_date_active, p_new_end_date_active),
384: old_autocreated_from_system = DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, old_autocreated_from_system, p_old_autocreated_from_system),

Line 381: new_start_date_active = DECODE( p_new_start_date_active, fnd_api.g_miss_date, new_start_date_active, p_new_start_date_active),

377: new_bill_to_site_use_id = DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, new_bill_to_site_use_id, p_new_bill_to_site_use_id),
378: old_coterminate_day_month = DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, old_coterminate_day_month, p_old_coterminate_day_month),
379: new_coterminate_day_month = DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, new_coterminate_day_month, p_new_coterminate_day_month),
380: old_start_date_active = DECODE( p_old_start_date_active, fnd_api.g_miss_date, old_start_date_active, p_old_start_date_active),
381: new_start_date_active = DECODE( p_new_start_date_active, fnd_api.g_miss_date, new_start_date_active, p_new_start_date_active),
382: old_end_date_active = DECODE( p_old_end_date_active, fnd_api.g_miss_date, old_end_date_active, p_old_end_date_active),
383: new_end_date_active = DECODE( p_new_end_date_active, fnd_api.g_miss_date, new_end_date_active, p_new_end_date_active),
384: old_autocreated_from_system = DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, old_autocreated_from_system, p_old_autocreated_from_system),
385: new_autocreated_from_system = DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, new_autocreated_from_system, p_new_autocreated_from_system),

Line 382: old_end_date_active = DECODE( p_old_end_date_active, fnd_api.g_miss_date, old_end_date_active, p_old_end_date_active),

378: old_coterminate_day_month = DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, old_coterminate_day_month, p_old_coterminate_day_month),
379: new_coterminate_day_month = DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, new_coterminate_day_month, p_new_coterminate_day_month),
380: old_start_date_active = DECODE( p_old_start_date_active, fnd_api.g_miss_date, old_start_date_active, p_old_start_date_active),
381: new_start_date_active = DECODE( p_new_start_date_active, fnd_api.g_miss_date, new_start_date_active, p_new_start_date_active),
382: old_end_date_active = DECODE( p_old_end_date_active, fnd_api.g_miss_date, old_end_date_active, p_old_end_date_active),
383: new_end_date_active = DECODE( p_new_end_date_active, fnd_api.g_miss_date, new_end_date_active, p_new_end_date_active),
384: old_autocreated_from_system = DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, old_autocreated_from_system, p_old_autocreated_from_system),
385: new_autocreated_from_system = DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, new_autocreated_from_system, p_new_autocreated_from_system),
386: old_config_system_type = DECODE( p_old_config_system_type, fnd_api.g_miss_char, old_config_system_type, p_old_config_system_type),

Line 383: new_end_date_active = DECODE( p_new_end_date_active, fnd_api.g_miss_date, new_end_date_active, p_new_end_date_active),

379: new_coterminate_day_month = DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, new_coterminate_day_month, p_new_coterminate_day_month),
380: old_start_date_active = DECODE( p_old_start_date_active, fnd_api.g_miss_date, old_start_date_active, p_old_start_date_active),
381: new_start_date_active = DECODE( p_new_start_date_active, fnd_api.g_miss_date, new_start_date_active, p_new_start_date_active),
382: old_end_date_active = DECODE( p_old_end_date_active, fnd_api.g_miss_date, old_end_date_active, p_old_end_date_active),
383: new_end_date_active = DECODE( p_new_end_date_active, fnd_api.g_miss_date, new_end_date_active, p_new_end_date_active),
384: old_autocreated_from_system = DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, old_autocreated_from_system, p_old_autocreated_from_system),
385: new_autocreated_from_system = DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, new_autocreated_from_system, p_new_autocreated_from_system),
386: old_config_system_type = DECODE( p_old_config_system_type, fnd_api.g_miss_char, old_config_system_type, p_old_config_system_type),
387: new_config_system_type = DECODE( p_new_config_system_type, fnd_api.g_miss_char, new_config_system_type, p_new_config_system_type),

Line 384: old_autocreated_from_system = DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, old_autocreated_from_system, p_old_autocreated_from_system),

380: old_start_date_active = DECODE( p_old_start_date_active, fnd_api.g_miss_date, old_start_date_active, p_old_start_date_active),
381: new_start_date_active = DECODE( p_new_start_date_active, fnd_api.g_miss_date, new_start_date_active, p_new_start_date_active),
382: old_end_date_active = DECODE( p_old_end_date_active, fnd_api.g_miss_date, old_end_date_active, p_old_end_date_active),
383: new_end_date_active = DECODE( p_new_end_date_active, fnd_api.g_miss_date, new_end_date_active, p_new_end_date_active),
384: old_autocreated_from_system = DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, old_autocreated_from_system, p_old_autocreated_from_system),
385: new_autocreated_from_system = DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, new_autocreated_from_system, p_new_autocreated_from_system),
386: old_config_system_type = DECODE( p_old_config_system_type, fnd_api.g_miss_char, old_config_system_type, p_old_config_system_type),
387: new_config_system_type = DECODE( p_new_config_system_type, fnd_api.g_miss_char, new_config_system_type, p_new_config_system_type),
388: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),

Line 385: new_autocreated_from_system = DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, new_autocreated_from_system, p_new_autocreated_from_system),

381: new_start_date_active = DECODE( p_new_start_date_active, fnd_api.g_miss_date, new_start_date_active, p_new_start_date_active),
382: old_end_date_active = DECODE( p_old_end_date_active, fnd_api.g_miss_date, old_end_date_active, p_old_end_date_active),
383: new_end_date_active = DECODE( p_new_end_date_active, fnd_api.g_miss_date, new_end_date_active, p_new_end_date_active),
384: old_autocreated_from_system = DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, old_autocreated_from_system, p_old_autocreated_from_system),
385: new_autocreated_from_system = DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, new_autocreated_from_system, p_new_autocreated_from_system),
386: old_config_system_type = DECODE( p_old_config_system_type, fnd_api.g_miss_char, old_config_system_type, p_old_config_system_type),
387: new_config_system_type = DECODE( p_new_config_system_type, fnd_api.g_miss_char, new_config_system_type, p_new_config_system_type),
388: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
389: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),

Line 386: old_config_system_type = DECODE( p_old_config_system_type, fnd_api.g_miss_char, old_config_system_type, p_old_config_system_type),

382: old_end_date_active = DECODE( p_old_end_date_active, fnd_api.g_miss_date, old_end_date_active, p_old_end_date_active),
383: new_end_date_active = DECODE( p_new_end_date_active, fnd_api.g_miss_date, new_end_date_active, p_new_end_date_active),
384: old_autocreated_from_system = DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, old_autocreated_from_system, p_old_autocreated_from_system),
385: new_autocreated_from_system = DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, new_autocreated_from_system, p_new_autocreated_from_system),
386: old_config_system_type = DECODE( p_old_config_system_type, fnd_api.g_miss_char, old_config_system_type, p_old_config_system_type),
387: new_config_system_type = DECODE( p_new_config_system_type, fnd_api.g_miss_char, new_config_system_type, p_new_config_system_type),
388: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
389: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
390: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),

Line 387: new_config_system_type = DECODE( p_new_config_system_type, fnd_api.g_miss_char, new_config_system_type, p_new_config_system_type),

383: new_end_date_active = DECODE( p_new_end_date_active, fnd_api.g_miss_date, new_end_date_active, p_new_end_date_active),
384: old_autocreated_from_system = DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, old_autocreated_from_system, p_old_autocreated_from_system),
385: new_autocreated_from_system = DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, new_autocreated_from_system, p_new_autocreated_from_system),
386: old_config_system_type = DECODE( p_old_config_system_type, fnd_api.g_miss_char, old_config_system_type, p_old_config_system_type),
387: new_config_system_type = DECODE( p_new_config_system_type, fnd_api.g_miss_char, new_config_system_type, p_new_config_system_type),
388: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
389: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
390: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
391: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),

Line 388: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),

384: old_autocreated_from_system = DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, old_autocreated_from_system, p_old_autocreated_from_system),
385: new_autocreated_from_system = DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, new_autocreated_from_system, p_new_autocreated_from_system),
386: old_config_system_type = DECODE( p_old_config_system_type, fnd_api.g_miss_char, old_config_system_type, p_old_config_system_type),
387: new_config_system_type = DECODE( p_new_config_system_type, fnd_api.g_miss_char, new_config_system_type, p_new_config_system_type),
388: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
389: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
390: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
391: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
392: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),

Line 389: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),

385: new_autocreated_from_system = DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, new_autocreated_from_system, p_new_autocreated_from_system),
386: old_config_system_type = DECODE( p_old_config_system_type, fnd_api.g_miss_char, old_config_system_type, p_old_config_system_type),
387: new_config_system_type = DECODE( p_new_config_system_type, fnd_api.g_miss_char, new_config_system_type, p_new_config_system_type),
388: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
389: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
390: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
391: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
392: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
393: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),

Line 390: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),

386: old_config_system_type = DECODE( p_old_config_system_type, fnd_api.g_miss_char, old_config_system_type, p_old_config_system_type),
387: new_config_system_type = DECODE( p_new_config_system_type, fnd_api.g_miss_char, new_config_system_type, p_new_config_system_type),
388: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
389: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
390: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
391: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
392: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
393: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
394: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),

Line 391: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),

387: new_config_system_type = DECODE( p_new_config_system_type, fnd_api.g_miss_char, new_config_system_type, p_new_config_system_type),
388: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
389: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
390: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
391: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
392: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
393: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
394: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
395: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),

Line 392: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),

388: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
389: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
390: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
391: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
392: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
393: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
394: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
395: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
396: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),

Line 393: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),

389: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
390: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
391: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
392: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
393: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
394: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
395: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
396: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
397: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),

Line 394: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),

390: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
391: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
392: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
393: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
394: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
395: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
396: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
397: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
398: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),

Line 395: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),

391: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
392: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
393: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
394: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
395: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
396: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
397: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
398: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
399: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),

Line 396: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),

392: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
393: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
394: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
395: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
396: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
397: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
398: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
399: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
400: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),

Line 397: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),

393: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
394: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
395: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
396: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
397: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
398: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
399: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
400: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
401: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),

Line 398: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),

394: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
395: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
396: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
397: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
398: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
399: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
400: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
401: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
402: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),

Line 399: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),

395: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
396: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
397: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
398: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
399: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
400: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
401: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
402: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
403: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),

Line 400: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),

396: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
397: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
398: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
399: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
400: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
401: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
402: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
403: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
404: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),

Line 401: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),

397: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
398: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
399: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
400: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
401: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
402: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
403: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
404: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
405: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),

Line 402: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),

398: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
399: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
400: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
401: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
402: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
403: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
404: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
405: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
406: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),

Line 403: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),

399: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
400: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
401: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
402: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
403: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
404: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
405: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
406: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
407: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),

Line 404: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),

400: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
401: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
402: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
403: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
404: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
405: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
406: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
407: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
408: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),

Line 405: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),

401: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
402: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
403: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
404: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
405: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
406: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
407: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
408: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
409: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),

Line 406: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),

402: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
403: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
404: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
405: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
406: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
407: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
408: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
409: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
410: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),

Line 407: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),

403: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
404: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
405: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
406: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
407: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
408: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
409: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
410: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
411: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),

Line 408: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),

404: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
405: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
406: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
407: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
408: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
409: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
410: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
411: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
412: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),

Line 409: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),

405: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
406: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
407: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
408: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
409: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
410: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
411: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
412: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
413: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),

Line 410: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),

406: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
407: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
408: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
409: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
410: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
411: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
412: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
413: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
414: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),

Line 411: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),

407: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
408: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
409: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
410: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
411: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
412: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
413: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
414: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
415: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),

Line 412: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),

408: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
409: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
410: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
411: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
412: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
413: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
414: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
415: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
416: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),

Line 413: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),

409: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
410: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
411: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
412: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
413: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
414: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
415: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
416: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
417: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),

Line 414: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),

410: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
411: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
412: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
413: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
414: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
415: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
416: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
417: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
418: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),

Line 415: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),

411: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
412: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
413: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
414: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
415: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
416: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
417: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
418: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
419: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),

Line 416: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),

412: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
413: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
414: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
415: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
416: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
417: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
418: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
419: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
420: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),

Line 417: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),

413: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
414: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
415: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
416: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
417: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
418: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
419: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
420: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
421: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

Line 418: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),

414: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
415: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
416: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
417: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
418: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
419: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
420: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
421: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
422: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

Line 419: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),

415: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
416: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
417: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
418: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
419: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
420: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
421: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
422: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
423: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

Line 420: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),

416: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
417: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
418: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
419: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
420: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
421: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
422: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
423: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
424: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

Line 421: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

417: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
418: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
419: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
420: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
421: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
422: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
423: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
424: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
425: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),

Line 422: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

418: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
419: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
420: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
421: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
422: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
423: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
424: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
425: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
426: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number),

Line 423: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

419: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
420: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
421: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
422: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
423: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
424: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
425: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
426: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number),
427: object_version_number = object_version_number + 1,

Line 424: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

420: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
421: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
422: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
423: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
424: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
425: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
426: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number),
427: object_version_number = object_version_number + 1,
428: old_name = DECODE( p_old_name, fnd_api.g_miss_char, old_name, p_old_name),

Line 425: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),

421: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
422: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
423: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
424: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
425: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
426: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number),
427: object_version_number = object_version_number + 1,
428: old_name = DECODE( p_old_name, fnd_api.g_miss_char, old_name, p_old_name),
429: new_name = DECODE( p_new_name, fnd_api.g_miss_char, new_name, p_new_name),

Line 426: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number),

422: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
423: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
424: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
425: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
426: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number),
427: object_version_number = object_version_number + 1,
428: old_name = DECODE( p_old_name, fnd_api.g_miss_char, old_name, p_old_name),
429: new_name = DECODE( p_new_name, fnd_api.g_miss_char, new_name, p_new_name),
430: old_description = DECODE( p_old_description, fnd_api.g_miss_char, old_description, p_old_description),

Line 428: old_name = DECODE( p_old_name, fnd_api.g_miss_char, old_name, p_old_name),

424: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
425: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
426: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number),
427: object_version_number = object_version_number + 1,
428: old_name = DECODE( p_old_name, fnd_api.g_miss_char, old_name, p_old_name),
429: new_name = DECODE( p_new_name, fnd_api.g_miss_char, new_name, p_new_name),
430: old_description = DECODE( p_old_description, fnd_api.g_miss_char, old_description, p_old_description),
431: new_description = DECODE( p_new_description, fnd_api.g_miss_char, new_description, p_new_description),
432: old_operating_unit_id = DECODE(p_old_operating_unit_id,fnd_api.g_miss_num,old_operating_unit_id,p_old_operating_unit_id),

Line 429: new_name = DECODE( p_new_name, fnd_api.g_miss_char, new_name, p_new_name),

425: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
426: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number),
427: object_version_number = object_version_number + 1,
428: old_name = DECODE( p_old_name, fnd_api.g_miss_char, old_name, p_old_name),
429: new_name = DECODE( p_new_name, fnd_api.g_miss_char, new_name, p_new_name),
430: old_description = DECODE( p_old_description, fnd_api.g_miss_char, old_description, p_old_description),
431: new_description = DECODE( p_new_description, fnd_api.g_miss_char, new_description, p_new_description),
432: old_operating_unit_id = DECODE(p_old_operating_unit_id,fnd_api.g_miss_num,old_operating_unit_id,p_old_operating_unit_id),
433: new_operating_unit_id = DECODE(p_new_operating_unit_id,fnd_api.g_miss_num,new_operating_unit_id,p_new_operating_unit_id)

Line 430: old_description = DECODE( p_old_description, fnd_api.g_miss_char, old_description, p_old_description),

426: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number),
427: object_version_number = object_version_number + 1,
428: old_name = DECODE( p_old_name, fnd_api.g_miss_char, old_name, p_old_name),
429: new_name = DECODE( p_new_name, fnd_api.g_miss_char, new_name, p_new_name),
430: old_description = DECODE( p_old_description, fnd_api.g_miss_char, old_description, p_old_description),
431: new_description = DECODE( p_new_description, fnd_api.g_miss_char, new_description, p_new_description),
432: old_operating_unit_id = DECODE(p_old_operating_unit_id,fnd_api.g_miss_num,old_operating_unit_id,p_old_operating_unit_id),
433: new_operating_unit_id = DECODE(p_new_operating_unit_id,fnd_api.g_miss_num,new_operating_unit_id,p_new_operating_unit_id)
434: WHERE system_history_id = p_system_history_id;

Line 431: new_description = DECODE( p_new_description, fnd_api.g_miss_char, new_description, p_new_description),

427: object_version_number = object_version_number + 1,
428: old_name = DECODE( p_old_name, fnd_api.g_miss_char, old_name, p_old_name),
429: new_name = DECODE( p_new_name, fnd_api.g_miss_char, new_name, p_new_name),
430: old_description = DECODE( p_old_description, fnd_api.g_miss_char, old_description, p_old_description),
431: new_description = DECODE( p_new_description, fnd_api.g_miss_char, new_description, p_new_description),
432: old_operating_unit_id = DECODE(p_old_operating_unit_id,fnd_api.g_miss_num,old_operating_unit_id,p_old_operating_unit_id),
433: new_operating_unit_id = DECODE(p_new_operating_unit_id,fnd_api.g_miss_num,new_operating_unit_id,p_new_operating_unit_id)
434: WHERE system_history_id = p_system_history_id;
435:

Line 432: old_operating_unit_id = DECODE(p_old_operating_unit_id,fnd_api.g_miss_num,old_operating_unit_id,p_old_operating_unit_id),

428: old_name = DECODE( p_old_name, fnd_api.g_miss_char, old_name, p_old_name),
429: new_name = DECODE( p_new_name, fnd_api.g_miss_char, new_name, p_new_name),
430: old_description = DECODE( p_old_description, fnd_api.g_miss_char, old_description, p_old_description),
431: new_description = DECODE( p_new_description, fnd_api.g_miss_char, new_description, p_new_description),
432: old_operating_unit_id = DECODE(p_old_operating_unit_id,fnd_api.g_miss_num,old_operating_unit_id,p_old_operating_unit_id),
433: new_operating_unit_id = DECODE(p_new_operating_unit_id,fnd_api.g_miss_num,new_operating_unit_id,p_new_operating_unit_id)
434: WHERE system_history_id = p_system_history_id;
435:
436: IF (SQL%NOTFOUND) THEN

Line 433: new_operating_unit_id = DECODE(p_new_operating_unit_id,fnd_api.g_miss_num,new_operating_unit_id,p_new_operating_unit_id)

429: new_name = DECODE( p_new_name, fnd_api.g_miss_char, new_name, p_new_name),
430: old_description = DECODE( p_old_description, fnd_api.g_miss_char, old_description, p_old_description),
431: new_description = DECODE( p_new_description, fnd_api.g_miss_char, new_description, p_new_description),
432: old_operating_unit_id = DECODE(p_old_operating_unit_id,fnd_api.g_miss_num,old_operating_unit_id,p_old_operating_unit_id),
433: new_operating_unit_id = DECODE(p_new_operating_unit_id,fnd_api.g_miss_num,new_operating_unit_id,p_new_operating_unit_id)
434: WHERE system_history_id = p_system_history_id;
435:
436: IF (SQL%NOTFOUND) THEN
437: RAISE NO_DATA_FOUND;