83: Decode(x_new_rec.attribute15,
84: fnd_api.g_miss_char, NULL,
85: x_new_rec.attribute15),
86: Decode(x_new_rec.created_by,
87: cn_api.g_miss_id, g_created_by,
88: x_new_rec.created_by),
89: Decode(x_new_rec.creation_date,
90: fnd_api.g_miss_date, g_creation_date,
91: x_new_rec.creation_date),
89: Decode(x_new_rec.creation_date,
90: fnd_api.g_miss_date, g_creation_date,
91: x_new_rec.creation_date),
92: Decode(x_new_rec.last_update_login,
93: cn_api.g_miss_id, g_last_update_login,
94: x_new_rec.last_update_login),
95: Decode(x_new_rec.last_update_date,
96: fnd_api.g_miss_date, g_last_update_date,
97: x_new_rec.last_update_date),
95: Decode(x_new_rec.last_update_date,
96: fnd_api.g_miss_date, g_last_update_date,
97: x_new_rec.last_update_date),
98: Decode(x_new_rec.last_updated_by,
99: cn_api.g_miss_id, g_last_updated_by,
100: x_new_rec.last_updated_by)
101: INTO
102: x_new_rec.end_date,
103: x_new_rec.attribute_category,
210: END IF;
211: CLOSE c;
212: SELECT
213: Decode(x_new_rec.security_profile_id,
214: cn_api.g_miss_id, rec.security_profile_id,
215: x_new_rec.security_profile_id),
216: Decode(x_new_rec.salesrep_id,
217: cn_api.g_miss_id, rec.salesrep_id,
218: x_new_rec.salesrep_id),
213: Decode(x_new_rec.security_profile_id,
214: cn_api.g_miss_id, rec.security_profile_id,
215: x_new_rec.security_profile_id),
216: Decode(x_new_rec.salesrep_id,
217: cn_api.g_miss_id, rec.salesrep_id,
218: x_new_rec.salesrep_id),
219: Decode(x_new_rec.start_date,
220: fnd_api.g_miss_date, rec.start_date,
221: x_new_rec.start_date),
270: Decode(x_new_rec.attribute15,
271: fnd_api.g_miss_char, rec.attribute15,
272: x_new_rec.attribute15),
273: Decode(x_new_rec.last_update_login,
274: cn_api.g_miss_id, g_last_update_login,
275: x_new_rec.last_update_login),
276: Decode(x_new_rec.last_update_date,
277: fnd_api.g_miss_date, g_last_update_date,
278: x_new_rec.last_update_date),
276: Decode(x_new_rec.last_update_date,
277: fnd_api.g_miss_date, g_last_update_date,
278: x_new_rec.last_update_date),
279: Decode(x_new_rec.last_updated_by,
280: cn_api.g_miss_id, g_last_updated_by,
281: x_new_rec.last_updated_by)
282: INTO
283: rec.security_profile_id,
284: rec.salesrep_id,