eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_ANON_GRD_PKG dependencies on IGS_AS_ANON_NUMBER

Line 200: -- Select the first record from the unallocated anonymous number table IGS_AS_ANON_NUMBER

196: || Who When What
197: || (reverse chronological order - newest change first)
198: */
199:
200: -- Select the first record from the unallocated anonymous number table IGS_AS_ANON_NUMBER
201: -- for the different methods. or PROGRAM method the cal_type and ci_sequence_number would be NULL.
202: CURSOR c_anon_number(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
203: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
204: IS

Line 202: CURSOR c_anon_number(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,

198: */
199:
200: -- Select the first record from the unallocated anonymous number table IGS_AS_ANON_NUMBER
201: -- for the different methods. or PROGRAM method the cal_type and ci_sequence_number would be NULL.
202: CURSOR c_anon_number(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
203: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
204: IS
205: SELECT anonymous_number
206: FROM igs_as_anon_number

Line 203: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)

199:
200: -- Select the first record from the unallocated anonymous number table IGS_AS_ANON_NUMBER
201: -- for the different methods. or PROGRAM method the cal_type and ci_sequence_number would be NULL.
202: CURSOR c_anon_number(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
203: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
204: IS
205: SELECT anonymous_number
206: FROM igs_as_anon_number
207: WHERE ((load_cal_type = cp_load_cal_type) OR

Line 206: FROM igs_as_anon_number

202: CURSOR c_anon_number(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
203: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
204: IS
205: SELECT anonymous_number
206: FROM igs_as_anon_number
207: WHERE ((load_cal_type = cp_load_cal_type) OR
208: (load_cal_type IS NULL AND cp_load_cal_type IS NULL))
209: AND ((load_ci_sequence_number = cp_load_ci_sequence_number) OR
210: (load_ci_sequence_number IS NULL AND cp_load_ci_sequence_number IS NULL));

Line 212: CURSOR c_delete_anon_number(cp_anonymous_number igs_as_anon_number.anonymous_number%TYPE,

208: (load_cal_type IS NULL AND cp_load_cal_type IS NULL))
209: AND ((load_ci_sequence_number = cp_load_ci_sequence_number) OR
210: (load_ci_sequence_number IS NULL AND cp_load_ci_sequence_number IS NULL));
211:
212: CURSOR c_delete_anon_number(cp_anonymous_number igs_as_anon_number.anonymous_number%TYPE,
213: cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
214: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
215: IS
216: SELECT ROWID

Line 213: cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,

209: AND ((load_ci_sequence_number = cp_load_ci_sequence_number) OR
210: (load_ci_sequence_number IS NULL AND cp_load_ci_sequence_number IS NULL));
211:
212: CURSOR c_delete_anon_number(cp_anonymous_number igs_as_anon_number.anonymous_number%TYPE,
213: cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
214: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
215: IS
216: SELECT ROWID
217: FROM igs_as_anon_number

Line 214: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)

210: (load_ci_sequence_number IS NULL AND cp_load_ci_sequence_number IS NULL));
211:
212: CURSOR c_delete_anon_number(cp_anonymous_number igs_as_anon_number.anonymous_number%TYPE,
213: cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
214: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
215: IS
216: SELECT ROWID
217: FROM igs_as_anon_number
218: WHERE anonymous_number = cp_anonymous_number

Line 217: FROM igs_as_anon_number

213: cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
214: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
215: IS
216: SELECT ROWID
217: FROM igs_as_anon_number
218: WHERE anonymous_number = cp_anonymous_number
219: AND ((load_cal_type = cp_load_cal_type) OR
220: (load_cal_type IS NULL AND cp_load_cal_type IS NULL))
221: AND ((load_ci_sequence_number = cp_load_ci_sequence_number) OR

Line 225: l_anonymous_number igs_as_anon_number.anonymous_number%TYPE;

221: AND ((load_ci_sequence_number = cp_load_ci_sequence_number) OR
222: (load_ci_sequence_number IS NULL AND cp_load_ci_sequence_number IS NULL));
223:
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);

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 342: TYPE t_temp_table IS TABLE OF igs_as_anon_number.anonymous_number%TYPE

338: || swaghmar 16-Jan-2006 Bug# 4951054
339: || swaghmar 23-Feb-2006 Bug# 5056679
340: */
341: -- Define a PL/SQL table to hold the Anonymous
342: TYPE t_temp_table IS TABLE OF igs_as_anon_number.anonymous_number%TYPE
343: INDEX BY BINARY_INTEGER;
344:
345: temp_table t_temp_table;
346:

Line 368: CURSOR c_count_anon_num(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,

364: FROM igs_as_anon_method anm
365: WHERE anm.load_cal_type = cp_load_cal_type;
366:
367: -- COUNT the NUMBER of Anonymous Numbers available for ASSESSMENT/SECTION methods
368: CURSOR c_count_anon_num(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
369: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
370: IS
371: SELECT COUNT(*)
372: FROM igs_as_anon_number ann

Line 369: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)

365: WHERE anm.load_cal_type = cp_load_cal_type;
366:
367: -- COUNT the NUMBER of Anonymous Numbers available for ASSESSMENT/SECTION methods
368: CURSOR c_count_anon_num(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
369: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
370: IS
371: SELECT COUNT(*)
372: FROM igs_as_anon_number ann
373: WHERE ann.load_cal_type = cp_load_cal_type

Line 372: FROM igs_as_anon_number ann

368: CURSOR c_count_anon_num(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
369: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
370: IS
371: SELECT COUNT(*)
372: FROM igs_as_anon_number ann
373: WHERE ann.load_cal_type = cp_load_cal_type
374: AND ann.load_ci_sequence_number = cp_load_ci_sequence_number;
375:
376: -- COUNT the NUMBER of Anonymous Numbers available for the PROGRAM method

Line 380: FROM igs_as_anon_number ann

376: -- COUNT the NUMBER of Anonymous Numbers available for the PROGRAM method
377: CURSOR c_count_anon_num_prog
378: IS
379: SELECT COUNT(*)
380: FROM igs_as_anon_number ann
381: WHERE ann.load_cal_type IS NULL;
382:
383:
384: -- Count the number of Student Program Attempts

Line 398: CURSOR c_count_section_reqd(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,

394:
395:
396: -- Count the Student Unit Attempts for Unit Sections with anonymous assessment item
397: -- OR unit grading
398: CURSOR c_count_section_reqd(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
399: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
400: IS
401: SELECT COUNT(*)
402: FROM igs_en_su_attempt sua,

Line 399: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)

395:
396: -- Count the Student Unit Attempts for Unit Sections with anonymous assessment item
397: -- OR unit grading
398: CURSOR c_count_section_reqd(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
399: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
400: IS
401: SELECT COUNT(*)
402: FROM igs_en_su_attempt sua,
403: igs_ps_unit_ofr_opt uoo,

Line 429: CURSOR c_count_assessment_reqd(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,

425:
426:
427: -- Count the Student Unit Attempt Assessment Items for anonymous Assessment Types
428: -- in anonymous Unit Sections
429: CURSOR c_count_assessment_reqd(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
430: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
431: IS
432: SELECT COUNT(*)
433: FROM(

Line 430: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)

426:
427: -- Count the Student Unit Attempt Assessment Items for anonymous Assessment Types
428: -- in anonymous Unit Sections
429: CURSOR c_count_assessment_reqd(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
430: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
431: IS
432: SELECT COUNT(*)
433: FROM(
434: SELECT DISTINCT sua.person_id, ast.assessment_type

Line 487: CURSOR c_sua(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,

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
487: CURSOR c_sua(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
488: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
489: IS
490: SELECT sua.person_id,
491: sua.course_cd,

Line 488: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)

484: AND anip.course_cd = spa.course_cd);
485:
486: -- Search for all Student Unit Attempts related to the Load Calendar
487: CURSOR c_sua(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
488: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
489: IS
490: SELECT sua.person_id,
491: sua.course_cd,
492: sua.unit_cd,

Line 521: CURSOR c_suaai(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,

517: AND aniu.teach_ci_sequence_number = sua.ci_sequence_number
518: AND aniu.uoo_id = sua.uoo_id);
519:
520: -- Search for all Student Unit Attempt Assessment Items related to the Load Calendar
521: CURSOR c_suaai(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
522: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
523: IS
524: SELECT DISTINCT sua.person_id,
525: ast.assessment_type

Line 522: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)

518: AND aniu.uoo_id = sua.uoo_id);
519:
520: -- Search for all Student Unit Attempt Assessment Items related to the Load Calendar
521: CURSOR c_suaai(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
522: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
523: IS
524: SELECT DISTINCT sua.person_id,
525: ast.assessment_type
526: FROM igs_ca_teach_to_load_v ttl,

Line 567: CURSOR c_ass_delete(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,

563:
564:
565: -- Find all the records in the Context Load Calendar for ASSESSMENT method
566: -- (To delete the records when P_REALLOCATE_ID = 'Y')
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

Line 568: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)

564:
565: -- Find all the records in the Context Load Calendar for ASSESSMENT method
566: -- (To delete the records when P_REALLOCATE_ID = 'Y')
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

Line 577: CURSOR c_section_delete(cp_load_cal_type igs_as_anon_number.load_cal_type%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
576: -- (To delete the records when P_REALLOCATE_ID = 'Y')
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

Line 578: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)

574:
575: -- Find all the records in the Context Load Calendar for SECTION method
576: -- (To delete the records when P_REALLOCATE_ID = 'Y')
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

Line 597: FROM igs_as_anon_number ann

593: -- (To delete the records when P_REALLOCATE_ID = 'Y')
594: CURSOR c_anon_num_delete_prog
595: IS
596: SELECT ROWID
597: FROM igs_as_anon_number ann
598: WHERE ann.load_cal_type IS NULL;
599:
600: -- Find all records of SECTION/ASSESSMENT method
601: -- (To delete the records when P_REALLOCATE_ID = 'Y')

Line 602: CURSOR c_anon_num_delete(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,

598: WHERE ann.load_cal_type IS NULL;
599:
600: -- Find all records of SECTION/ASSESSMENT method
601: -- (To delete the records when P_REALLOCATE_ID = 'Y')
602: CURSOR c_anon_num_delete(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
603: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
604: IS
605: SELECT ROWID
606: FROM igs_as_anon_number ann

Line 603: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)

599:
600: -- Find all records of SECTION/ASSESSMENT method
601: -- (To delete the records when P_REALLOCATE_ID = 'Y')
602: CURSOR c_anon_num_delete(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
603: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
604: IS
605: SELECT ROWID
606: FROM igs_as_anon_number ann
607: WHERE ann.load_cal_type = cp_load_cal_type

Line 606: FROM igs_as_anon_number ann

602: CURSOR c_anon_num_delete(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
603: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
604: IS
605: SELECT ROWID
606: FROM igs_as_anon_number ann
607: WHERE ann.load_cal_type = cp_load_cal_type
608: AND ann.load_ci_sequence_number = cp_load_ci_sequence_number;
609:
610: -- To get the Parameter Value

Line 621: CURSOR c_cal(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,

617: AND VIEW_APPLICATION_ID = 8405 AND SECURITY_GROUP_ID = 0
618: AND lookup_code = p_reallocate_anon_id;
619:
620: -- To get the Start and End date of the Calander
621: CURSOR c_cal(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
622: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
623: IS
624: SELECT alternate_code,start_dt, end_dt
625: FROM igs_ca_inst

Line 622: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)

618: AND lookup_code = p_reallocate_anon_id;
619:
620: -- To get the Start and End date of the Calander
621: CURSOR c_cal(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
622: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
623: IS
624: SELECT alternate_code,start_dt, end_dt
625: FROM igs_ca_inst
626: WHERE cal_type = cp_load_cal_type

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,