APPS.IGS_AS_ANON_GRD_PKG dependencies on IGS_AS_ANON_ID_US

Line 272: igs_as_anon_id_us_pkg.insert_row(

268: END IF;
269:
270: IF p_method = 'SECTION' THEN
271:
272: igs_as_anon_id_us_pkg.insert_row(
273: x_rowid => l_rowid,
274: x_person_id => p_person_id,
275: x_anonymous_id => l_anonymous_id,
276: x_system_generated_ind => l_system_generated_ind,

Line 418: FROM igs_as_anon_id_us aniu

414: AND (uoo.anon_assess_grading_ind = 'Y'
415: OR uoo.anon_unit_grading_ind = 'Y')
416: AND uoo.uoo_id = sua.uoo_id
417: AND NOT EXISTS (SELECT 'X'
418: FROM igs_as_anon_id_us aniu
419: WHERE aniu.person_id = sua.person_id
420: AND aniu.course_cd = sua.course_cd
421: AND aniu.unit_cd = sua.unit_cd
422: AND aniu.teach_cal_type = sua.cal_type

Line 512: FROM igs_as_anon_id_us aniu

508: AND (uoo.anon_unit_grading_ind = 'Y'
509: OR uoo.anon_assess_grading_ind = 'Y')
510: AND sua.uoo_id = uoo.uoo_id
511: AND NOT EXISTS (SELECT 'X'
512: FROM igs_as_anon_id_us aniu
513: WHERE aniu.person_id = sua.person_id
514: AND aniu.course_cd = sua.course_cd
515: AND aniu.unit_cd = sua.unit_cd
516: AND aniu.teach_cal_type = sua.cal_type

Line 581: FROM igs_as_anon_id_us aniu

577: CURSOR c_section_delete(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
578: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
579: IS
580: SELECT ROWID
581: FROM igs_as_anon_id_us aniu
582: WHERE aniu.load_cal_type = cp_load_cal_type
583: AND aniu.load_ci_sequence_number = cp_load_ci_sequence_number;
584:
585: -- Find all the records of PROGRAM method

Line 706: igs_as_anon_id_us_pkg.delete_row(c_section_delete_rec.ROWID);

702: ELSIF l_method = 'SECTION' THEN
703: -- Delete Allocated Anonymous IDs
704: FOR c_section_delete_rec IN c_section_delete(l_ld_cal_type,l_ld_sequence_number)
705: LOOP
706: igs_as_anon_id_us_pkg.delete_row(c_section_delete_rec.ROWID);
707: END LOOP;
708:
709: ELSE -- 'PROGRAM'
710: -- Delete Allocated Anonymous IDs

Line 1021: FROM igs_as_anon_id_us aniu,

1017:
1018: CURSOR c_aniu
1019: IS
1020: SELECT anonymous_id
1021: FROM igs_as_anon_id_us aniu,
1022: igs_en_su_attempt sua,
1023: igs_ps_unit_ofr_opt uoo
1024: WHERE sua.person_id = p_person_id
1025: AND sua.course_cd = p_course_cd

Line 1210: FROM igs_as_anon_id_us aniu,

1206:
1207: CURSOR c_aniu
1208: IS
1209: SELECT person_id
1210: FROM igs_as_anon_id_us aniu,
1211: igs_ca_teach_to_load_v ttl
1212: WHERE aniu. anonymous_id = p_anonymous_id
1213: AND aniu.load_cal_type = ttl.load_cal_type
1214: AND aniu.load_ci_sequence_number = ttl.load_ci_sequence_number