DBA Data[Home] [Help]

APPS.IGS_AS_ANON_GRD_PKG dependencies on IGS_AS_ANON_NUMBER_PKG

Line 242: igs_as_anon_number_pkg.delete_row(l_rowid_delete);

238: OPEN c_delete_anon_number(l_anonymous_number,p_load_cal_type, p_load_ci_sequence_number);
239: FETCH c_delete_anon_number INTO l_rowid_delete;
240: CLOSE c_delete_anon_number;
241:
242: igs_as_anon_number_pkg.delete_row(l_rowid_delete);
243:
244:
245: -- Call the USER_ANON_ID user hook to return an Anonymous ID in a format specified by the Institution
246: l_anonymous_id := igs_as_anon_grd_pkg.user_anon_id (

Line 719: igs_as_anon_number_pkg.delete_row(c_anon_num_delete_prog_rec.ROWID);

715:
716: -- Delete Unallocated Anonymous IDs
717: FOR c_anon_num_delete_prog_rec IN c_anon_num_delete_prog
718: LOOP
719: igs_as_anon_number_pkg.delete_row(c_anon_num_delete_prog_rec.ROWID);
720: END LOOP;
721:
722: END IF;
723: -- Delete Unallocated Anonymous IDs

Line 726: igs_as_anon_number_pkg.delete_row(c_anon_num_delete_rec.ROWID);

722: END IF;
723: -- Delete Unallocated Anonymous IDs
724: FOR c_anon_num_delete_rec IN c_anon_num_delete(l_ld_cal_type,l_ld_sequence_number)
725: LOOP
726: igs_as_anon_number_pkg.delete_row(c_anon_num_delete_rec.ROWID);
727: END LOOP;
728:
729: END IF;
730:

Line 834: igs_as_anon_number_pkg.insert_row(

830: IF temp_table.EXISTS(l_index) THEN
831:
832: -- Insert the Randomly generated Anonymous Numbers
833: IF c_method_rec.method = 'PROGRAM' THEN
834: igs_as_anon_number_pkg.insert_row(
835: x_rowid => l_rowid,
836: x_anum_id => l_anum_id,
837: x_anonymous_number => temp_table(l_index),
838: x_load_cal_type => NULL,

Line 842: igs_as_anon_number_pkg.insert_row(

838: x_load_cal_type => NULL,
839: x_load_ci_sequence_number => NULL,
840: x_mode => 'R');
841: ELSE
842: igs_as_anon_number_pkg.insert_row(
843: x_rowid => l_rowid,
844: x_anum_id => l_anum_id,
845: x_anonymous_number => temp_table(l_index),
846: x_load_cal_type => l_ld_cal_type,