67:
68: IS
69: CURSOR c2 IS SELECT csi_ii_relationships_h_s.NEXTVAL FROM sys.dual;
70: BEGIN
71: IF (px_relationship_history_id IS NULL) OR (px_relationship_history_id = fnd_api.g_miss_num) THEN
72: OPEN c2;
73: FETCH c2 INTO px_relationship_history_id;
74: CLOSE c2;
75: END IF;
127: last_update_login,
128: object_version_number
129: ) VALUES (
130: px_relationship_history_id,
131: DECODE( p_relationship_id, fnd_api.g_miss_num, NULL, p_relationship_id),
132: DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
133: DECODE( p_old_subject_id, fnd_api.g_miss_num, NULL, p_old_subject_id),
134: DECODE( p_new_subject_id, fnd_api.g_miss_num, NULL, p_new_subject_id),
135: DECODE( p_old_position_reference, fnd_api.g_miss_char, NULL, p_old_position_reference),
128: object_version_number
129: ) VALUES (
130: px_relationship_history_id,
131: DECODE( p_relationship_id, fnd_api.g_miss_num, NULL, p_relationship_id),
132: DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
133: DECODE( p_old_subject_id, fnd_api.g_miss_num, NULL, p_old_subject_id),
134: DECODE( p_new_subject_id, fnd_api.g_miss_num, NULL, p_new_subject_id),
135: DECODE( p_old_position_reference, fnd_api.g_miss_char, NULL, p_old_position_reference),
136: DECODE( p_new_position_reference, fnd_api.g_miss_char, NULL, p_new_position_reference),
129: ) VALUES (
130: px_relationship_history_id,
131: DECODE( p_relationship_id, fnd_api.g_miss_num, NULL, p_relationship_id),
132: DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
133: DECODE( p_old_subject_id, fnd_api.g_miss_num, NULL, p_old_subject_id),
134: DECODE( p_new_subject_id, fnd_api.g_miss_num, NULL, p_new_subject_id),
135: DECODE( p_old_position_reference, fnd_api.g_miss_char, NULL, p_old_position_reference),
136: DECODE( p_new_position_reference, fnd_api.g_miss_char, NULL, p_new_position_reference),
137: DECODE( p_old_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_start_date),
130: px_relationship_history_id,
131: DECODE( p_relationship_id, fnd_api.g_miss_num, NULL, p_relationship_id),
132: DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
133: DECODE( p_old_subject_id, fnd_api.g_miss_num, NULL, p_old_subject_id),
134: DECODE( p_new_subject_id, fnd_api.g_miss_num, NULL, p_new_subject_id),
135: DECODE( p_old_position_reference, fnd_api.g_miss_char, NULL, p_old_position_reference),
136: DECODE( p_new_position_reference, fnd_api.g_miss_char, NULL, p_new_position_reference),
137: DECODE( p_old_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_start_date),
138: DECODE( p_new_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_start_date),
131: DECODE( p_relationship_id, fnd_api.g_miss_num, NULL, p_relationship_id),
132: DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
133: DECODE( p_old_subject_id, fnd_api.g_miss_num, NULL, p_old_subject_id),
134: DECODE( p_new_subject_id, fnd_api.g_miss_num, NULL, p_new_subject_id),
135: DECODE( p_old_position_reference, fnd_api.g_miss_char, NULL, p_old_position_reference),
136: DECODE( p_new_position_reference, fnd_api.g_miss_char, NULL, p_new_position_reference),
137: DECODE( p_old_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_start_date),
138: DECODE( p_new_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_start_date),
139: DECODE( p_old_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_end_date),
132: DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
133: DECODE( p_old_subject_id, fnd_api.g_miss_num, NULL, p_old_subject_id),
134: DECODE( p_new_subject_id, fnd_api.g_miss_num, NULL, p_new_subject_id),
135: DECODE( p_old_position_reference, fnd_api.g_miss_char, NULL, p_old_position_reference),
136: DECODE( p_new_position_reference, fnd_api.g_miss_char, NULL, p_new_position_reference),
137: DECODE( p_old_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_start_date),
138: DECODE( p_new_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_start_date),
139: DECODE( p_old_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_end_date),
140: DECODE( p_new_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_end_date),
133: DECODE( p_old_subject_id, fnd_api.g_miss_num, NULL, p_old_subject_id),
134: DECODE( p_new_subject_id, fnd_api.g_miss_num, NULL, p_new_subject_id),
135: DECODE( p_old_position_reference, fnd_api.g_miss_char, NULL, p_old_position_reference),
136: DECODE( p_new_position_reference, fnd_api.g_miss_char, NULL, p_new_position_reference),
137: DECODE( p_old_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_start_date),
138: DECODE( p_new_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_start_date),
139: DECODE( p_old_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_end_date),
140: DECODE( p_new_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_end_date),
141: DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, NULL, p_old_mandatory_flag),
134: DECODE( p_new_subject_id, fnd_api.g_miss_num, NULL, p_new_subject_id),
135: DECODE( p_old_position_reference, fnd_api.g_miss_char, NULL, p_old_position_reference),
136: DECODE( p_new_position_reference, fnd_api.g_miss_char, NULL, p_new_position_reference),
137: DECODE( p_old_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_start_date),
138: DECODE( p_new_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_start_date),
139: DECODE( p_old_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_end_date),
140: DECODE( p_new_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_end_date),
141: DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, NULL, p_old_mandatory_flag),
142: DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, NULL, p_new_mandatory_flag),
135: DECODE( p_old_position_reference, fnd_api.g_miss_char, NULL, p_old_position_reference),
136: DECODE( p_new_position_reference, fnd_api.g_miss_char, NULL, p_new_position_reference),
137: DECODE( p_old_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_start_date),
138: DECODE( p_new_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_start_date),
139: DECODE( p_old_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_end_date),
140: DECODE( p_new_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_end_date),
141: DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, NULL, p_old_mandatory_flag),
142: DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, NULL, p_new_mandatory_flag),
143: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
136: DECODE( p_new_position_reference, fnd_api.g_miss_char, NULL, p_new_position_reference),
137: DECODE( p_old_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_start_date),
138: DECODE( p_new_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_start_date),
139: DECODE( p_old_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_end_date),
140: DECODE( p_new_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_end_date),
141: DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, NULL, p_old_mandatory_flag),
142: DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, NULL, p_new_mandatory_flag),
143: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
144: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
137: DECODE( p_old_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_start_date),
138: DECODE( p_new_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_start_date),
139: DECODE( p_old_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_end_date),
140: DECODE( p_new_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_end_date),
141: DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, NULL, p_old_mandatory_flag),
142: DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, NULL, p_new_mandatory_flag),
143: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
144: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
145: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
138: DECODE( p_new_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_start_date),
139: DECODE( p_old_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_end_date),
140: DECODE( p_new_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_end_date),
141: DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, NULL, p_old_mandatory_flag),
142: DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, NULL, p_new_mandatory_flag),
143: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
144: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
145: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
146: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
139: DECODE( p_old_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_end_date),
140: DECODE( p_new_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_end_date),
141: DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, NULL, p_old_mandatory_flag),
142: DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, NULL, p_new_mandatory_flag),
143: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
144: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
145: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
146: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
147: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
140: DECODE( p_new_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_end_date),
141: DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, NULL, p_old_mandatory_flag),
142: DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, NULL, p_new_mandatory_flag),
143: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
144: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
145: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
146: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
147: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
148: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
141: DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, NULL, p_old_mandatory_flag),
142: DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, NULL, p_new_mandatory_flag),
143: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
144: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
145: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
146: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
147: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
148: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
149: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
142: DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, NULL, p_new_mandatory_flag),
143: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
144: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
145: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
146: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
147: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
148: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
149: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
150: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
143: DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
144: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
145: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
146: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
147: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
148: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
149: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
150: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
151: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
144: DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
145: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
146: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
147: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
148: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
149: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
150: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
151: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
152: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
145: DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
146: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
147: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
148: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
149: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
150: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
151: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
152: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
153: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
146: DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
147: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
148: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
149: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
150: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
151: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
152: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
153: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
154: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
147: DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
148: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
149: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
150: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
151: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
152: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
153: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
154: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
155: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
148: DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
149: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
150: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
151: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
152: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
153: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
154: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
155: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
156: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
149: DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
150: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
151: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
152: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
153: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
154: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
155: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
156: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
157: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
150: DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
151: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
152: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
153: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
154: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
155: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
156: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
157: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
158: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
151: DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
152: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
153: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
154: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
155: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
156: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
157: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
158: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
159: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
152: DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
153: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
154: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
155: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
156: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
157: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
158: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
159: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
160: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
153: DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
154: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
155: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
156: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
157: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
158: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
159: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
160: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
161: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
154: DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
155: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
156: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
157: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
158: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
159: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
160: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
161: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
162: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
155: DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
156: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
157: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
158: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
159: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
160: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
161: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
162: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
163: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
156: DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
157: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
158: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
159: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
160: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
161: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
162: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
163: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
164: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
157: DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
158: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
159: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
160: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
161: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
162: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
163: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
164: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
165: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
158: DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
159: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
160: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
161: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
162: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
163: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
164: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
165: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
166: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
159: DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
160: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
161: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
162: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
163: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
164: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
165: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
166: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
167: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
160: DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
161: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
162: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
163: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
164: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
165: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
166: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
167: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
168: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
161: DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
162: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
163: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
164: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
165: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
166: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
167: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
168: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
169: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
162: DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
163: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
164: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
165: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
166: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
167: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
168: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
169: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
170: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
163: DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
164: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
165: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
166: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
167: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
168: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
169: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
170: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
171: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
164: DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
165: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
166: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
167: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
168: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
169: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
170: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
171: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
172: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
165: DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
166: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
167: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
168: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
169: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
170: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
171: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
172: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
173: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
166: DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
167: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
168: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
169: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
170: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
171: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
172: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
173: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
174: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
167: DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
168: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
169: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
170: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
171: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
172: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
173: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
174: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
175: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
168: DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
169: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
170: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
171: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
172: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
173: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
174: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
175: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
176: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
169: DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
170: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
171: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
172: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
173: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
174: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
175: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
176: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
177: DECODE( p_creation_date, fnd_api.g_miss_date, TO_DATE(NULL), p_creation_date),
170: DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
171: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
172: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
173: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
174: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
175: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
176: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
177: DECODE( p_creation_date, fnd_api.g_miss_date, TO_DATE(NULL), p_creation_date),
178: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
171: DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
172: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
173: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
174: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
175: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
176: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
177: DECODE( p_creation_date, fnd_api.g_miss_date, TO_DATE(NULL), p_creation_date),
178: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
179: DECODE( p_last_update_date, fnd_api.g_miss_date, TO_DATE(NULL), p_last_update_date),
172: DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
173: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
174: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
175: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
176: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
177: DECODE( p_creation_date, fnd_api.g_miss_date, TO_DATE(NULL), p_creation_date),
178: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
179: DECODE( p_last_update_date, fnd_api.g_miss_date, TO_DATE(NULL), p_last_update_date),
180: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
173: DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
174: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
175: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
176: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
177: DECODE( p_creation_date, fnd_api.g_miss_date, TO_DATE(NULL), p_creation_date),
178: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
179: DECODE( p_last_update_date, fnd_api.g_miss_date, TO_DATE(NULL), p_last_update_date),
180: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
181: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
174: DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
175: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
176: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
177: DECODE( p_creation_date, fnd_api.g_miss_date, TO_DATE(NULL), p_creation_date),
178: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
179: DECODE( p_last_update_date, fnd_api.g_miss_date, TO_DATE(NULL), p_last_update_date),
180: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
181: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
182: END insert_row;
175: DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
176: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
177: DECODE( p_creation_date, fnd_api.g_miss_date, TO_DATE(NULL), p_creation_date),
178: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
179: DECODE( p_last_update_date, fnd_api.g_miss_date, TO_DATE(NULL), p_last_update_date),
180: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
181: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
182: END insert_row;
183:
176: DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
177: DECODE( p_creation_date, fnd_api.g_miss_date, TO_DATE(NULL), p_creation_date),
178: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
179: DECODE( p_last_update_date, fnd_api.g_miss_date, TO_DATE(NULL), p_last_update_date),
180: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
181: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
182: END insert_row;
183:
184:
177: DECODE( p_creation_date, fnd_api.g_miss_date, TO_DATE(NULL), p_creation_date),
178: DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
179: DECODE( p_last_update_date, fnd_api.g_miss_date, TO_DATE(NULL), p_last_update_date),
180: DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
181: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
182: END insert_row;
183:
184:
185: PROCEDURE update_row(
239: IS
240: BEGIN
241: UPDATE csi_ii_relationships_h
242: SET
243: relationship_id = DECODE( p_relationship_id, fnd_api.g_miss_num, relationship_id, p_relationship_id),
244: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
245: old_subject_id = DECODE( p_old_subject_id, fnd_api.g_miss_num, old_subject_id, p_old_subject_id),
246: new_subject_id = DECODE( p_new_subject_id, fnd_api.g_miss_num, new_subject_id, p_new_subject_id),
247: old_position_reference = DECODE( p_old_position_reference, fnd_api.g_miss_char, old_position_reference, p_old_position_reference),
240: BEGIN
241: UPDATE csi_ii_relationships_h
242: SET
243: relationship_id = DECODE( p_relationship_id, fnd_api.g_miss_num, relationship_id, p_relationship_id),
244: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
245: old_subject_id = DECODE( p_old_subject_id, fnd_api.g_miss_num, old_subject_id, p_old_subject_id),
246: new_subject_id = DECODE( p_new_subject_id, fnd_api.g_miss_num, new_subject_id, p_new_subject_id),
247: old_position_reference = DECODE( p_old_position_reference, fnd_api.g_miss_char, old_position_reference, p_old_position_reference),
248: new_position_reference = DECODE( p_new_position_reference, fnd_api.g_miss_char, new_position_reference, p_new_position_reference),
241: UPDATE csi_ii_relationships_h
242: SET
243: relationship_id = DECODE( p_relationship_id, fnd_api.g_miss_num, relationship_id, p_relationship_id),
244: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
245: old_subject_id = DECODE( p_old_subject_id, fnd_api.g_miss_num, old_subject_id, p_old_subject_id),
246: new_subject_id = DECODE( p_new_subject_id, fnd_api.g_miss_num, new_subject_id, p_new_subject_id),
247: old_position_reference = DECODE( p_old_position_reference, fnd_api.g_miss_char, old_position_reference, p_old_position_reference),
248: new_position_reference = DECODE( p_new_position_reference, fnd_api.g_miss_char, new_position_reference, p_new_position_reference),
249: old_active_start_date = DECODE( p_old_active_start_date, fnd_api.g_miss_date, old_active_start_date, p_old_active_start_date),
242: SET
243: relationship_id = DECODE( p_relationship_id, fnd_api.g_miss_num, relationship_id, p_relationship_id),
244: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
245: old_subject_id = DECODE( p_old_subject_id, fnd_api.g_miss_num, old_subject_id, p_old_subject_id),
246: new_subject_id = DECODE( p_new_subject_id, fnd_api.g_miss_num, new_subject_id, p_new_subject_id),
247: old_position_reference = DECODE( p_old_position_reference, fnd_api.g_miss_char, old_position_reference, p_old_position_reference),
248: new_position_reference = DECODE( p_new_position_reference, fnd_api.g_miss_char, new_position_reference, p_new_position_reference),
249: old_active_start_date = DECODE( p_old_active_start_date, fnd_api.g_miss_date, old_active_start_date, p_old_active_start_date),
250: new_active_start_date = DECODE( p_new_active_start_date, fnd_api.g_miss_date, new_active_start_date, p_new_active_start_date),
243: relationship_id = DECODE( p_relationship_id, fnd_api.g_miss_num, relationship_id, p_relationship_id),
244: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
245: old_subject_id = DECODE( p_old_subject_id, fnd_api.g_miss_num, old_subject_id, p_old_subject_id),
246: new_subject_id = DECODE( p_new_subject_id, fnd_api.g_miss_num, new_subject_id, p_new_subject_id),
247: old_position_reference = DECODE( p_old_position_reference, fnd_api.g_miss_char, old_position_reference, p_old_position_reference),
248: new_position_reference = DECODE( p_new_position_reference, fnd_api.g_miss_char, new_position_reference, p_new_position_reference),
249: old_active_start_date = DECODE( p_old_active_start_date, fnd_api.g_miss_date, old_active_start_date, p_old_active_start_date),
250: new_active_start_date = DECODE( p_new_active_start_date, fnd_api.g_miss_date, new_active_start_date, p_new_active_start_date),
251: old_active_end_date = DECODE( p_old_active_end_date, fnd_api.g_miss_date, old_active_end_date, p_old_active_end_date),
244: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
245: old_subject_id = DECODE( p_old_subject_id, fnd_api.g_miss_num, old_subject_id, p_old_subject_id),
246: new_subject_id = DECODE( p_new_subject_id, fnd_api.g_miss_num, new_subject_id, p_new_subject_id),
247: old_position_reference = DECODE( p_old_position_reference, fnd_api.g_miss_char, old_position_reference, p_old_position_reference),
248: new_position_reference = DECODE( p_new_position_reference, fnd_api.g_miss_char, new_position_reference, p_new_position_reference),
249: old_active_start_date = DECODE( p_old_active_start_date, fnd_api.g_miss_date, old_active_start_date, p_old_active_start_date),
250: new_active_start_date = DECODE( p_new_active_start_date, fnd_api.g_miss_date, new_active_start_date, p_new_active_start_date),
251: old_active_end_date = DECODE( p_old_active_end_date, fnd_api.g_miss_date, old_active_end_date, p_old_active_end_date),
252: new_active_end_date = DECODE( p_new_active_end_date, fnd_api.g_miss_date, new_active_end_date, p_new_active_end_date),
245: old_subject_id = DECODE( p_old_subject_id, fnd_api.g_miss_num, old_subject_id, p_old_subject_id),
246: new_subject_id = DECODE( p_new_subject_id, fnd_api.g_miss_num, new_subject_id, p_new_subject_id),
247: old_position_reference = DECODE( p_old_position_reference, fnd_api.g_miss_char, old_position_reference, p_old_position_reference),
248: new_position_reference = DECODE( p_new_position_reference, fnd_api.g_miss_char, new_position_reference, p_new_position_reference),
249: old_active_start_date = DECODE( p_old_active_start_date, fnd_api.g_miss_date, old_active_start_date, p_old_active_start_date),
250: new_active_start_date = DECODE( p_new_active_start_date, fnd_api.g_miss_date, new_active_start_date, p_new_active_start_date),
251: old_active_end_date = DECODE( p_old_active_end_date, fnd_api.g_miss_date, old_active_end_date, p_old_active_end_date),
252: new_active_end_date = DECODE( p_new_active_end_date, fnd_api.g_miss_date, new_active_end_date, p_new_active_end_date),
253: old_mandatory_flag = DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, old_mandatory_flag, p_old_mandatory_flag),
246: new_subject_id = DECODE( p_new_subject_id, fnd_api.g_miss_num, new_subject_id, p_new_subject_id),
247: old_position_reference = DECODE( p_old_position_reference, fnd_api.g_miss_char, old_position_reference, p_old_position_reference),
248: new_position_reference = DECODE( p_new_position_reference, fnd_api.g_miss_char, new_position_reference, p_new_position_reference),
249: old_active_start_date = DECODE( p_old_active_start_date, fnd_api.g_miss_date, old_active_start_date, p_old_active_start_date),
250: new_active_start_date = DECODE( p_new_active_start_date, fnd_api.g_miss_date, new_active_start_date, p_new_active_start_date),
251: old_active_end_date = DECODE( p_old_active_end_date, fnd_api.g_miss_date, old_active_end_date, p_old_active_end_date),
252: new_active_end_date = DECODE( p_new_active_end_date, fnd_api.g_miss_date, new_active_end_date, p_new_active_end_date),
253: old_mandatory_flag = DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, old_mandatory_flag, p_old_mandatory_flag),
254: new_mandatory_flag = DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, new_mandatory_flag, p_new_mandatory_flag),
247: old_position_reference = DECODE( p_old_position_reference, fnd_api.g_miss_char, old_position_reference, p_old_position_reference),
248: new_position_reference = DECODE( p_new_position_reference, fnd_api.g_miss_char, new_position_reference, p_new_position_reference),
249: old_active_start_date = DECODE( p_old_active_start_date, fnd_api.g_miss_date, old_active_start_date, p_old_active_start_date),
250: new_active_start_date = DECODE( p_new_active_start_date, fnd_api.g_miss_date, new_active_start_date, p_new_active_start_date),
251: old_active_end_date = DECODE( p_old_active_end_date, fnd_api.g_miss_date, old_active_end_date, p_old_active_end_date),
252: new_active_end_date = DECODE( p_new_active_end_date, fnd_api.g_miss_date, new_active_end_date, p_new_active_end_date),
253: old_mandatory_flag = DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, old_mandatory_flag, p_old_mandatory_flag),
254: new_mandatory_flag = DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, new_mandatory_flag, p_new_mandatory_flag),
255: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
248: new_position_reference = DECODE( p_new_position_reference, fnd_api.g_miss_char, new_position_reference, p_new_position_reference),
249: old_active_start_date = DECODE( p_old_active_start_date, fnd_api.g_miss_date, old_active_start_date, p_old_active_start_date),
250: new_active_start_date = DECODE( p_new_active_start_date, fnd_api.g_miss_date, new_active_start_date, p_new_active_start_date),
251: old_active_end_date = DECODE( p_old_active_end_date, fnd_api.g_miss_date, old_active_end_date, p_old_active_end_date),
252: new_active_end_date = DECODE( p_new_active_end_date, fnd_api.g_miss_date, new_active_end_date, p_new_active_end_date),
253: old_mandatory_flag = DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, old_mandatory_flag, p_old_mandatory_flag),
254: new_mandatory_flag = DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, new_mandatory_flag, p_new_mandatory_flag),
255: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
256: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
249: old_active_start_date = DECODE( p_old_active_start_date, fnd_api.g_miss_date, old_active_start_date, p_old_active_start_date),
250: new_active_start_date = DECODE( p_new_active_start_date, fnd_api.g_miss_date, new_active_start_date, p_new_active_start_date),
251: old_active_end_date = DECODE( p_old_active_end_date, fnd_api.g_miss_date, old_active_end_date, p_old_active_end_date),
252: new_active_end_date = DECODE( p_new_active_end_date, fnd_api.g_miss_date, new_active_end_date, p_new_active_end_date),
253: old_mandatory_flag = DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, old_mandatory_flag, p_old_mandatory_flag),
254: new_mandatory_flag = DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, new_mandatory_flag, p_new_mandatory_flag),
255: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
256: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
257: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
250: new_active_start_date = DECODE( p_new_active_start_date, fnd_api.g_miss_date, new_active_start_date, p_new_active_start_date),
251: old_active_end_date = DECODE( p_old_active_end_date, fnd_api.g_miss_date, old_active_end_date, p_old_active_end_date),
252: new_active_end_date = DECODE( p_new_active_end_date, fnd_api.g_miss_date, new_active_end_date, p_new_active_end_date),
253: old_mandatory_flag = DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, old_mandatory_flag, p_old_mandatory_flag),
254: new_mandatory_flag = DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, new_mandatory_flag, p_new_mandatory_flag),
255: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
256: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
257: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
258: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
251: old_active_end_date = DECODE( p_old_active_end_date, fnd_api.g_miss_date, old_active_end_date, p_old_active_end_date),
252: new_active_end_date = DECODE( p_new_active_end_date, fnd_api.g_miss_date, new_active_end_date, p_new_active_end_date),
253: old_mandatory_flag = DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, old_mandatory_flag, p_old_mandatory_flag),
254: new_mandatory_flag = DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, new_mandatory_flag, p_new_mandatory_flag),
255: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
256: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
257: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
258: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
259: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
252: new_active_end_date = DECODE( p_new_active_end_date, fnd_api.g_miss_date, new_active_end_date, p_new_active_end_date),
253: old_mandatory_flag = DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, old_mandatory_flag, p_old_mandatory_flag),
254: new_mandatory_flag = DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, new_mandatory_flag, p_new_mandatory_flag),
255: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
256: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
257: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
258: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
259: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
260: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
253: old_mandatory_flag = DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, old_mandatory_flag, p_old_mandatory_flag),
254: new_mandatory_flag = DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, new_mandatory_flag, p_new_mandatory_flag),
255: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
256: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
257: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
258: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
259: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
260: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
261: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
254: new_mandatory_flag = DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, new_mandatory_flag, p_new_mandatory_flag),
255: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
256: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
257: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
258: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
259: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
260: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
261: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
262: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
255: old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
256: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
257: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
258: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
259: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
260: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
261: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
262: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
263: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
256: new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
257: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
258: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
259: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
260: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
261: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
262: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
263: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
264: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
257: old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
258: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
259: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
260: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
261: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
262: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
263: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
264: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
265: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
258: new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
259: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
260: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
261: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
262: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
263: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
264: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
265: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
266: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
259: old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
260: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
261: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
262: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
263: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
264: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
265: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
266: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
267: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
260: new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
261: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
262: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
263: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
264: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
265: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
266: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
267: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
268: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
261: old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
262: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
263: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
264: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
265: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
266: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
267: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
268: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
269: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
262: new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
263: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
264: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
265: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
266: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
267: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
268: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
269: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
270: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
263: old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
264: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
265: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
266: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
267: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
268: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
269: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
270: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
271: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
264: new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
265: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
266: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
267: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
268: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
269: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
270: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
271: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
272: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
265: old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
266: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
267: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
268: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
269: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
270: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
271: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
272: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
273: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
266: new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
267: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
268: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
269: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
270: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
271: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
272: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
273: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
274: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
267: old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
268: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
269: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
270: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
271: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
272: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
273: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
274: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
275: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
268: new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
269: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
270: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
271: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
272: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
273: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
274: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
275: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
276: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
269: old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
270: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
271: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
272: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
273: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
274: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
275: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
276: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
277: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
270: new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
271: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
272: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
273: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
274: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
275: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
276: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
277: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
278: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
271: old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
272: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
273: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
274: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
275: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
276: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
277: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
278: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
279: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
272: new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
273: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
274: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
275: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
276: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
277: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
278: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
279: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
280: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
273: old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
274: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
275: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
276: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
277: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
278: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
279: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
280: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
281: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
274: new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
275: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
276: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
277: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
278: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
279: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
280: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
281: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
282: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
275: old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
276: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
277: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
278: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
279: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
280: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
281: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
282: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
283: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
276: new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
277: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
278: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
279: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
280: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
281: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
282: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
283: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
284: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
277: old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
278: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
279: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
280: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
281: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
282: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
283: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
284: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
285: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
278: new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
279: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
280: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
281: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
282: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
283: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
284: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
285: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
286: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
279: old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
280: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
281: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
282: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
283: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
284: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
285: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
286: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
287: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
280: new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
281: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
282: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
283: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
284: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
285: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
286: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
287: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
288: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
281: old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
282: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
283: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
284: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
285: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
286: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
287: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
288: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
289: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
282: new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
283: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
284: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
285: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
286: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
287: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
288: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
289: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
290: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
283: old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
284: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
285: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
286: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
287: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
288: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
289: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
290: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
291: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
284: new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
285: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
286: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
287: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
288: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
289: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
290: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
291: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
292: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
285: old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
286: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
287: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
288: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
289: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
290: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
291: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
292: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
293: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
286: new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
287: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
288: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
289: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
290: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
291: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
292: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
293: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
294: object_version_number = object_version_number + 1
287: full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
288: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
289: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
290: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
291: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
292: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
293: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
294: object_version_number = object_version_number + 1
295: WHERE relationship_history_id = p_relationship_history_id;
288: created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
289: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
290: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
291: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
292: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
293: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
294: object_version_number = object_version_number + 1
295: WHERE relationship_history_id = p_relationship_history_id;
296:
289: creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
290: last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
291: last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
292: last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
293: --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
294: object_version_number = object_version_number + 1
295: WHERE relationship_history_id = p_relationship_history_id;
296:
297: IF (SQL%NOTFOUND) THEN