[Home] [Help]
81: -- and raise corresponding exception. We donot need to do anything
82: -- for those tables without policy functions.
83:
84: IF x_contact_point_id IS NOT NULL AND
85: x_contact_point_id <> fnd_api.g_miss_num
86: THEN
87: l_primary_key_passed := TRUE;
88: END IF;
89:
86: THEN
87: l_primary_key_passed := TRUE;
88: END IF;
89:
90: IF x_contact_point_id = fnd_api.g_miss_num THEN
91: x_contact_point_id := NULL;
92: END IF;
93:
94: WHILE l_success = 'N' LOOP
167: ACTUAL_CONTENT_SOURCE
168: )
169: VALUES (
170: DECODE(x_contact_point_id,
171: fnd_api.g_miss_num, hz_contact_points_s.NEXTVAL,
172: NULL, hz_contact_points_s.nextval,
173: x_contact_point_id),
174: DECODE(x_contact_point_type,
175: fnd_api.g_miss_char, NULL, x_contact_point_type),
171: fnd_api.g_miss_num, hz_contact_points_s.NEXTVAL,
172: NULL, hz_contact_points_s.nextval,
173: x_contact_point_id),
174: DECODE(x_contact_point_type,
175: fnd_api.g_miss_char, NULL, x_contact_point_type),
176: DECODE(x_status, fnd_api.g_miss_char, 'A', NULL, 'A', x_status),
177: DECODE(x_owner_table_name,
178: fnd_api.g_miss_char, NULL, x_owner_table_name),
179: DECODE(x_owner_table_id,
172: NULL, hz_contact_points_s.nextval,
173: x_contact_point_id),
174: DECODE(x_contact_point_type,
175: fnd_api.g_miss_char, NULL, x_contact_point_type),
176: DECODE(x_status, fnd_api.g_miss_char, 'A', NULL, 'A', x_status),
177: DECODE(x_owner_table_name,
178: fnd_api.g_miss_char, NULL, x_owner_table_name),
179: DECODE(x_owner_table_id,
180: fnd_api.g_miss_num, NULL, x_owner_table_id),
174: DECODE(x_contact_point_type,
175: fnd_api.g_miss_char, NULL, x_contact_point_type),
176: DECODE(x_status, fnd_api.g_miss_char, 'A', NULL, 'A', x_status),
177: DECODE(x_owner_table_name,
178: fnd_api.g_miss_char, NULL, x_owner_table_name),
179: DECODE(x_owner_table_id,
180: fnd_api.g_miss_num, NULL, x_owner_table_id),
181: DECODE(x_primary_flag,
182: fnd_api.g_miss_char, 'N', NULL, 'N', x_primary_flag),
176: DECODE(x_status, fnd_api.g_miss_char, 'A', NULL, 'A', x_status),
177: DECODE(x_owner_table_name,
178: fnd_api.g_miss_char, NULL, x_owner_table_name),
179: DECODE(x_owner_table_id,
180: fnd_api.g_miss_num, NULL, x_owner_table_id),
181: DECODE(x_primary_flag,
182: fnd_api.g_miss_char, 'N', NULL, 'N', x_primary_flag),
183: DECODE(x_orig_system_reference,
184: fnd_api.g_miss_char, TO_CHAR(NVL(x_contact_point_id,
178: fnd_api.g_miss_char, NULL, x_owner_table_name),
179: DECODE(x_owner_table_id,
180: fnd_api.g_miss_num, NULL, x_owner_table_id),
181: DECODE(x_primary_flag,
182: fnd_api.g_miss_char, 'N', NULL, 'N', x_primary_flag),
183: DECODE(x_orig_system_reference,
184: fnd_api.g_miss_char, TO_CHAR(NVL(x_contact_point_id,
185: hz_contact_points_s.CURRVAL)),
186: NULL, TO_CHAR(NVL(x_contact_point_id,
180: fnd_api.g_miss_num, NULL, x_owner_table_id),
181: DECODE(x_primary_flag,
182: fnd_api.g_miss_char, 'N', NULL, 'N', x_primary_flag),
183: DECODE(x_orig_system_reference,
184: fnd_api.g_miss_char, TO_CHAR(NVL(x_contact_point_id,
185: hz_contact_points_s.CURRVAL)),
186: NULL, TO_CHAR(NVL(x_contact_point_id,
187: hz_contact_points_s.CURRVAL)),
188: x_orig_system_reference),
195: hz_utility_v2pub.program_application_id,
196: hz_utility_v2pub.program_id,
197: hz_utility_v2pub.program_update_date,
198: DECODE(x_attribute_category,
199: fnd_api.g_miss_char, NULL, x_attribute_category),
200: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
201: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
202: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
203: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
196: hz_utility_v2pub.program_id,
197: hz_utility_v2pub.program_update_date,
198: DECODE(x_attribute_category,
199: fnd_api.g_miss_char, NULL, x_attribute_category),
200: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
201: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
202: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
203: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
204: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
197: hz_utility_v2pub.program_update_date,
198: DECODE(x_attribute_category,
199: fnd_api.g_miss_char, NULL, x_attribute_category),
200: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
201: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
202: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
203: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
204: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
205: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
198: DECODE(x_attribute_category,
199: fnd_api.g_miss_char, NULL, x_attribute_category),
200: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
201: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
202: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
203: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
204: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
205: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
206: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
199: fnd_api.g_miss_char, NULL, x_attribute_category),
200: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
201: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
202: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
203: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
204: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
205: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
206: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
207: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
200: DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
201: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
202: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
203: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
204: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
205: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
206: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
207: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
208: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
201: DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
202: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
203: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
204: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
205: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
206: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
207: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
208: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
209: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
202: DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
203: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
204: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
205: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
206: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
207: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
208: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
209: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
210: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
203: DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
204: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
205: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
206: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
207: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
208: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
209: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
210: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
211: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
204: DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
205: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
206: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
207: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
208: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
209: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
210: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
211: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
212: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
205: DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
206: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
207: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
208: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
209: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
210: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
211: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
212: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
213: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
206: DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
207: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
208: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
209: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
210: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
211: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
212: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
213: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
214: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
207: DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
208: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
209: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
210: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
211: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
212: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
213: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
214: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
215: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
208: DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
209: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
210: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
211: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
212: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
213: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
214: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
215: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
216: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
209: DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
210: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
211: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
212: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
213: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
214: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
215: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
216: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
217: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
210: DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
211: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
212: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
213: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
214: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
215: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
216: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
217: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
218: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
211: DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
212: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
213: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
214: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
215: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
216: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
217: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
218: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
219: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
212: DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
213: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
214: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
215: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
216: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
217: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
218: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
219: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
220: DECODE(x_edi_transaction_handling,
213: DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
214: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
215: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
216: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
217: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
218: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
219: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
220: DECODE(x_edi_transaction_handling,
221: fnd_api.g_miss_char, NULL, x_edi_transaction_handling),
214: DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
215: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
216: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
217: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
218: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
219: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
220: DECODE(x_edi_transaction_handling,
221: fnd_api.g_miss_char, NULL, x_edi_transaction_handling),
222: DECODE(x_edi_id_number, fnd_api.g_miss_char, NULL, x_edi_id_number),
215: DECODE(x_attribute16, fnd_api.g_miss_char, NULL, x_attribute16),
216: DECODE(x_attribute17, fnd_api.g_miss_char, NULL, x_attribute17),
217: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
218: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
219: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
220: DECODE(x_edi_transaction_handling,
221: fnd_api.g_miss_char, NULL, x_edi_transaction_handling),
222: DECODE(x_edi_id_number, fnd_api.g_miss_char, NULL, x_edi_id_number),
223: DECODE(x_edi_payment_method,
217: DECODE(x_attribute18, fnd_api.g_miss_char, NULL, x_attribute18),
218: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
219: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
220: DECODE(x_edi_transaction_handling,
221: fnd_api.g_miss_char, NULL, x_edi_transaction_handling),
222: DECODE(x_edi_id_number, fnd_api.g_miss_char, NULL, x_edi_id_number),
223: DECODE(x_edi_payment_method,
224: fnd_api.g_miss_char, NULL, x_edi_payment_method),
225: DECODE(x_edi_payment_format,
218: DECODE(x_attribute19, fnd_api.g_miss_char, NULL, x_attribute19),
219: DECODE(x_attribute20, fnd_api.g_miss_char, NULL, x_attribute20),
220: DECODE(x_edi_transaction_handling,
221: fnd_api.g_miss_char, NULL, x_edi_transaction_handling),
222: DECODE(x_edi_id_number, fnd_api.g_miss_char, NULL, x_edi_id_number),
223: DECODE(x_edi_payment_method,
224: fnd_api.g_miss_char, NULL, x_edi_payment_method),
225: DECODE(x_edi_payment_format,
226: fnd_api.g_miss_char, NULL, x_edi_payment_format),
220: DECODE(x_edi_transaction_handling,
221: fnd_api.g_miss_char, NULL, x_edi_transaction_handling),
222: DECODE(x_edi_id_number, fnd_api.g_miss_char, NULL, x_edi_id_number),
223: DECODE(x_edi_payment_method,
224: fnd_api.g_miss_char, NULL, x_edi_payment_method),
225: DECODE(x_edi_payment_format,
226: fnd_api.g_miss_char, NULL, x_edi_payment_format),
227: DECODE(x_edi_remittance_method,
228: fnd_api.g_miss_char, NULL, x_edi_remittance_method),
222: DECODE(x_edi_id_number, fnd_api.g_miss_char, NULL, x_edi_id_number),
223: DECODE(x_edi_payment_method,
224: fnd_api.g_miss_char, NULL, x_edi_payment_method),
225: DECODE(x_edi_payment_format,
226: fnd_api.g_miss_char, NULL, x_edi_payment_format),
227: DECODE(x_edi_remittance_method,
228: fnd_api.g_miss_char, NULL, x_edi_remittance_method),
229: DECODE(x_edi_remittance_instruction,
230: fnd_api.g_miss_char, NULL, x_edi_remittance_instruction),
224: fnd_api.g_miss_char, NULL, x_edi_payment_method),
225: DECODE(x_edi_payment_format,
226: fnd_api.g_miss_char, NULL, x_edi_payment_format),
227: DECODE(x_edi_remittance_method,
228: fnd_api.g_miss_char, NULL, x_edi_remittance_method),
229: DECODE(x_edi_remittance_instruction,
230: fnd_api.g_miss_char, NULL, x_edi_remittance_instruction),
231: DECODE(x_edi_tp_header_id,
232: fnd_api.g_miss_num, NULL, x_edi_tp_header_id),
226: fnd_api.g_miss_char, NULL, x_edi_payment_format),
227: DECODE(x_edi_remittance_method,
228: fnd_api.g_miss_char, NULL, x_edi_remittance_method),
229: DECODE(x_edi_remittance_instruction,
230: fnd_api.g_miss_char, NULL, x_edi_remittance_instruction),
231: DECODE(x_edi_tp_header_id,
232: fnd_api.g_miss_num, NULL, x_edi_tp_header_id),
233: DECODE(x_edi_ece_tp_location_code,
234: fnd_api.g_miss_char, NULL, x_edi_ece_tp_location_code),
228: fnd_api.g_miss_char, NULL, x_edi_remittance_method),
229: DECODE(x_edi_remittance_instruction,
230: fnd_api.g_miss_char, NULL, x_edi_remittance_instruction),
231: DECODE(x_edi_tp_header_id,
232: fnd_api.g_miss_num, NULL, x_edi_tp_header_id),
233: DECODE(x_edi_ece_tp_location_code,
234: fnd_api.g_miss_char, NULL, x_edi_ece_tp_location_code),
235: DECODE(x_eft_transmission_program_id,
236: fnd_api.g_miss_num, NULL, x_eft_transmission_program_id),
230: fnd_api.g_miss_char, NULL, x_edi_remittance_instruction),
231: DECODE(x_edi_tp_header_id,
232: fnd_api.g_miss_num, NULL, x_edi_tp_header_id),
233: DECODE(x_edi_ece_tp_location_code,
234: fnd_api.g_miss_char, NULL, x_edi_ece_tp_location_code),
235: DECODE(x_eft_transmission_program_id,
236: fnd_api.g_miss_num, NULL, x_eft_transmission_program_id),
237: DECODE(x_eft_printing_program_id,
238: fnd_api.g_miss_num, NULL, x_eft_printing_program_id),
232: fnd_api.g_miss_num, NULL, x_edi_tp_header_id),
233: DECODE(x_edi_ece_tp_location_code,
234: fnd_api.g_miss_char, NULL, x_edi_ece_tp_location_code),
235: DECODE(x_eft_transmission_program_id,
236: fnd_api.g_miss_num, NULL, x_eft_transmission_program_id),
237: DECODE(x_eft_printing_program_id,
238: fnd_api.g_miss_num, NULL, x_eft_printing_program_id),
239: DECODE(x_eft_user_number,
240: fnd_api.g_miss_char, NULL, x_eft_user_number),
234: fnd_api.g_miss_char, NULL, x_edi_ece_tp_location_code),
235: DECODE(x_eft_transmission_program_id,
236: fnd_api.g_miss_num, NULL, x_eft_transmission_program_id),
237: DECODE(x_eft_printing_program_id,
238: fnd_api.g_miss_num, NULL, x_eft_printing_program_id),
239: DECODE(x_eft_user_number,
240: fnd_api.g_miss_char, NULL, x_eft_user_number),
241: DECODE(x_eft_swift_code,
242: fnd_api.g_miss_char, NULL, x_eft_swift_code),
236: fnd_api.g_miss_num, NULL, x_eft_transmission_program_id),
237: DECODE(x_eft_printing_program_id,
238: fnd_api.g_miss_num, NULL, x_eft_printing_program_id),
239: DECODE(x_eft_user_number,
240: fnd_api.g_miss_char, NULL, x_eft_user_number),
241: DECODE(x_eft_swift_code,
242: fnd_api.g_miss_char, NULL, x_eft_swift_code),
243: ---Bug No. 4359226
244: DECODE(x_email_format,
238: fnd_api.g_miss_num, NULL, x_eft_printing_program_id),
239: DECODE(x_eft_user_number,
240: fnd_api.g_miss_char, NULL, x_eft_user_number),
241: DECODE(x_eft_swift_code,
242: fnd_api.g_miss_char, NULL, x_eft_swift_code),
243: ---Bug No. 4359226
244: DECODE(x_email_format,
245: fnd_api.g_miss_char, DECODE(x_contact_point_type,
246: 'EMAIL', 'MAILTEXT', NULL),
241: DECODE(x_eft_swift_code,
242: fnd_api.g_miss_char, NULL, x_eft_swift_code),
243: ---Bug No. 4359226
244: DECODE(x_email_format,
245: fnd_api.g_miss_char, DECODE(x_contact_point_type,
246: 'EMAIL', 'MAILTEXT', NULL),
247: NULL, DECODE(x_contact_point_type, 'EMAIL', 'MAILTEXT', NULL),
248: x_email_format),
249: ----Bug No. 4359226
247: NULL, DECODE(x_contact_point_type, 'EMAIL', 'MAILTEXT', NULL),
248: x_email_format),
249: ----Bug No. 4359226
250: --Bug 4355133
251: SUBSTRB(DECODE(x_email_address, fnd_api.g_miss_char, NULL,
252: x_email_address),1,320),
253: DECODE(x_phone_calling_calendar,
254: fnd_api.g_miss_char, NULL, x_phone_calling_calendar),
255: DECODE(x_last_contact_dt_time,
250: --Bug 4355133
251: SUBSTRB(DECODE(x_email_address, fnd_api.g_miss_char, NULL,
252: x_email_address),1,320),
253: DECODE(x_phone_calling_calendar,
254: fnd_api.g_miss_char, NULL, x_phone_calling_calendar),
255: DECODE(x_last_contact_dt_time,
256: fnd_api.g_miss_date, to_date(NULL), x_last_contact_dt_time),
257: DECODE(x_timezone_id, fnd_api.g_miss_num, NULL, x_timezone_id),
258: DECODE(x_phone_area_code,
252: x_email_address),1,320),
253: DECODE(x_phone_calling_calendar,
254: fnd_api.g_miss_char, NULL, x_phone_calling_calendar),
255: DECODE(x_last_contact_dt_time,
256: fnd_api.g_miss_date, to_date(NULL), x_last_contact_dt_time),
257: DECODE(x_timezone_id, fnd_api.g_miss_num, NULL, x_timezone_id),
258: DECODE(x_phone_area_code,
259: fnd_api.g_miss_char, NULL, x_phone_area_code),
260: DECODE(x_phone_country_code,
253: DECODE(x_phone_calling_calendar,
254: fnd_api.g_miss_char, NULL, x_phone_calling_calendar),
255: DECODE(x_last_contact_dt_time,
256: fnd_api.g_miss_date, to_date(NULL), x_last_contact_dt_time),
257: DECODE(x_timezone_id, fnd_api.g_miss_num, NULL, x_timezone_id),
258: DECODE(x_phone_area_code,
259: fnd_api.g_miss_char, NULL, x_phone_area_code),
260: DECODE(x_phone_country_code,
261: fnd_api.g_miss_char, NULL, x_phone_country_code),
255: DECODE(x_last_contact_dt_time,
256: fnd_api.g_miss_date, to_date(NULL), x_last_contact_dt_time),
257: DECODE(x_timezone_id, fnd_api.g_miss_num, NULL, x_timezone_id),
258: DECODE(x_phone_area_code,
259: fnd_api.g_miss_char, NULL, x_phone_area_code),
260: DECODE(x_phone_country_code,
261: fnd_api.g_miss_char, NULL, x_phone_country_code),
262: DECODE(x_phone_number, fnd_api.g_miss_char, NULL, x_phone_number),
263: DECODE(x_phone_extension,
257: DECODE(x_timezone_id, fnd_api.g_miss_num, NULL, x_timezone_id),
258: DECODE(x_phone_area_code,
259: fnd_api.g_miss_char, NULL, x_phone_area_code),
260: DECODE(x_phone_country_code,
261: fnd_api.g_miss_char, NULL, x_phone_country_code),
262: DECODE(x_phone_number, fnd_api.g_miss_char, NULL, x_phone_number),
263: DECODE(x_phone_extension,
264: fnd_api.g_miss_char, NULL, x_phone_extension),
265: DECODE(x_phone_line_type,
258: DECODE(x_phone_area_code,
259: fnd_api.g_miss_char, NULL, x_phone_area_code),
260: DECODE(x_phone_country_code,
261: fnd_api.g_miss_char, NULL, x_phone_country_code),
262: DECODE(x_phone_number, fnd_api.g_miss_char, NULL, x_phone_number),
263: DECODE(x_phone_extension,
264: fnd_api.g_miss_char, NULL, x_phone_extension),
265: DECODE(x_phone_line_type,
266: fnd_api.g_miss_char, NULL, x_phone_line_type),
260: DECODE(x_phone_country_code,
261: fnd_api.g_miss_char, NULL, x_phone_country_code),
262: DECODE(x_phone_number, fnd_api.g_miss_char, NULL, x_phone_number),
263: DECODE(x_phone_extension,
264: fnd_api.g_miss_char, NULL, x_phone_extension),
265: DECODE(x_phone_line_type,
266: fnd_api.g_miss_char, NULL, x_phone_line_type),
267: DECODE(x_telex_number, fnd_api.g_miss_char, NULL, x_telex_number),
268: DECODE(x_web_type, fnd_api.g_miss_char, NULL, x_web_type),
262: DECODE(x_phone_number, fnd_api.g_miss_char, NULL, x_phone_number),
263: DECODE(x_phone_extension,
264: fnd_api.g_miss_char, NULL, x_phone_extension),
265: DECODE(x_phone_line_type,
266: fnd_api.g_miss_char, NULL, x_phone_line_type),
267: DECODE(x_telex_number, fnd_api.g_miss_char, NULL, x_telex_number),
268: DECODE(x_web_type, fnd_api.g_miss_char, NULL, x_web_type),
269: DECODE(x_url, fnd_api.g_miss_char, NULL, x_url),
270: DECODE(x_content_source_type,
263: DECODE(x_phone_extension,
264: fnd_api.g_miss_char, NULL, x_phone_extension),
265: DECODE(x_phone_line_type,
266: fnd_api.g_miss_char, NULL, x_phone_line_type),
267: DECODE(x_telex_number, fnd_api.g_miss_char, NULL, x_telex_number),
268: DECODE(x_web_type, fnd_api.g_miss_char, NULL, x_web_type),
269: DECODE(x_url, fnd_api.g_miss_char, NULL, x_url),
270: DECODE(x_content_source_type,
271: fnd_api.g_miss_char, g_miss_content_source_type,
264: fnd_api.g_miss_char, NULL, x_phone_extension),
265: DECODE(x_phone_line_type,
266: fnd_api.g_miss_char, NULL, x_phone_line_type),
267: DECODE(x_telex_number, fnd_api.g_miss_char, NULL, x_telex_number),
268: DECODE(x_web_type, fnd_api.g_miss_char, NULL, x_web_type),
269: DECODE(x_url, fnd_api.g_miss_char, NULL, x_url),
270: DECODE(x_content_source_type,
271: fnd_api.g_miss_char, g_miss_content_source_type,
272: NULL, g_miss_content_source_type,
265: DECODE(x_phone_line_type,
266: fnd_api.g_miss_char, NULL, x_phone_line_type),
267: DECODE(x_telex_number, fnd_api.g_miss_char, NULL, x_telex_number),
268: DECODE(x_web_type, fnd_api.g_miss_char, NULL, x_web_type),
269: DECODE(x_url, fnd_api.g_miss_char, NULL, x_url),
270: DECODE(x_content_source_type,
271: fnd_api.g_miss_char, g_miss_content_source_type,
272: NULL, g_miss_content_source_type,
273: x_content_source_type),
267: DECODE(x_telex_number, fnd_api.g_miss_char, NULL, x_telex_number),
268: DECODE(x_web_type, fnd_api.g_miss_char, NULL, x_web_type),
269: DECODE(x_url, fnd_api.g_miss_char, NULL, x_url),
270: DECODE(x_content_source_type,
271: fnd_api.g_miss_char, g_miss_content_source_type,
272: NULL, g_miss_content_source_type,
273: x_content_source_type),
274: DECODE(x_raw_phone_number,
275: fnd_api.g_miss_char, NULL, x_raw_phone_number),
271: fnd_api.g_miss_char, g_miss_content_source_type,
272: NULL, g_miss_content_source_type,
273: x_content_source_type),
274: DECODE(x_raw_phone_number,
275: fnd_api.g_miss_char, NULL, x_raw_phone_number),
276: DECODE(x_object_version_number,
277: fnd_api.g_miss_num, NULL, x_object_version_number),
278: DECODE(x_contact_point_purpose,
279: fnd_api.g_miss_char, NULL, x_contact_point_purpose),
273: x_content_source_type),
274: DECODE(x_raw_phone_number,
275: fnd_api.g_miss_char, NULL, x_raw_phone_number),
276: DECODE(x_object_version_number,
277: fnd_api.g_miss_num, NULL, x_object_version_number),
278: DECODE(x_contact_point_purpose,
279: fnd_api.g_miss_char, NULL, x_contact_point_purpose),
280: DECODE(x_primary_by_purpose,
281: fnd_api.g_miss_char, 'N', NULL, 'N', x_primary_by_purpose),
275: fnd_api.g_miss_char, NULL, x_raw_phone_number),
276: DECODE(x_object_version_number,
277: fnd_api.g_miss_num, NULL, x_object_version_number),
278: DECODE(x_contact_point_purpose,
279: fnd_api.g_miss_char, NULL, x_contact_point_purpose),
280: DECODE(x_primary_by_purpose,
281: fnd_api.g_miss_char, 'N', NULL, 'N', x_primary_by_purpose),
282: DECODE(x_created_by_module,
283: fnd_api.g_miss_char, NULL, x_created_by_module),
277: fnd_api.g_miss_num, NULL, x_object_version_number),
278: DECODE(x_contact_point_purpose,
279: fnd_api.g_miss_char, NULL, x_contact_point_purpose),
280: DECODE(x_primary_by_purpose,
281: fnd_api.g_miss_char, 'N', NULL, 'N', x_primary_by_purpose),
282: DECODE(x_created_by_module,
283: fnd_api.g_miss_char, NULL, x_created_by_module),
284: DECODE(x_application_id,
285: fnd_api.g_miss_num, NULL, x_application_id),
279: fnd_api.g_miss_char, NULL, x_contact_point_purpose),
280: DECODE(x_primary_by_purpose,
281: fnd_api.g_miss_char, 'N', NULL, 'N', x_primary_by_purpose),
282: DECODE(x_created_by_module,
283: fnd_api.g_miss_char, NULL, x_created_by_module),
284: DECODE(x_application_id,
285: fnd_api.g_miss_num, NULL, x_application_id),
286: DECODE(x_transposed_phone_number,
287: fnd_api.g_miss_char, NULL, x_transposed_phone_number),
281: fnd_api.g_miss_char, 'N', NULL, 'N', x_primary_by_purpose),
282: DECODE(x_created_by_module,
283: fnd_api.g_miss_char, NULL, x_created_by_module),
284: DECODE(x_application_id,
285: fnd_api.g_miss_num, NULL, x_application_id),
286: DECODE(x_transposed_phone_number,
287: fnd_api.g_miss_char, NULL, x_transposed_phone_number),
288: DECODE(x_actual_content_source,
289: fnd_api.g_miss_char, g_miss_content_source_type,
283: fnd_api.g_miss_char, NULL, x_created_by_module),
284: DECODE(x_application_id,
285: fnd_api.g_miss_num, NULL, x_application_id),
286: DECODE(x_transposed_phone_number,
287: fnd_api.g_miss_char, NULL, x_transposed_phone_number),
288: DECODE(x_actual_content_source,
289: fnd_api.g_miss_char, g_miss_content_source_type,
290: NULL, g_miss_content_source_type,
291: x_actual_content_source )
285: fnd_api.g_miss_num, NULL, x_application_id),
286: DECODE(x_transposed_phone_number,
287: fnd_api.g_miss_char, NULL, x_transposed_phone_number),
288: DECODE(x_actual_content_source,
289: fnd_api.g_miss_char, g_miss_content_source_type,
290: NULL, g_miss_content_source_type,
291: x_actual_content_source )
292: )
293: RETURNING contact_point_id INTO x_contact_point_id;
302: IF l_primary_key_passed THEN
303: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
304: fnd_message.set_token('COLUMN', 'contact_point_id');
305: fnd_msg_pub.add;
306: RAISE fnd_api.g_exc_error;
307: END IF;
308:
309: -- code to find a valid contact point ID.
310: DECLARE
421:
422: UPDATE hz_contact_points SET
423: contact_point_id = DECODE(x_contact_point_id,
424: NULL, contact_point_id,
425: fnd_api.g_miss_num, NULL,
426: x_contact_point_id),
427: contact_point_type = DECODE(x_contact_point_type,
428: NULL, contact_point_type,
429: fnd_api.g_miss_char, NULL,
425: fnd_api.g_miss_num, NULL,
426: x_contact_point_id),
427: contact_point_type = DECODE(x_contact_point_type,
428: NULL, contact_point_type,
429: fnd_api.g_miss_char, NULL,
430: x_contact_point_type),
431: status = DECODE(x_status,
432: NULL, status,
433: fnd_api.g_miss_char, 'A',
429: fnd_api.g_miss_char, NULL,
430: x_contact_point_type),
431: status = DECODE(x_status,
432: NULL, status,
433: fnd_api.g_miss_char, 'A',
434: x_status),
435: owner_table_name = DECODE(x_owner_table_name,
436: NULL, owner_table_name,
437: fnd_api.g_miss_char, NULL,
433: fnd_api.g_miss_char, 'A',
434: x_status),
435: owner_table_name = DECODE(x_owner_table_name,
436: NULL, owner_table_name,
437: fnd_api.g_miss_char, NULL,
438: x_owner_table_name),
439: owner_table_id = DECODE(x_owner_table_id,
440: NULL, owner_table_id,
441: fnd_api.g_miss_num, NULL,
437: fnd_api.g_miss_char, NULL,
438: x_owner_table_name),
439: owner_table_id = DECODE(x_owner_table_id,
440: NULL, owner_table_id,
441: fnd_api.g_miss_num, NULL,
442: x_owner_table_id),
443: primary_flag = DECODE(x_primary_flag,
444: NULL, primary_flag,
445: fnd_api.g_miss_char, 'N',
441: fnd_api.g_miss_num, NULL,
442: x_owner_table_id),
443: primary_flag = DECODE(x_primary_flag,
444: NULL, primary_flag,
445: fnd_api.g_miss_char, 'N',
446: x_primary_flag),
447: orig_system_reference = DECODE(x_orig_system_reference,
448: NULL, orig_system_reference,
449: fnd_api.g_miss_char,
445: fnd_api.g_miss_char, 'N',
446: x_primary_flag),
447: orig_system_reference = DECODE(x_orig_system_reference,
448: NULL, orig_system_reference,
449: fnd_api.g_miss_char,
450: TO_CHAR(x_contact_point_id),
451: x_orig_system_reference),
452: last_update_date = hz_utility_v2pub.last_update_date,
453: last_updated_by = hz_utility_v2pub.last_updated_by,
459: program_id = hz_utility_v2pub.program_id,
460: program_update_date = hz_utility_v2pub.program_update_date,
461: attribute_category = DECODE(x_attribute_category,
462: NULL, attribute_category,
463: fnd_api.g_miss_char, NULL,
464: x_attribute_category),
465: attribute1 = DECODE(x_attribute1,
466: NULL, attribute1,
467: fnd_api.g_miss_char, NULL,
463: fnd_api.g_miss_char, NULL,
464: x_attribute_category),
465: attribute1 = DECODE(x_attribute1,
466: NULL, attribute1,
467: fnd_api.g_miss_char, NULL,
468: x_attribute1),
469: attribute2 = DECODE(x_attribute2,
470: NULL, attribute2,
471: fnd_api.g_miss_char, NULL,
467: fnd_api.g_miss_char, NULL,
468: x_attribute1),
469: attribute2 = DECODE(x_attribute2,
470: NULL, attribute2,
471: fnd_api.g_miss_char, NULL,
472: x_attribute2),
473: attribute3 = DECODE(x_attribute3,
474: NULL, attribute3,
475: fnd_api.g_miss_char, NULL,
471: fnd_api.g_miss_char, NULL,
472: x_attribute2),
473: attribute3 = DECODE(x_attribute3,
474: NULL, attribute3,
475: fnd_api.g_miss_char, NULL,
476: x_attribute3),
477: attribute4 = DECODE(x_attribute4,
478: NULL, attribute4,
479: fnd_api.g_miss_char, NULL,
475: fnd_api.g_miss_char, NULL,
476: x_attribute3),
477: attribute4 = DECODE(x_attribute4,
478: NULL, attribute4,
479: fnd_api.g_miss_char, NULL,
480: x_attribute4),
481: attribute5 = DECODE(x_attribute5,
482: NULL, attribute5,
483: fnd_api.g_miss_char, NULL,
479: fnd_api.g_miss_char, NULL,
480: x_attribute4),
481: attribute5 = DECODE(x_attribute5,
482: NULL, attribute5,
483: fnd_api.g_miss_char, NULL,
484: x_attribute5),
485: attribute6 = DECODE(x_attribute6,
486: NULL, attribute6,
487: fnd_api.g_miss_char, NULL,
483: fnd_api.g_miss_char, NULL,
484: x_attribute5),
485: attribute6 = DECODE(x_attribute6,
486: NULL, attribute6,
487: fnd_api.g_miss_char, NULL,
488: x_attribute6),
489: attribute7 = DECODE(x_attribute7,
490: NULL, attribute7,
491: fnd_api.g_miss_char, NULL,
487: fnd_api.g_miss_char, NULL,
488: x_attribute6),
489: attribute7 = DECODE(x_attribute7,
490: NULL, attribute7,
491: fnd_api.g_miss_char, NULL,
492: x_attribute7),
493: attribute8 = DECODE(x_attribute8,
494: NULL, attribute8,
495: fnd_api.g_miss_char, NULL,
491: fnd_api.g_miss_char, NULL,
492: x_attribute7),
493: attribute8 = DECODE(x_attribute8,
494: NULL, attribute8,
495: fnd_api.g_miss_char, NULL,
496: x_attribute8),
497: attribute9 = DECODE(x_attribute9,
498: NULL, attribute9,
499: fnd_api.g_miss_char, NULL,
495: fnd_api.g_miss_char, NULL,
496: x_attribute8),
497: attribute9 = DECODE(x_attribute9,
498: NULL, attribute9,
499: fnd_api.g_miss_char, NULL,
500: x_attribute9),
501: attribute10 = DECODE(x_attribute10,
502: NULL, attribute10,
503: fnd_api.g_miss_char, NULL,
499: fnd_api.g_miss_char, NULL,
500: x_attribute9),
501: attribute10 = DECODE(x_attribute10,
502: NULL, attribute10,
503: fnd_api.g_miss_char, NULL,
504: x_attribute10),
505: attribute11 = DECODE(x_attribute11,
506: NULL, attribute11,
507: fnd_api.g_miss_char, NULL,
503: fnd_api.g_miss_char, NULL,
504: x_attribute10),
505: attribute11 = DECODE(x_attribute11,
506: NULL, attribute11,
507: fnd_api.g_miss_char, NULL,
508: x_attribute11),
509: attribute12 = DECODE(x_attribute12,
510: NULL, attribute12,
511: fnd_api.g_miss_char, NULL,
507: fnd_api.g_miss_char, NULL,
508: x_attribute11),
509: attribute12 = DECODE(x_attribute12,
510: NULL, attribute12,
511: fnd_api.g_miss_char, NULL,
512: x_attribute12),
513: attribute13 = DECODE(x_attribute13,
514: NULL, attribute13,
515: fnd_api.g_miss_char, NULL,
511: fnd_api.g_miss_char, NULL,
512: x_attribute12),
513: attribute13 = DECODE(x_attribute13,
514: NULL, attribute13,
515: fnd_api.g_miss_char, NULL,
516: x_attribute13),
517: attribute14 = DECODE(x_attribute14,
518: NULL, attribute14,
519: fnd_api.g_miss_char, NULL,
515: fnd_api.g_miss_char, NULL,
516: x_attribute13),
517: attribute14 = DECODE(x_attribute14,
518: NULL, attribute14,
519: fnd_api.g_miss_char, NULL,
520: x_attribute14),
521: attribute15 = DECODE(x_attribute15,
522: NULL, attribute15,
523: fnd_api.g_miss_char, NULL,
519: fnd_api.g_miss_char, NULL,
520: x_attribute14),
521: attribute15 = DECODE(x_attribute15,
522: NULL, attribute15,
523: fnd_api.g_miss_char, NULL,
524: x_attribute15),
525: attribute16 = DECODE(x_attribute16,
526: NULL, attribute16,
527: fnd_api.g_miss_char, NULL,
523: fnd_api.g_miss_char, NULL,
524: x_attribute15),
525: attribute16 = DECODE(x_attribute16,
526: NULL, attribute16,
527: fnd_api.g_miss_char, NULL,
528: x_attribute16),
529: attribute17 = DECODE(x_attribute17,
530: NULL, attribute17,
531: fnd_api.g_miss_char, NULL,
527: fnd_api.g_miss_char, NULL,
528: x_attribute16),
529: attribute17 = DECODE(x_attribute17,
530: NULL, attribute17,
531: fnd_api.g_miss_char, NULL,
532: x_attribute17),
533: attribute18 = DECODE(x_attribute18,
534: NULL, attribute18,
535: fnd_api.g_miss_char, NULL,
531: fnd_api.g_miss_char, NULL,
532: x_attribute17),
533: attribute18 = DECODE(x_attribute18,
534: NULL, attribute18,
535: fnd_api.g_miss_char, NULL,
536: x_attribute18),
537: attribute19 = DECODE(x_attribute19,
538: NULL, attribute19,
539: fnd_api.g_miss_char, NULL,
535: fnd_api.g_miss_char, NULL,
536: x_attribute18),
537: attribute19 = DECODE(x_attribute19,
538: NULL, attribute19,
539: fnd_api.g_miss_char, NULL,
540: x_attribute19),
541: attribute20 = DECODE(x_attribute20,
542: NULL, attribute20,
543: fnd_api.g_miss_char, NULL,
539: fnd_api.g_miss_char, NULL,
540: x_attribute19),
541: attribute20 = DECODE(x_attribute20,
542: NULL, attribute20,
543: fnd_api.g_miss_char, NULL,
544: x_attribute20),
545: edi_transaction_handling = DECODE(x_edi_transaction_handling,
546: NULL, edi_transaction_handling,
547: fnd_api.g_miss_char, NULL,
543: fnd_api.g_miss_char, NULL,
544: x_attribute20),
545: edi_transaction_handling = DECODE(x_edi_transaction_handling,
546: NULL, edi_transaction_handling,
547: fnd_api.g_miss_char, NULL,
548: x_edi_transaction_handling),
549: edi_id_number = DECODE(x_edi_id_number,
550: NULL, edi_id_number,
551: fnd_api.g_miss_char, NULL,
547: fnd_api.g_miss_char, NULL,
548: x_edi_transaction_handling),
549: edi_id_number = DECODE(x_edi_id_number,
550: NULL, edi_id_number,
551: fnd_api.g_miss_char, NULL,
552: x_edi_id_number),
553: edi_payment_method = DECODE(x_edi_payment_method,
554: NULL, edi_payment_method,
555: fnd_api.g_miss_char, NULL,
551: fnd_api.g_miss_char, NULL,
552: x_edi_id_number),
553: edi_payment_method = DECODE(x_edi_payment_method,
554: NULL, edi_payment_method,
555: fnd_api.g_miss_char, NULL,
556: x_edi_payment_method),
557: edi_payment_format = DECODE(x_edi_payment_format,
558: NULL, edi_payment_format,
559: fnd_api.g_miss_char, NULL,
555: fnd_api.g_miss_char, NULL,
556: x_edi_payment_method),
557: edi_payment_format = DECODE(x_edi_payment_format,
558: NULL, edi_payment_format,
559: fnd_api.g_miss_char, NULL,
560: x_edi_payment_format),
561: edi_remittance_method = DECODE(x_edi_remittance_method,
562: NULL, edi_remittance_method,
563: fnd_api.g_miss_char, NULL,
559: fnd_api.g_miss_char, NULL,
560: x_edi_payment_format),
561: edi_remittance_method = DECODE(x_edi_remittance_method,
562: NULL, edi_remittance_method,
563: fnd_api.g_miss_char, NULL,
564: x_edi_remittance_method),
565: edi_remittance_instruction= DECODE(x_edi_remittance_instruction,
566: NULL, edi_remittance_instruction,
567: fnd_api.g_miss_char, NULL,
563: fnd_api.g_miss_char, NULL,
564: x_edi_remittance_method),
565: edi_remittance_instruction= DECODE(x_edi_remittance_instruction,
566: NULL, edi_remittance_instruction,
567: fnd_api.g_miss_char, NULL,
568: x_edi_remittance_instruction),
569: edi_tp_header_id = DECODE(x_edi_tp_header_id,
570: NULL, edi_tp_header_id,
571: fnd_api.g_miss_num, NULL,
567: fnd_api.g_miss_char, NULL,
568: x_edi_remittance_instruction),
569: edi_tp_header_id = DECODE(x_edi_tp_header_id,
570: NULL, edi_tp_header_id,
571: fnd_api.g_miss_num, NULL,
572: x_edi_tp_header_id),
573: edi_ece_tp_location_code = DECODE(x_edi_ece_tp_location_code,
574: NULL, edi_ece_tp_location_code,
575: fnd_api.g_miss_char, NULL,
571: fnd_api.g_miss_num, NULL,
572: x_edi_tp_header_id),
573: edi_ece_tp_location_code = DECODE(x_edi_ece_tp_location_code,
574: NULL, edi_ece_tp_location_code,
575: fnd_api.g_miss_char, NULL,
576: x_edi_ece_tp_location_code),
577: eft_transmission_program_id=DECODE(x_eft_transmission_program_id,
578: NULL, eft_transmission_program_id,
579: fnd_api.g_miss_num, NULL,
575: fnd_api.g_miss_char, NULL,
576: x_edi_ece_tp_location_code),
577: eft_transmission_program_id=DECODE(x_eft_transmission_program_id,
578: NULL, eft_transmission_program_id,
579: fnd_api.g_miss_num, NULL,
580: x_eft_transmission_program_id),
581: eft_printing_program_id = DECODE(x_eft_printing_program_id,
582: NULL, eft_printing_program_id,
583: fnd_api.g_miss_num, NULL,
579: fnd_api.g_miss_num, NULL,
580: x_eft_transmission_program_id),
581: eft_printing_program_id = DECODE(x_eft_printing_program_id,
582: NULL, eft_printing_program_id,
583: fnd_api.g_miss_num, NULL,
584: x_eft_printing_program_id),
585: eft_user_number = DECODE(x_eft_user_number,
586: NULL, eft_user_number,
587: fnd_api.g_miss_char, NULL,
583: fnd_api.g_miss_num, NULL,
584: x_eft_printing_program_id),
585: eft_user_number = DECODE(x_eft_user_number,
586: NULL, eft_user_number,
587: fnd_api.g_miss_char, NULL,
588: x_eft_user_number),
589: eft_swift_code = DECODE(x_eft_swift_code,
590: NULL, eft_swift_code,
591: fnd_api.g_miss_char, NULL,
587: fnd_api.g_miss_char, NULL,
588: x_eft_user_number),
589: eft_swift_code = DECODE(x_eft_swift_code,
590: NULL, eft_swift_code,
591: fnd_api.g_miss_char, NULL,
592: x_eft_swift_code),
593: email_format = DECODE(x_email_format,
594: NULL, email_format,
595: fnd_api.g_miss_char, NULL,
591: fnd_api.g_miss_char, NULL,
592: x_eft_swift_code),
593: email_format = DECODE(x_email_format,
594: NULL, email_format,
595: fnd_api.g_miss_char, NULL,
596: x_email_format),
597: --Bug 4355133
598: email_address = SUBSTRB(DECODE(x_email_address,
599: NULL, email_address,
596: x_email_format),
597: --Bug 4355133
598: email_address = SUBSTRB(DECODE(x_email_address,
599: NULL, email_address,
600: fnd_api.g_miss_char, NULL,
601: x_email_address),1,320),
602: phone_calling_calendar = DECODE(x_phone_calling_calendar,
603: NULL, phone_calling_calendar,
604: fnd_api.g_miss_char, NULL,
600: fnd_api.g_miss_char, NULL,
601: x_email_address),1,320),
602: phone_calling_calendar = DECODE(x_phone_calling_calendar,
603: NULL, phone_calling_calendar,
604: fnd_api.g_miss_char, NULL,
605: x_phone_calling_calendar),
606: last_contact_dt_time = DECODE(x_last_contact_dt_time,
607: NULL, last_contact_dt_time,
608: fnd_api.g_miss_date, NULL,
604: fnd_api.g_miss_char, NULL,
605: x_phone_calling_calendar),
606: last_contact_dt_time = DECODE(x_last_contact_dt_time,
607: NULL, last_contact_dt_time,
608: fnd_api.g_miss_date, NULL,
609: x_last_contact_dt_time),
610: timezone_id = DECODE(x_timezone_id,
611: NULL, timezone_id,
612: fnd_api.g_miss_num, NULL,
608: fnd_api.g_miss_date, NULL,
609: x_last_contact_dt_time),
610: timezone_id = DECODE(x_timezone_id,
611: NULL, timezone_id,
612: fnd_api.g_miss_num, NULL,
613: x_timezone_id),
614: phone_area_code = DECODE(x_phone_area_code,
615: NULL, phone_area_code,
616: fnd_api.g_miss_char, NULL,
612: fnd_api.g_miss_num, NULL,
613: x_timezone_id),
614: phone_area_code = DECODE(x_phone_area_code,
615: NULL, phone_area_code,
616: fnd_api.g_miss_char, NULL,
617: x_phone_area_code),
618: phone_country_code = DECODE(x_phone_country_code,
619: NULL, phone_country_code,
620: fnd_api.g_miss_char, NULL,
616: fnd_api.g_miss_char, NULL,
617: x_phone_area_code),
618: phone_country_code = DECODE(x_phone_country_code,
619: NULL, phone_country_code,
620: fnd_api.g_miss_char, NULL,
621: x_phone_country_code),
622: phone_number = DECODE(x_phone_number,
623: NULL, phone_number,
624: fnd_api.g_miss_char, NULL,
620: fnd_api.g_miss_char, NULL,
621: x_phone_country_code),
622: phone_number = DECODE(x_phone_number,
623: NULL, phone_number,
624: fnd_api.g_miss_char, NULL,
625: x_phone_number),
626: phone_extension = DECODE(x_phone_extension,
627: NULL, phone_extension,
628: fnd_api.g_miss_char, NULL,
624: fnd_api.g_miss_char, NULL,
625: x_phone_number),
626: phone_extension = DECODE(x_phone_extension,
627: NULL, phone_extension,
628: fnd_api.g_miss_char, NULL,
629: x_phone_extension),
630: phone_line_type = DECODE(x_phone_line_type,
631: NULL, phone_line_type,
632: fnd_api.g_miss_char, NULL,
628: fnd_api.g_miss_char, NULL,
629: x_phone_extension),
630: phone_line_type = DECODE(x_phone_line_type,
631: NULL, phone_line_type,
632: fnd_api.g_miss_char, NULL,
633: x_phone_line_type),
634: telex_number = DECODE(x_telex_number,
635: NULL, telex_number,
636: fnd_api.g_miss_char, NULL,
632: fnd_api.g_miss_char, NULL,
633: x_phone_line_type),
634: telex_number = DECODE(x_telex_number,
635: NULL, telex_number,
636: fnd_api.g_miss_char, NULL,
637: x_telex_number),
638: web_type = DECODE(x_web_type,
639: NULL, web_type,
640: fnd_api.g_miss_char, NULL,
636: fnd_api.g_miss_char, NULL,
637: x_telex_number),
638: web_type = DECODE(x_web_type,
639: NULL, web_type,
640: fnd_api.g_miss_char, NULL,
641: x_web_type),
642: url = DECODE(x_url,
643: NULL, url,
644: fnd_api.g_miss_char, NULL,
640: fnd_api.g_miss_char, NULL,
641: x_web_type),
642: url = DECODE(x_url,
643: NULL, url,
644: fnd_api.g_miss_char, NULL,
645: x_url),
646: content_source_type = DECODE(x_content_source_type,
647: NULL, content_source_type,
648: fnd_api.g_miss_char, NULL,
644: fnd_api.g_miss_char, NULL,
645: x_url),
646: content_source_type = DECODE(x_content_source_type,
647: NULL, content_source_type,
648: fnd_api.g_miss_char, NULL,
649: x_content_source_type),
650: raw_phone_number = DECODE(x_raw_phone_number,
651: NULL, raw_phone_number,
652: fnd_api.g_miss_char, NULL,
648: fnd_api.g_miss_char, NULL,
649: x_content_source_type),
650: raw_phone_number = DECODE(x_raw_phone_number,
651: NULL, raw_phone_number,
652: fnd_api.g_miss_char, NULL,
653: x_raw_phone_number),
654: object_version_number = DECODE(x_object_version_number,
655: NULL, object_version_number,
656: fnd_api.g_miss_num, NULL,
652: fnd_api.g_miss_char, NULL,
653: x_raw_phone_number),
654: object_version_number = DECODE(x_object_version_number,
655: NULL, object_version_number,
656: fnd_api.g_miss_num, NULL,
657: x_object_version_number),
658: contact_point_purpose = DECODE(x_contact_point_purpose,
659: NULL, contact_point_purpose,
660: fnd_api.g_miss_char, NULL,
656: fnd_api.g_miss_num, NULL,
657: x_object_version_number),
658: contact_point_purpose = DECODE(x_contact_point_purpose,
659: NULL, contact_point_purpose,
660: fnd_api.g_miss_char, NULL,
661: x_contact_point_purpose),
662: primary_by_purpose = DECODE(x_primary_by_purpose,
663: NULL, primary_by_purpose,
664: fnd_api.g_miss_char, 'N',
660: fnd_api.g_miss_char, NULL,
661: x_contact_point_purpose),
662: primary_by_purpose = DECODE(x_primary_by_purpose,
663: NULL, primary_by_purpose,
664: fnd_api.g_miss_char, 'N',
665: x_primary_by_purpose),
666: created_by_module = DECODE(x_created_by_module,
667: NULL, created_by_module,
668: fnd_api.g_miss_char, NULL,
664: fnd_api.g_miss_char, 'N',
665: x_primary_by_purpose),
666: created_by_module = DECODE(x_created_by_module,
667: NULL, created_by_module,
668: fnd_api.g_miss_char, NULL,
669: x_created_by_module),
670: application_id = DECODE(x_application_id,
671: NULL, application_id,
672: fnd_api.g_miss_num, NULL,
668: fnd_api.g_miss_char, NULL,
669: x_created_by_module),
670: application_id = DECODE(x_application_id,
671: NULL, application_id,
672: fnd_api.g_miss_num, NULL,
673: x_application_id),
674: transposed_phone_number = DECODE(x_transposed_phone_number,
675: NULL, transposed_phone_number,
676: fnd_api.g_miss_char, NULL,
672: fnd_api.g_miss_num, NULL,
673: x_application_id),
674: transposed_phone_number = DECODE(x_transposed_phone_number,
675: NULL, transposed_phone_number,
676: fnd_api.g_miss_char, NULL,
677: x_transposed_phone_number),
678: actual_content_source = DECODE(x_actual_content_source,
679: NULL, actual_content_source,
680: fnd_api.g_miss_char, NULL,
676: fnd_api.g_miss_char, NULL,
677: x_transposed_phone_number),
678: actual_content_source = DECODE(x_actual_content_source,
679: NULL, actual_content_source,
680: fnd_api.g_miss_char, NULL,
681: x_actual_content_source)
682: WHERE ROWID = x_rowid;
683:
684: IF (SQL%NOTFOUND) THEN
1067: x_actual_content_source OUT NOCOPY VARCHAR2
1068: ) IS
1069:
1070: CURSOR c_cp IS
1071: SELECT NVL(contact_point_id, fnd_api.g_miss_num),
1072: NVL(contact_point_type, fnd_api.g_miss_char),
1073: NVL(status, fnd_api.g_miss_char),
1074: NVL(owner_table_name, fnd_api.g_miss_char),
1075: NVL(owner_table_id, fnd_api.g_miss_num),
1068: ) IS
1069:
1070: CURSOR c_cp IS
1071: SELECT NVL(contact_point_id, fnd_api.g_miss_num),
1072: NVL(contact_point_type, fnd_api.g_miss_char),
1073: NVL(status, fnd_api.g_miss_char),
1074: NVL(owner_table_name, fnd_api.g_miss_char),
1075: NVL(owner_table_id, fnd_api.g_miss_num),
1076: NVL(primary_flag, fnd_api.g_miss_char),
1069:
1070: CURSOR c_cp IS
1071: SELECT NVL(contact_point_id, fnd_api.g_miss_num),
1072: NVL(contact_point_type, fnd_api.g_miss_char),
1073: NVL(status, fnd_api.g_miss_char),
1074: NVL(owner_table_name, fnd_api.g_miss_char),
1075: NVL(owner_table_id, fnd_api.g_miss_num),
1076: NVL(primary_flag, fnd_api.g_miss_char),
1077: NVL(orig_system_reference, fnd_api.g_miss_char),
1070: CURSOR c_cp IS
1071: SELECT NVL(contact_point_id, fnd_api.g_miss_num),
1072: NVL(contact_point_type, fnd_api.g_miss_char),
1073: NVL(status, fnd_api.g_miss_char),
1074: NVL(owner_table_name, fnd_api.g_miss_char),
1075: NVL(owner_table_id, fnd_api.g_miss_num),
1076: NVL(primary_flag, fnd_api.g_miss_char),
1077: NVL(orig_system_reference, fnd_api.g_miss_char),
1078: NVL(attribute_category, fnd_api.g_miss_char),
1071: SELECT NVL(contact_point_id, fnd_api.g_miss_num),
1072: NVL(contact_point_type, fnd_api.g_miss_char),
1073: NVL(status, fnd_api.g_miss_char),
1074: NVL(owner_table_name, fnd_api.g_miss_char),
1075: NVL(owner_table_id, fnd_api.g_miss_num),
1076: NVL(primary_flag, fnd_api.g_miss_char),
1077: NVL(orig_system_reference, fnd_api.g_miss_char),
1078: NVL(attribute_category, fnd_api.g_miss_char),
1079: NVL(attribute1, fnd_api.g_miss_char),
1072: NVL(contact_point_type, fnd_api.g_miss_char),
1073: NVL(status, fnd_api.g_miss_char),
1074: NVL(owner_table_name, fnd_api.g_miss_char),
1075: NVL(owner_table_id, fnd_api.g_miss_num),
1076: NVL(primary_flag, fnd_api.g_miss_char),
1077: NVL(orig_system_reference, fnd_api.g_miss_char),
1078: NVL(attribute_category, fnd_api.g_miss_char),
1079: NVL(attribute1, fnd_api.g_miss_char),
1080: NVL(attribute2, fnd_api.g_miss_char),
1073: NVL(status, fnd_api.g_miss_char),
1074: NVL(owner_table_name, fnd_api.g_miss_char),
1075: NVL(owner_table_id, fnd_api.g_miss_num),
1076: NVL(primary_flag, fnd_api.g_miss_char),
1077: NVL(orig_system_reference, fnd_api.g_miss_char),
1078: NVL(attribute_category, fnd_api.g_miss_char),
1079: NVL(attribute1, fnd_api.g_miss_char),
1080: NVL(attribute2, fnd_api.g_miss_char),
1081: NVL(attribute3, fnd_api.g_miss_char),
1074: NVL(owner_table_name, fnd_api.g_miss_char),
1075: NVL(owner_table_id, fnd_api.g_miss_num),
1076: NVL(primary_flag, fnd_api.g_miss_char),
1077: NVL(orig_system_reference, fnd_api.g_miss_char),
1078: NVL(attribute_category, fnd_api.g_miss_char),
1079: NVL(attribute1, fnd_api.g_miss_char),
1080: NVL(attribute2, fnd_api.g_miss_char),
1081: NVL(attribute3, fnd_api.g_miss_char),
1082: NVL(attribute4, fnd_api.g_miss_char),
1075: NVL(owner_table_id, fnd_api.g_miss_num),
1076: NVL(primary_flag, fnd_api.g_miss_char),
1077: NVL(orig_system_reference, fnd_api.g_miss_char),
1078: NVL(attribute_category, fnd_api.g_miss_char),
1079: NVL(attribute1, fnd_api.g_miss_char),
1080: NVL(attribute2, fnd_api.g_miss_char),
1081: NVL(attribute3, fnd_api.g_miss_char),
1082: NVL(attribute4, fnd_api.g_miss_char),
1083: NVL(attribute5, fnd_api.g_miss_char),
1076: NVL(primary_flag, fnd_api.g_miss_char),
1077: NVL(orig_system_reference, fnd_api.g_miss_char),
1078: NVL(attribute_category, fnd_api.g_miss_char),
1079: NVL(attribute1, fnd_api.g_miss_char),
1080: NVL(attribute2, fnd_api.g_miss_char),
1081: NVL(attribute3, fnd_api.g_miss_char),
1082: NVL(attribute4, fnd_api.g_miss_char),
1083: NVL(attribute5, fnd_api.g_miss_char),
1084: NVL(attribute6, fnd_api.g_miss_char),
1077: NVL(orig_system_reference, fnd_api.g_miss_char),
1078: NVL(attribute_category, fnd_api.g_miss_char),
1079: NVL(attribute1, fnd_api.g_miss_char),
1080: NVL(attribute2, fnd_api.g_miss_char),
1081: NVL(attribute3, fnd_api.g_miss_char),
1082: NVL(attribute4, fnd_api.g_miss_char),
1083: NVL(attribute5, fnd_api.g_miss_char),
1084: NVL(attribute6, fnd_api.g_miss_char),
1085: NVL(attribute7, fnd_api.g_miss_char),
1078: NVL(attribute_category, fnd_api.g_miss_char),
1079: NVL(attribute1, fnd_api.g_miss_char),
1080: NVL(attribute2, fnd_api.g_miss_char),
1081: NVL(attribute3, fnd_api.g_miss_char),
1082: NVL(attribute4, fnd_api.g_miss_char),
1083: NVL(attribute5, fnd_api.g_miss_char),
1084: NVL(attribute6, fnd_api.g_miss_char),
1085: NVL(attribute7, fnd_api.g_miss_char),
1086: NVL(attribute8, fnd_api.g_miss_char),
1079: NVL(attribute1, fnd_api.g_miss_char),
1080: NVL(attribute2, fnd_api.g_miss_char),
1081: NVL(attribute3, fnd_api.g_miss_char),
1082: NVL(attribute4, fnd_api.g_miss_char),
1083: NVL(attribute5, fnd_api.g_miss_char),
1084: NVL(attribute6, fnd_api.g_miss_char),
1085: NVL(attribute7, fnd_api.g_miss_char),
1086: NVL(attribute8, fnd_api.g_miss_char),
1087: NVL(attribute9, fnd_api.g_miss_char),
1080: NVL(attribute2, fnd_api.g_miss_char),
1081: NVL(attribute3, fnd_api.g_miss_char),
1082: NVL(attribute4, fnd_api.g_miss_char),
1083: NVL(attribute5, fnd_api.g_miss_char),
1084: NVL(attribute6, fnd_api.g_miss_char),
1085: NVL(attribute7, fnd_api.g_miss_char),
1086: NVL(attribute8, fnd_api.g_miss_char),
1087: NVL(attribute9, fnd_api.g_miss_char),
1088: NVL(attribute10, fnd_api.g_miss_char),
1081: NVL(attribute3, fnd_api.g_miss_char),
1082: NVL(attribute4, fnd_api.g_miss_char),
1083: NVL(attribute5, fnd_api.g_miss_char),
1084: NVL(attribute6, fnd_api.g_miss_char),
1085: NVL(attribute7, fnd_api.g_miss_char),
1086: NVL(attribute8, fnd_api.g_miss_char),
1087: NVL(attribute9, fnd_api.g_miss_char),
1088: NVL(attribute10, fnd_api.g_miss_char),
1089: NVL(attribute11, fnd_api.g_miss_char),
1082: NVL(attribute4, fnd_api.g_miss_char),
1083: NVL(attribute5, fnd_api.g_miss_char),
1084: NVL(attribute6, fnd_api.g_miss_char),
1085: NVL(attribute7, fnd_api.g_miss_char),
1086: NVL(attribute8, fnd_api.g_miss_char),
1087: NVL(attribute9, fnd_api.g_miss_char),
1088: NVL(attribute10, fnd_api.g_miss_char),
1089: NVL(attribute11, fnd_api.g_miss_char),
1090: NVL(attribute12, fnd_api.g_miss_char),
1083: NVL(attribute5, fnd_api.g_miss_char),
1084: NVL(attribute6, fnd_api.g_miss_char),
1085: NVL(attribute7, fnd_api.g_miss_char),
1086: NVL(attribute8, fnd_api.g_miss_char),
1087: NVL(attribute9, fnd_api.g_miss_char),
1088: NVL(attribute10, fnd_api.g_miss_char),
1089: NVL(attribute11, fnd_api.g_miss_char),
1090: NVL(attribute12, fnd_api.g_miss_char),
1091: NVL(attribute13, fnd_api.g_miss_char),
1084: NVL(attribute6, fnd_api.g_miss_char),
1085: NVL(attribute7, fnd_api.g_miss_char),
1086: NVL(attribute8, fnd_api.g_miss_char),
1087: NVL(attribute9, fnd_api.g_miss_char),
1088: NVL(attribute10, fnd_api.g_miss_char),
1089: NVL(attribute11, fnd_api.g_miss_char),
1090: NVL(attribute12, fnd_api.g_miss_char),
1091: NVL(attribute13, fnd_api.g_miss_char),
1092: NVL(attribute14, fnd_api.g_miss_char),
1085: NVL(attribute7, fnd_api.g_miss_char),
1086: NVL(attribute8, fnd_api.g_miss_char),
1087: NVL(attribute9, fnd_api.g_miss_char),
1088: NVL(attribute10, fnd_api.g_miss_char),
1089: NVL(attribute11, fnd_api.g_miss_char),
1090: NVL(attribute12, fnd_api.g_miss_char),
1091: NVL(attribute13, fnd_api.g_miss_char),
1092: NVL(attribute14, fnd_api.g_miss_char),
1093: NVL(attribute15, fnd_api.g_miss_char),
1086: NVL(attribute8, fnd_api.g_miss_char),
1087: NVL(attribute9, fnd_api.g_miss_char),
1088: NVL(attribute10, fnd_api.g_miss_char),
1089: NVL(attribute11, fnd_api.g_miss_char),
1090: NVL(attribute12, fnd_api.g_miss_char),
1091: NVL(attribute13, fnd_api.g_miss_char),
1092: NVL(attribute14, fnd_api.g_miss_char),
1093: NVL(attribute15, fnd_api.g_miss_char),
1094: NVL(attribute16, fnd_api.g_miss_char),
1087: NVL(attribute9, fnd_api.g_miss_char),
1088: NVL(attribute10, fnd_api.g_miss_char),
1089: NVL(attribute11, fnd_api.g_miss_char),
1090: NVL(attribute12, fnd_api.g_miss_char),
1091: NVL(attribute13, fnd_api.g_miss_char),
1092: NVL(attribute14, fnd_api.g_miss_char),
1093: NVL(attribute15, fnd_api.g_miss_char),
1094: NVL(attribute16, fnd_api.g_miss_char),
1095: NVL(attribute17, fnd_api.g_miss_char),
1088: NVL(attribute10, fnd_api.g_miss_char),
1089: NVL(attribute11, fnd_api.g_miss_char),
1090: NVL(attribute12, fnd_api.g_miss_char),
1091: NVL(attribute13, fnd_api.g_miss_char),
1092: NVL(attribute14, fnd_api.g_miss_char),
1093: NVL(attribute15, fnd_api.g_miss_char),
1094: NVL(attribute16, fnd_api.g_miss_char),
1095: NVL(attribute17, fnd_api.g_miss_char),
1096: NVL(attribute18, fnd_api.g_miss_char),
1089: NVL(attribute11, fnd_api.g_miss_char),
1090: NVL(attribute12, fnd_api.g_miss_char),
1091: NVL(attribute13, fnd_api.g_miss_char),
1092: NVL(attribute14, fnd_api.g_miss_char),
1093: NVL(attribute15, fnd_api.g_miss_char),
1094: NVL(attribute16, fnd_api.g_miss_char),
1095: NVL(attribute17, fnd_api.g_miss_char),
1096: NVL(attribute18, fnd_api.g_miss_char),
1097: NVL(attribute19, fnd_api.g_miss_char),
1090: NVL(attribute12, fnd_api.g_miss_char),
1091: NVL(attribute13, fnd_api.g_miss_char),
1092: NVL(attribute14, fnd_api.g_miss_char),
1093: NVL(attribute15, fnd_api.g_miss_char),
1094: NVL(attribute16, fnd_api.g_miss_char),
1095: NVL(attribute17, fnd_api.g_miss_char),
1096: NVL(attribute18, fnd_api.g_miss_char),
1097: NVL(attribute19, fnd_api.g_miss_char),
1098: NVL(attribute20, fnd_api.g_miss_char),
1091: NVL(attribute13, fnd_api.g_miss_char),
1092: NVL(attribute14, fnd_api.g_miss_char),
1093: NVL(attribute15, fnd_api.g_miss_char),
1094: NVL(attribute16, fnd_api.g_miss_char),
1095: NVL(attribute17, fnd_api.g_miss_char),
1096: NVL(attribute18, fnd_api.g_miss_char),
1097: NVL(attribute19, fnd_api.g_miss_char),
1098: NVL(attribute20, fnd_api.g_miss_char),
1099: NVL(edi_transaction_handling, fnd_api.g_miss_char),
1092: NVL(attribute14, fnd_api.g_miss_char),
1093: NVL(attribute15, fnd_api.g_miss_char),
1094: NVL(attribute16, fnd_api.g_miss_char),
1095: NVL(attribute17, fnd_api.g_miss_char),
1096: NVL(attribute18, fnd_api.g_miss_char),
1097: NVL(attribute19, fnd_api.g_miss_char),
1098: NVL(attribute20, fnd_api.g_miss_char),
1099: NVL(edi_transaction_handling, fnd_api.g_miss_char),
1100: NVL(edi_id_number, fnd_api.g_miss_char),
1093: NVL(attribute15, fnd_api.g_miss_char),
1094: NVL(attribute16, fnd_api.g_miss_char),
1095: NVL(attribute17, fnd_api.g_miss_char),
1096: NVL(attribute18, fnd_api.g_miss_char),
1097: NVL(attribute19, fnd_api.g_miss_char),
1098: NVL(attribute20, fnd_api.g_miss_char),
1099: NVL(edi_transaction_handling, fnd_api.g_miss_char),
1100: NVL(edi_id_number, fnd_api.g_miss_char),
1101: NVL(edi_payment_method, fnd_api.g_miss_char),
1094: NVL(attribute16, fnd_api.g_miss_char),
1095: NVL(attribute17, fnd_api.g_miss_char),
1096: NVL(attribute18, fnd_api.g_miss_char),
1097: NVL(attribute19, fnd_api.g_miss_char),
1098: NVL(attribute20, fnd_api.g_miss_char),
1099: NVL(edi_transaction_handling, fnd_api.g_miss_char),
1100: NVL(edi_id_number, fnd_api.g_miss_char),
1101: NVL(edi_payment_method, fnd_api.g_miss_char),
1102: NVL(edi_payment_format, fnd_api.g_miss_char),
1095: NVL(attribute17, fnd_api.g_miss_char),
1096: NVL(attribute18, fnd_api.g_miss_char),
1097: NVL(attribute19, fnd_api.g_miss_char),
1098: NVL(attribute20, fnd_api.g_miss_char),
1099: NVL(edi_transaction_handling, fnd_api.g_miss_char),
1100: NVL(edi_id_number, fnd_api.g_miss_char),
1101: NVL(edi_payment_method, fnd_api.g_miss_char),
1102: NVL(edi_payment_format, fnd_api.g_miss_char),
1103: NVL(edi_remittance_method, fnd_api.g_miss_char),
1096: NVL(attribute18, fnd_api.g_miss_char),
1097: NVL(attribute19, fnd_api.g_miss_char),
1098: NVL(attribute20, fnd_api.g_miss_char),
1099: NVL(edi_transaction_handling, fnd_api.g_miss_char),
1100: NVL(edi_id_number, fnd_api.g_miss_char),
1101: NVL(edi_payment_method, fnd_api.g_miss_char),
1102: NVL(edi_payment_format, fnd_api.g_miss_char),
1103: NVL(edi_remittance_method, fnd_api.g_miss_char),
1104: NVL(edi_remittance_instruction, fnd_api.g_miss_char),
1097: NVL(attribute19, fnd_api.g_miss_char),
1098: NVL(attribute20, fnd_api.g_miss_char),
1099: NVL(edi_transaction_handling, fnd_api.g_miss_char),
1100: NVL(edi_id_number, fnd_api.g_miss_char),
1101: NVL(edi_payment_method, fnd_api.g_miss_char),
1102: NVL(edi_payment_format, fnd_api.g_miss_char),
1103: NVL(edi_remittance_method, fnd_api.g_miss_char),
1104: NVL(edi_remittance_instruction, fnd_api.g_miss_char),
1105: NVL(edi_tp_header_id, fnd_api.g_miss_num),
1098: NVL(attribute20, fnd_api.g_miss_char),
1099: NVL(edi_transaction_handling, fnd_api.g_miss_char),
1100: NVL(edi_id_number, fnd_api.g_miss_char),
1101: NVL(edi_payment_method, fnd_api.g_miss_char),
1102: NVL(edi_payment_format, fnd_api.g_miss_char),
1103: NVL(edi_remittance_method, fnd_api.g_miss_char),
1104: NVL(edi_remittance_instruction, fnd_api.g_miss_char),
1105: NVL(edi_tp_header_id, fnd_api.g_miss_num),
1106: NVL(edi_ece_tp_location_code, fnd_api.g_miss_char),
1099: NVL(edi_transaction_handling, fnd_api.g_miss_char),
1100: NVL(edi_id_number, fnd_api.g_miss_char),
1101: NVL(edi_payment_method, fnd_api.g_miss_char),
1102: NVL(edi_payment_format, fnd_api.g_miss_char),
1103: NVL(edi_remittance_method, fnd_api.g_miss_char),
1104: NVL(edi_remittance_instruction, fnd_api.g_miss_char),
1105: NVL(edi_tp_header_id, fnd_api.g_miss_num),
1106: NVL(edi_ece_tp_location_code, fnd_api.g_miss_char),
1107: NVL(x_eft_transmission_program_id, fnd_api.g_miss_num),
1100: NVL(edi_id_number, fnd_api.g_miss_char),
1101: NVL(edi_payment_method, fnd_api.g_miss_char),
1102: NVL(edi_payment_format, fnd_api.g_miss_char),
1103: NVL(edi_remittance_method, fnd_api.g_miss_char),
1104: NVL(edi_remittance_instruction, fnd_api.g_miss_char),
1105: NVL(edi_tp_header_id, fnd_api.g_miss_num),
1106: NVL(edi_ece_tp_location_code, fnd_api.g_miss_char),
1107: NVL(x_eft_transmission_program_id, fnd_api.g_miss_num),
1108: NVL(x_eft_printing_program_id, fnd_api.g_miss_num),
1101: NVL(edi_payment_method, fnd_api.g_miss_char),
1102: NVL(edi_payment_format, fnd_api.g_miss_char),
1103: NVL(edi_remittance_method, fnd_api.g_miss_char),
1104: NVL(edi_remittance_instruction, fnd_api.g_miss_char),
1105: NVL(edi_tp_header_id, fnd_api.g_miss_num),
1106: NVL(edi_ece_tp_location_code, fnd_api.g_miss_char),
1107: NVL(x_eft_transmission_program_id, fnd_api.g_miss_num),
1108: NVL(x_eft_printing_program_id, fnd_api.g_miss_num),
1109: NVL(x_eft_user_number, fnd_api.g_miss_char),
1102: NVL(edi_payment_format, fnd_api.g_miss_char),
1103: NVL(edi_remittance_method, fnd_api.g_miss_char),
1104: NVL(edi_remittance_instruction, fnd_api.g_miss_char),
1105: NVL(edi_tp_header_id, fnd_api.g_miss_num),
1106: NVL(edi_ece_tp_location_code, fnd_api.g_miss_char),
1107: NVL(x_eft_transmission_program_id, fnd_api.g_miss_num),
1108: NVL(x_eft_printing_program_id, fnd_api.g_miss_num),
1109: NVL(x_eft_user_number, fnd_api.g_miss_char),
1110: NVL(x_eft_swift_code, fnd_api.g_miss_char),
1103: NVL(edi_remittance_method, fnd_api.g_miss_char),
1104: NVL(edi_remittance_instruction, fnd_api.g_miss_char),
1105: NVL(edi_tp_header_id, fnd_api.g_miss_num),
1106: NVL(edi_ece_tp_location_code, fnd_api.g_miss_char),
1107: NVL(x_eft_transmission_program_id, fnd_api.g_miss_num),
1108: NVL(x_eft_printing_program_id, fnd_api.g_miss_num),
1109: NVL(x_eft_user_number, fnd_api.g_miss_char),
1110: NVL(x_eft_swift_code, fnd_api.g_miss_char),
1111: NVL(email_format, fnd_api.g_miss_char),
1104: NVL(edi_remittance_instruction, fnd_api.g_miss_char),
1105: NVL(edi_tp_header_id, fnd_api.g_miss_num),
1106: NVL(edi_ece_tp_location_code, fnd_api.g_miss_char),
1107: NVL(x_eft_transmission_program_id, fnd_api.g_miss_num),
1108: NVL(x_eft_printing_program_id, fnd_api.g_miss_num),
1109: NVL(x_eft_user_number, fnd_api.g_miss_char),
1110: NVL(x_eft_swift_code, fnd_api.g_miss_char),
1111: NVL(email_format, fnd_api.g_miss_char),
1112: NVL(email_address, fnd_api.g_miss_char),
1105: NVL(edi_tp_header_id, fnd_api.g_miss_num),
1106: NVL(edi_ece_tp_location_code, fnd_api.g_miss_char),
1107: NVL(x_eft_transmission_program_id, fnd_api.g_miss_num),
1108: NVL(x_eft_printing_program_id, fnd_api.g_miss_num),
1109: NVL(x_eft_user_number, fnd_api.g_miss_char),
1110: NVL(x_eft_swift_code, fnd_api.g_miss_char),
1111: NVL(email_format, fnd_api.g_miss_char),
1112: NVL(email_address, fnd_api.g_miss_char),
1113: NVL(phone_calling_calendar, fnd_api.g_miss_char),
1106: NVL(edi_ece_tp_location_code, fnd_api.g_miss_char),
1107: NVL(x_eft_transmission_program_id, fnd_api.g_miss_num),
1108: NVL(x_eft_printing_program_id, fnd_api.g_miss_num),
1109: NVL(x_eft_user_number, fnd_api.g_miss_char),
1110: NVL(x_eft_swift_code, fnd_api.g_miss_char),
1111: NVL(email_format, fnd_api.g_miss_char),
1112: NVL(email_address, fnd_api.g_miss_char),
1113: NVL(phone_calling_calendar, fnd_api.g_miss_char),
1114: NVL(last_contact_dt_time, fnd_api.g_miss_date),
1107: NVL(x_eft_transmission_program_id, fnd_api.g_miss_num),
1108: NVL(x_eft_printing_program_id, fnd_api.g_miss_num),
1109: NVL(x_eft_user_number, fnd_api.g_miss_char),
1110: NVL(x_eft_swift_code, fnd_api.g_miss_char),
1111: NVL(email_format, fnd_api.g_miss_char),
1112: NVL(email_address, fnd_api.g_miss_char),
1113: NVL(phone_calling_calendar, fnd_api.g_miss_char),
1114: NVL(last_contact_dt_time, fnd_api.g_miss_date),
1115: NVL(timezone_id, fnd_api.g_miss_num),
1108: NVL(x_eft_printing_program_id, fnd_api.g_miss_num),
1109: NVL(x_eft_user_number, fnd_api.g_miss_char),
1110: NVL(x_eft_swift_code, fnd_api.g_miss_char),
1111: NVL(email_format, fnd_api.g_miss_char),
1112: NVL(email_address, fnd_api.g_miss_char),
1113: NVL(phone_calling_calendar, fnd_api.g_miss_char),
1114: NVL(last_contact_dt_time, fnd_api.g_miss_date),
1115: NVL(timezone_id, fnd_api.g_miss_num),
1116: NVL(phone_area_code, fnd_api.g_miss_char),
1109: NVL(x_eft_user_number, fnd_api.g_miss_char),
1110: NVL(x_eft_swift_code, fnd_api.g_miss_char),
1111: NVL(email_format, fnd_api.g_miss_char),
1112: NVL(email_address, fnd_api.g_miss_char),
1113: NVL(phone_calling_calendar, fnd_api.g_miss_char),
1114: NVL(last_contact_dt_time, fnd_api.g_miss_date),
1115: NVL(timezone_id, fnd_api.g_miss_num),
1116: NVL(phone_area_code, fnd_api.g_miss_char),
1117: NVL(phone_country_code, fnd_api.g_miss_char),
1110: NVL(x_eft_swift_code, fnd_api.g_miss_char),
1111: NVL(email_format, fnd_api.g_miss_char),
1112: NVL(email_address, fnd_api.g_miss_char),
1113: NVL(phone_calling_calendar, fnd_api.g_miss_char),
1114: NVL(last_contact_dt_time, fnd_api.g_miss_date),
1115: NVL(timezone_id, fnd_api.g_miss_num),
1116: NVL(phone_area_code, fnd_api.g_miss_char),
1117: NVL(phone_country_code, fnd_api.g_miss_char),
1118: NVL(phone_number, fnd_api.g_miss_char),
1111: NVL(email_format, fnd_api.g_miss_char),
1112: NVL(email_address, fnd_api.g_miss_char),
1113: NVL(phone_calling_calendar, fnd_api.g_miss_char),
1114: NVL(last_contact_dt_time, fnd_api.g_miss_date),
1115: NVL(timezone_id, fnd_api.g_miss_num),
1116: NVL(phone_area_code, fnd_api.g_miss_char),
1117: NVL(phone_country_code, fnd_api.g_miss_char),
1118: NVL(phone_number, fnd_api.g_miss_char),
1119: NVL(phone_extension, fnd_api.g_miss_char),
1112: NVL(email_address, fnd_api.g_miss_char),
1113: NVL(phone_calling_calendar, fnd_api.g_miss_char),
1114: NVL(last_contact_dt_time, fnd_api.g_miss_date),
1115: NVL(timezone_id, fnd_api.g_miss_num),
1116: NVL(phone_area_code, fnd_api.g_miss_char),
1117: NVL(phone_country_code, fnd_api.g_miss_char),
1118: NVL(phone_number, fnd_api.g_miss_char),
1119: NVL(phone_extension, fnd_api.g_miss_char),
1120: NVL(phone_line_type, fnd_api.g_miss_char),
1113: NVL(phone_calling_calendar, fnd_api.g_miss_char),
1114: NVL(last_contact_dt_time, fnd_api.g_miss_date),
1115: NVL(timezone_id, fnd_api.g_miss_num),
1116: NVL(phone_area_code, fnd_api.g_miss_char),
1117: NVL(phone_country_code, fnd_api.g_miss_char),
1118: NVL(phone_number, fnd_api.g_miss_char),
1119: NVL(phone_extension, fnd_api.g_miss_char),
1120: NVL(phone_line_type, fnd_api.g_miss_char),
1121: NVL(telex_number, fnd_api.g_miss_char),
1114: NVL(last_contact_dt_time, fnd_api.g_miss_date),
1115: NVL(timezone_id, fnd_api.g_miss_num),
1116: NVL(phone_area_code, fnd_api.g_miss_char),
1117: NVL(phone_country_code, fnd_api.g_miss_char),
1118: NVL(phone_number, fnd_api.g_miss_char),
1119: NVL(phone_extension, fnd_api.g_miss_char),
1120: NVL(phone_line_type, fnd_api.g_miss_char),
1121: NVL(telex_number, fnd_api.g_miss_char),
1122: NVL(web_type, fnd_api.g_miss_char),
1115: NVL(timezone_id, fnd_api.g_miss_num),
1116: NVL(phone_area_code, fnd_api.g_miss_char),
1117: NVL(phone_country_code, fnd_api.g_miss_char),
1118: NVL(phone_number, fnd_api.g_miss_char),
1119: NVL(phone_extension, fnd_api.g_miss_char),
1120: NVL(phone_line_type, fnd_api.g_miss_char),
1121: NVL(telex_number, fnd_api.g_miss_char),
1122: NVL(web_type, fnd_api.g_miss_char),
1123: NVL(url, fnd_api.g_miss_char),
1116: NVL(phone_area_code, fnd_api.g_miss_char),
1117: NVL(phone_country_code, fnd_api.g_miss_char),
1118: NVL(phone_number, fnd_api.g_miss_char),
1119: NVL(phone_extension, fnd_api.g_miss_char),
1120: NVL(phone_line_type, fnd_api.g_miss_char),
1121: NVL(telex_number, fnd_api.g_miss_char),
1122: NVL(web_type, fnd_api.g_miss_char),
1123: NVL(url, fnd_api.g_miss_char),
1124: NVL(content_source_type, fnd_api.g_miss_char),
1117: NVL(phone_country_code, fnd_api.g_miss_char),
1118: NVL(phone_number, fnd_api.g_miss_char),
1119: NVL(phone_extension, fnd_api.g_miss_char),
1120: NVL(phone_line_type, fnd_api.g_miss_char),
1121: NVL(telex_number, fnd_api.g_miss_char),
1122: NVL(web_type, fnd_api.g_miss_char),
1123: NVL(url, fnd_api.g_miss_char),
1124: NVL(content_source_type, fnd_api.g_miss_char),
1125: NVL(raw_phone_number, fnd_api.g_miss_char),
1118: NVL(phone_number, fnd_api.g_miss_char),
1119: NVL(phone_extension, fnd_api.g_miss_char),
1120: NVL(phone_line_type, fnd_api.g_miss_char),
1121: NVL(telex_number, fnd_api.g_miss_char),
1122: NVL(web_type, fnd_api.g_miss_char),
1123: NVL(url, fnd_api.g_miss_char),
1124: NVL(content_source_type, fnd_api.g_miss_char),
1125: NVL(raw_phone_number, fnd_api.g_miss_char),
1126: NVL(contact_point_purpose, fnd_api.g_miss_char),
1119: NVL(phone_extension, fnd_api.g_miss_char),
1120: NVL(phone_line_type, fnd_api.g_miss_char),
1121: NVL(telex_number, fnd_api.g_miss_char),
1122: NVL(web_type, fnd_api.g_miss_char),
1123: NVL(url, fnd_api.g_miss_char),
1124: NVL(content_source_type, fnd_api.g_miss_char),
1125: NVL(raw_phone_number, fnd_api.g_miss_char),
1126: NVL(contact_point_purpose, fnd_api.g_miss_char),
1127: NVL(primary_by_purpose, fnd_api.g_miss_char),
1120: NVL(phone_line_type, fnd_api.g_miss_char),
1121: NVL(telex_number, fnd_api.g_miss_char),
1122: NVL(web_type, fnd_api.g_miss_char),
1123: NVL(url, fnd_api.g_miss_char),
1124: NVL(content_source_type, fnd_api.g_miss_char),
1125: NVL(raw_phone_number, fnd_api.g_miss_char),
1126: NVL(contact_point_purpose, fnd_api.g_miss_char),
1127: NVL(primary_by_purpose, fnd_api.g_miss_char),
1128: NVL(created_by_module, fnd_api.g_miss_char),
1121: NVL(telex_number, fnd_api.g_miss_char),
1122: NVL(web_type, fnd_api.g_miss_char),
1123: NVL(url, fnd_api.g_miss_char),
1124: NVL(content_source_type, fnd_api.g_miss_char),
1125: NVL(raw_phone_number, fnd_api.g_miss_char),
1126: NVL(contact_point_purpose, fnd_api.g_miss_char),
1127: NVL(primary_by_purpose, fnd_api.g_miss_char),
1128: NVL(created_by_module, fnd_api.g_miss_char),
1129: NVL(application_id, fnd_api.g_miss_num),
1122: NVL(web_type, fnd_api.g_miss_char),
1123: NVL(url, fnd_api.g_miss_char),
1124: NVL(content_source_type, fnd_api.g_miss_char),
1125: NVL(raw_phone_number, fnd_api.g_miss_char),
1126: NVL(contact_point_purpose, fnd_api.g_miss_char),
1127: NVL(primary_by_purpose, fnd_api.g_miss_char),
1128: NVL(created_by_module, fnd_api.g_miss_char),
1129: NVL(application_id, fnd_api.g_miss_num),
1130: NVL(transposed_phone_number, fnd_api.g_miss_char),
1123: NVL(url, fnd_api.g_miss_char),
1124: NVL(content_source_type, fnd_api.g_miss_char),
1125: NVL(raw_phone_number, fnd_api.g_miss_char),
1126: NVL(contact_point_purpose, fnd_api.g_miss_char),
1127: NVL(primary_by_purpose, fnd_api.g_miss_char),
1128: NVL(created_by_module, fnd_api.g_miss_char),
1129: NVL(application_id, fnd_api.g_miss_num),
1130: NVL(transposed_phone_number, fnd_api.g_miss_char),
1131: NVL(actual_content_source, fnd_api.g_miss_char)
1124: NVL(content_source_type, fnd_api.g_miss_char),
1125: NVL(raw_phone_number, fnd_api.g_miss_char),
1126: NVL(contact_point_purpose, fnd_api.g_miss_char),
1127: NVL(primary_by_purpose, fnd_api.g_miss_char),
1128: NVL(created_by_module, fnd_api.g_miss_char),
1129: NVL(application_id, fnd_api.g_miss_num),
1130: NVL(transposed_phone_number, fnd_api.g_miss_char),
1131: NVL(actual_content_source, fnd_api.g_miss_char)
1132: FROM hz_contact_points
1125: NVL(raw_phone_number, fnd_api.g_miss_char),
1126: NVL(contact_point_purpose, fnd_api.g_miss_char),
1127: NVL(primary_by_purpose, fnd_api.g_miss_char),
1128: NVL(created_by_module, fnd_api.g_miss_char),
1129: NVL(application_id, fnd_api.g_miss_num),
1130: NVL(transposed_phone_number, fnd_api.g_miss_char),
1131: NVL(actual_content_source, fnd_api.g_miss_char)
1132: FROM hz_contact_points
1133: WHERE contact_point_id = x_contact_point_id;
1126: NVL(contact_point_purpose, fnd_api.g_miss_char),
1127: NVL(primary_by_purpose, fnd_api.g_miss_char),
1128: NVL(created_by_module, fnd_api.g_miss_char),
1129: NVL(application_id, fnd_api.g_miss_num),
1130: NVL(transposed_phone_number, fnd_api.g_miss_char),
1131: NVL(actual_content_source, fnd_api.g_miss_char)
1132: FROM hz_contact_points
1133: WHERE contact_point_id = x_contact_point_id;
1134: BEGIN
1127: NVL(primary_by_purpose, fnd_api.g_miss_char),
1128: NVL(created_by_module, fnd_api.g_miss_char),
1129: NVL(application_id, fnd_api.g_miss_num),
1130: NVL(transposed_phone_number, fnd_api.g_miss_char),
1131: NVL(actual_content_source, fnd_api.g_miss_char)
1132: FROM hz_contact_points
1133: WHERE contact_point_id = x_contact_point_id;
1134: BEGIN
1135: OPEN c_cp;
1201: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1202: fnd_message.set_token('RECORD', 'contact_point_rec');
1203: fnd_message.set_token('VALUE', TO_CHAR(x_contact_point_id));
1204: fnd_msg_pub.add;
1205: RAISE fnd_api.g_exc_error;
1206: ELSE
1207: CLOSE c_cp;
1208: END IF;
1209: