APPS.IGS_AS_ANON_GRD_PKG dependencies on IGS_AS_ANON_ID_ASS

Line 288: igs_as_anon_id_ass_pkg.insert_row(

284: x_mode => 'R');
285:
286: ELSIF p_method = 'ASSESSMENT' THEN
287:
288: igs_as_anon_id_ass_pkg.insert_row(
289: x_rowid => l_rowid,
290: x_person_id => p_person_id,
291: x_anonymous_id => l_anonymous_id,
292: x_system_generated_ind => l_system_generated_ind,

Line 467: FROM igs_as_anon_id_ass ania

463: FROM igs_as_anon_method anm
464: WHERE anm.load_cal_type = cp_load_cal_type
465: AND anm.assessment_type = ast.assessment_type)))
466: AND NOT EXISTS (SELECT 'X'
467: FROM igs_as_anon_id_ass ania
468: WHERE ania.person_id = sua.person_id
469: AND ania.assessment_type = ast.assessment_type
470: AND ania.load_cal_type = cp_load_cal_type
471: AND ania.load_ci_sequence_number = cp_load_ci_sequence_number));

Line 558: FROM igs_as_anon_id_ass ania

554: FROM igs_as_anon_method anm
555: WHERE anm.load_cal_type = cp_load_cal_type
556: AND anm.assessment_type = ast.assessment_type)))
557: AND NOT EXISTS (SELECT 'X'
558: FROM igs_as_anon_id_ass ania
559: WHERE ania.person_id = sua.person_id
560: AND ania.assessment_type = ast.assessment_type
561: AND ania.load_cal_type = cp_load_cal_type
562: AND ania.load_ci_sequence_number = cp_load_ci_sequence_number) ;

Line 571: FROM igs_as_anon_id_ass ania

567: CURSOR c_ass_delete(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
568: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
569: IS
570: SELECT ROWID
571: FROM igs_as_anon_id_ass ania
572: WHERE ania.load_cal_type = cp_load_cal_type
573: AND ania.load_ci_sequence_number = cp_load_ci_sequence_number;
574:
575: -- Find all the records in the Context Load Calendar for SECTION method

Line 699: igs_as_anon_id_ass_pkg.delete_row(c_ass_delete_rec.ROWID);

695:
696: IF l_method = 'ASSESSMENT' THEN
697: -- Delete Allocated Anonymous IDs
698: FOR c_ass_delete_rec IN c_ass_delete(l_ld_cal_type,l_ld_sequence_number) LOOP
699: igs_as_anon_id_ass_pkg.delete_row(c_ass_delete_rec.ROWID);
700: END LOOP;
701:
702: ELSIF l_method = 'SECTION' THEN
703: -- Delete Allocated Anonymous IDs

Line 1055: FROM igs_as_anon_id_ass ania,

1051:
1052: CURSOR c_ania
1053: IS
1054: SELECT anonymous_id
1055: FROM igs_as_anon_id_ass ania,
1056: igs_en_su_attempt sua,
1057: igs_ps_unit_ofr_opt uoo,
1058: igs_ca_teach_to_load_v ttl
1059: WHERE sua.person_id = p_person_id

Line 1224: FROM igs_as_anon_id_ass ania,

1220: AND ttl2.teach_ci_sequence_number = p_teach_ci_sequence_number);
1221: CURSOR c_ania
1222: IS
1223: SELECT person_id
1224: FROM igs_as_anon_id_ass ania,
1225: igs_ca_teach_to_load_v ttl
1226: WHERE ania. anonymous_id = p_anonymous_id
1227: AND ania.load_cal_type = ttl.load_cal_type
1228: AND ania.load_ci_sequence_number = ttl.load_ci_sequence_number