DBA Data[Home] [Help]

APPS.HZ_DYN_VALIDATION dependencies on HZ_RELATIONSHIP_VAL_GT

Line 207: SELECT hz_relationship_val_gt_s.NEXTVAL

203: x_relationship IN hz_relationship_v2pub.relationship_rec_type,
204: x_temp_id IN NUMBER DEFAULT NULL
205: ) RETURN NUMBER IS
206: CURSOR relidcur IS
207: SELECT hz_relationship_val_gt_s.NEXTVAL
208: FROM DUAL;
209:
210: l_relationship_id NUMBER(15);
211: l_party_id NUMBER(15);

Line 236: fnd_message.set_token('SEQUENCE', 'hz_relationship_val_gt_s');

232: -- could not be selected from the sequence.
233: CLOSE relidcur;
234:
235: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
236: fnd_message.set_token('SEQUENCE', 'hz_relationship_val_gt_s');
237: fnd_msg_pub.add;
238: RAISE fnd_api.g_exc_error;
239: END IF;
240: CLOSE relidcur;

Line 244: INSERT INTO hz_relationship_val_gt(temp_id,

240: CLOSE relidcur;
241: END IF;
242:
243: -- Create the relationship record.
244: INSERT INTO hz_relationship_val_gt(temp_id,
245: temp_party_id,
246: subject_id,
247: subject_type,
248: subject_table_name,