DBA Data[Home] [Help]

APPS.CSI_II_RELATIONSHIPS_H_PKG dependencies on FND_API

Line 71: IF (px_relationship_history_id IS NULL) OR (px_relationship_history_id = fnd_api.g_miss_num) THEN

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;

Line 131: DECODE( p_relationship_id, fnd_api.g_miss_num, NULL, p_relationship_id),

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

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

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

Line 133: DECODE( p_old_subject_id, fnd_api.g_miss_num, NULL, p_old_subject_id),

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

Line 134: DECODE( p_new_subject_id, fnd_api.g_miss_num, NULL, p_new_subject_id),

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

Line 135: DECODE( p_old_position_reference, fnd_api.g_miss_char, NULL, p_old_position_reference),

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

Line 136: DECODE( p_new_position_reference, fnd_api.g_miss_char, NULL, p_new_position_reference),

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

Line 137: DECODE( p_old_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_start_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),

Line 138: DECODE( p_new_active_start_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_start_date),

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

Line 139: DECODE( p_old_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_old_active_end_date),

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

Line 140: DECODE( p_new_active_end_date, fnd_api.g_miss_date, TO_DATE(NULL), p_new_active_end_date),

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

Line 141: DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, NULL, p_old_mandatory_flag),

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

Line 142: DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, NULL, p_new_mandatory_flag),

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 177: DECODE( p_creation_date, fnd_api.g_miss_date, TO_DATE(NULL), p_creation_date),

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

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

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;

Line 179: DECODE( p_last_update_date, fnd_api.g_miss_date, TO_DATE(NULL), p_last_update_date),

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:

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

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:

Line 181: DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));

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(

Line 243: relationship_id = DECODE( p_relationship_id, fnd_api.g_miss_num, relationship_id, p_relationship_id),

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

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

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

Line 245: old_subject_id = DECODE( p_old_subject_id, fnd_api.g_miss_num, old_subject_id, p_old_subject_id),

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

Line 246: new_subject_id = DECODE( p_new_subject_id, fnd_api.g_miss_num, new_subject_id, p_new_subject_id),

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

Line 247: old_position_reference = DECODE( p_old_position_reference, fnd_api.g_miss_char, old_position_reference, p_old_position_reference),

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

Line 248: new_position_reference = DECODE( p_new_position_reference, fnd_api.g_miss_char, new_position_reference, p_new_position_reference),

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

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

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

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

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

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

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

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

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

Line 253: old_mandatory_flag = DECODE( p_old_mandatory_flag, fnd_api.g_miss_char, old_mandatory_flag, p_old_mandatory_flag),

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

Line 254: new_mandatory_flag = DECODE( p_new_mandatory_flag, fnd_api.g_miss_char, new_mandatory_flag, p_new_mandatory_flag),

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

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

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

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;

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

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:

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

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