APPS.HZ_DYN_VALIDATION dependencies on HZ_PARTY_SITE_VAL_GT

Line 1066: SELECT hz_party_site_val_gt_s.NEXTVAL

1062: x_validation_profile IN VARCHAR2,
1063: x_temp_id IN NUMBER DEFAULT NULL
1064: ) IS
1065: CURSOR psidcur IS
1066: SELECT hz_party_site_val_gt_s.NEXTVAL
1067: FROM DUAL;
1068:
1069: l_party_site_id NUMBER(15);
1070: l_debug_prefix VARCHAR2(30) := '';

Line 1103: fnd_message.set_token('SEQUENCE', 'hz_party_site_val_gt_s');

1099: -- be selected from the sequence.
1100: CLOSE psidcur;
1101:
1102: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
1103: fnd_message.set_token('SEQUENCE', 'hz_party_site_val_gt_s');
1104: fnd_msg_pub.add;
1105: RAISE fnd_api.g_exc_error;
1106: END IF;
1107: CLOSE psidcur;

Line 1111: DELETE FROM hz_party_site_val_gt;

1107: CLOSE psidcur;
1108: END IF;
1109:
1110: -- Bug 3814832
1111: DELETE FROM hz_party_site_val_gt;
1112: -- Create the party_site record.
1113: INSERT INTO hz_party_site_val_gt(temp_id,
1114: party_id,
1115: location_id,

Line 1113: INSERT INTO hz_party_site_val_gt(temp_id,

1109:
1110: -- Bug 3814832
1111: DELETE FROM hz_party_site_val_gt;
1112: -- Create the party_site record.
1113: INSERT INTO hz_party_site_val_gt(temp_id,
1114: party_id,
1115: location_id,
1116: party_site_number,
1117: orig_system_reference,