APPS.HZ_DYN_VALIDATION dependencies on HZ_LOCATION_VAL_GT

Line 1206: SELECT hz_location_val_gt_s.NEXTVAL

1202: x_validation_profile IN VARCHAR2,
1203: x_temp_id IN NUMBER DEFAULT NULL
1204: ) IS
1205: CURSOR locidcur IS
1206: SELECT hz_location_val_gt_s.NEXTVAL
1207: FROM DUAL;
1208:
1209: l_location_id NUMBER(15);
1210: l_debug_prefix VARCHAR2(30) := '';

Line 1243: fnd_message.set_token('SEQUENCE', 'hz_location_val_gt_s');

1239: -- selected from the sequence.
1240: CLOSE locidcur;
1241:
1242: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
1243: fnd_message.set_token('SEQUENCE', 'hz_location_val_gt_s');
1244: fnd_msg_pub.add;
1245: RAISE fnd_api.g_exc_error;
1246: END IF;
1247: CLOSE locidcur;

Line 1251: DELETE FROM hz_location_val_gt;

1247: CLOSE locidcur;
1248: END IF;
1249:
1250: -- Bug 3814832
1251: DELETE FROM hz_location_val_gt;
1252: -- Create the location record.
1253: INSERT INTO hz_location_val_gt(temp_id,
1254: orig_system_reference,
1255: country,

Line 1253: INSERT INTO hz_location_val_gt(temp_id,

1249:
1250: -- Bug 3814832
1251: DELETE FROM hz_location_val_gt;
1252: -- Create the location record.
1253: INSERT INTO hz_location_val_gt(temp_id,
1254: orig_system_reference,
1255: country,
1256: address1,
1257: address2,