APPS.IGS_AS_ANON_GRD_PKG dependencies on IGS_AS_ANON_ID_PS

Line 228: l_anonymous_id igs_as_anon_id_ps.anonymous_id%TYPE;

224:
225: l_anonymous_number igs_as_anon_number.anonymous_number%TYPE;
226: l_rowid ROWID;
227: l_rowid_delete ROWID;
228: l_anonymous_id igs_as_anon_id_ps.anonymous_id%TYPE;
229: l_system_generated_ind VARCHAR2(1);
230:
231: BEGIN
232:

Line 300: igs_as_anon_id_ps_pkg.insert_row(

296: x_mode =>'R');
297:
298: ELSE -- p_method = 'PROGRAM'
299:
300: igs_as_anon_id_ps_pkg.insert_row(
301: x_rowid => l_rowid,
302: x_person_id => p_person_id,
303: x_anonymous_id => l_anonymous_id,
304: x_system_generated_ind => l_system_generated_ind,

Line 391: FROM igs_as_anon_id_ps anip

387: SELECT COUNT(*)
388: FROM igs_en_stdnt_ps_att spa
389: WHERE spa.course_attempt_status IN ('ENROLLED', 'UNCONFIRM', 'INACTIVE')
390: AND NOT EXISTS (SELECT 'X'
391: FROM igs_as_anon_id_ps anip
392: WHERE anip.person_id = spa.person_id
393: AND anip.course_cd = spa.course_cd);
394:
395:

Line 482: FROM igs_as_anon_id_ps anip

478: spa.course_cd
479: FROM igs_en_stdnt_ps_att spa
480: WHERE spa.course_attempt_status IN ('ENROLLED', 'UNCONFIRM','INACTIVE')
481: AND NOT EXISTS (SELECT 'X'
482: FROM igs_as_anon_id_ps anip
483: WHERE anip.person_id = spa.person_id
484: AND anip.course_cd = spa.course_cd);
485:
486: -- Search for all Student Unit Attempts related to the Load Calendar

Line 590: FROM igs_as_anon_id_ps;

586: -- (To delete the records when P_REALLOCATE_ID = 'Y')
587: CURSOR c_program_delete
588: IS
589: SELECT ROWID
590: FROM igs_as_anon_id_ps;
591:
592: -- Find all records of PROGRAM method
593: -- (To delete the records when P_REALLOCATE_ID = 'Y')
594: CURSOR c_anon_num_delete_prog

Line 713: igs_as_anon_id_ps_pkg.delete_row(c_program_delete_rec.ROWID);

709: ELSE -- 'PROGRAM'
710: -- Delete Allocated Anonymous IDs
711: FOR c_program_delete_rec IN c_program_delete
712: LOOP
713: igs_as_anon_id_ps_pkg.delete_row(c_program_delete_rec.ROWID);
714: END LOOP;
715:
716: -- Delete Unallocated Anonymous IDs
717: FOR c_anon_num_delete_prog_rec IN c_anon_num_delete_prog

Line 991: FROM igs_as_anon_id_ps anip,

987:
988: CURSOR c_anip
989: IS
990: SELECT anonymous_id
991: FROM igs_as_anon_id_ps anip,
992: igs_en_su_attempt sua,
993: igs_ps_unit_ofr_opt uoo
994: WHERE sua.person_id = p_person_id
995: AND sua.course_cd = p_course_cd

Line 1186: p_anonymous_id IN igs_as_anon_id_ps.anonymous_id%TYPE,

1182:
1183:
1184:
1185: FUNCTION get_person_id (
1186: p_anonymous_id IN igs_as_anon_id_ps.anonymous_id%TYPE,
1187: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1188: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1189: ) RETURN NUMBER IS
1190:

Line 1204: FROM igs_as_anon_id_ps anip

1200:
1201: CURSOR c_anip
1202: IS
1203: SELECT person_id
1204: FROM igs_as_anon_id_ps anip
1205: WHERE anip.anonymous_id = p_anonymous_id;
1206:
1207: CURSOR c_aniu
1208: IS