DBA Data[Home] [Help]

APPS.HZ_DYN_VALIDATION dependencies on HZ_GROUP_VAL_GT

Line 776: SELECT hz_group_val_gt_s.NEXTVAL

772: x_validation_profile IN VARCHAR2,
773: x_temp_id IN NUMBER DEFAULT NULL
774: ) IS
775: CURSOR grpidcur IS
776: SELECT hz_group_val_gt_s.NEXTVAL
777: FROM DUAL;
778:
779: l_group_id NUMBER(15);
780: l_party_id NUMBER(15);

Line 817: fnd_message.set_token('SEQUENCE', 'hz_group_val_gt_s');

813: -- selected from the sequence.
814: CLOSE grpidcur;
815:
816: fnd_message.set_name('AR', 'HZ_DV_ID_NOT_FOUND');
817: fnd_message.set_token('SEQUENCE', 'hz_group_val_gt_s');
818: fnd_msg_pub.add;
819: RAISE fnd_api.g_exc_error;
820: END IF;
821:

Line 826: DELETE FROM hz_group_val_gt;

822: CLOSE grpidcur;
823: END IF;
824:
825: -- Bug 3814832
826: DELETE FROM hz_group_val_gt;
827: -- Create the group record.
828: INSERT INTO hz_group_val_gt(group_name,
829: temp_id,
830: temp_party_id,

Line 828: INSERT INTO hz_group_val_gt(group_name,

824:
825: -- Bug 3814832
826: DELETE FROM hz_group_val_gt;
827: -- Create the group record.
828: INSERT INTO hz_group_val_gt(group_name,
829: temp_id,
830: temp_party_id,
831: group_type,
832: created_by_module,