APPS.HZ_DYN_VALIDATION dependencies on HZ_CONTACT_POINT_VAL_GT

Line 1406: SELECT hz_contact_point_val_gt_s.NEXTVAL

1402: x_validation_profile IN VARCHAR2,
1403: x_temp_id IN NUMBER DEFAULT NULL
1404: ) IS
1405: CURSOR psidcur IS
1406: SELECT hz_contact_point_val_gt_s.NEXTVAL
1407: FROM DUAL;
1408:
1409: l_contact_point_id NUMBER(15);
1410: l_debug_prefix VARCHAR2(30) := '';

Line 1443: fnd_message.set_token('SEQUENCE', 'hz_contact_point_val_gt_s');

1439: -- not be selected from the sequence.
1440: CLOSE psidcur;
1441:
1442: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
1443: fnd_message.set_token('SEQUENCE', 'hz_contact_point_val_gt_s');
1444: fnd_msg_pub.add;
1445: RAISE fnd_api.g_exc_error;
1446: END IF;
1447:

Line 1452: DELETE FROM hz_contact_point_val_gt;

1448: CLOSE psidcur;
1449: END IF;
1450:
1451: -- Bug 3814832
1452: DELETE FROM hz_contact_point_val_gt;
1453: -- Create the contact_point record.
1454: INSERT INTO hz_contact_point_val_gt(temp_id,
1455: contact_point_type,
1456: status,

Line 1454: INSERT INTO hz_contact_point_val_gt(temp_id,

1450:
1451: -- Bug 3814832
1452: DELETE FROM hz_contact_point_val_gt;
1453: -- Create the contact_point record.
1454: INSERT INTO hz_contact_point_val_gt(temp_id,
1455: contact_point_type,
1456: status,
1457: owner_table_name,
1458: owner_table_id,