APPS.HZ_DYN_VALIDATION dependencies on HZ_ORG_PROFILE_VAL_GT

Line 424: SELECT hz_org_profile_val_gt_s.NEXTVAL

420: x_validation_profile IN VARCHAR2,
421: x_temp_id IN NUMBER DEFAULT NULL
422: ) IS
423: CURSOR orgidcur IS
424: SELECT hz_org_profile_val_gt_s.NEXTVAL
425: FROM DUAL;
426:
427: l_org_profile_id NUMBER(15);
428: l_party_id NUMBER(15);

Line 465: fnd_message.set_token('SEQUENCE', 'hz_org_profile_val_gt_s');

461: -- selected from the sequence.
462: CLOSE orgidcur;
463:
464: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
465: fnd_message.set_token('SEQUENCE', 'hz_org_profile_val_gt_s');
466: fnd_msg_pub.add;
467: RAISE fnd_api.g_exc_error;
468: END IF;
469: CLOSE orgidcur;

Line 473: DELETE FROM hz_org_profile_val_gt;

469: CLOSE orgidcur;
470: END IF;
471:
472: -- Bug 3814832
473: DELETE FROM hz_org_profile_val_gt;
474: -- create the org profile record
475: INSERT INTO hz_org_profile_val_gt(organization_name,
476: temp_id,
477: temp_party_id,

Line 475: INSERT INTO hz_org_profile_val_gt(organization_name,

471:
472: -- Bug 3814832
473: DELETE FROM hz_org_profile_val_gt;
474: -- create the org profile record
475: INSERT INTO hz_org_profile_val_gt(organization_name,
476: temp_id,
477: temp_party_id,
478: duns_number_c,
479: enquiry_duns,