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_GEN_004 dependencies on IGS_PS_UNIT_OFR_OPT

Line 209: v_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE;

205: v_student_seq NUMBER DEFAULT 1;
206: v_parse_command VARCHAR2 (1000);
207: v_get_record igs_as_ins_grd_entry%ROWTYPE;
208: v_initials igs_pe_person.given_names%TYPE;
209: v_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE;
210: v_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
211: v_unit_mode igs_as_unit_class.unit_mode%TYPE;
212: CURSOR c_chk_keying_time (cp_keying_time DATE, cp_keying_who igs_as_ins_grd_entry.keying_who%TYPE) IS
213: SELECT 'x'

Line 210: v_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;

206: v_parse_command VARCHAR2 (1000);
207: v_get_record igs_as_ins_grd_entry%ROWTYPE;
208: v_initials igs_pe_person.given_names%TYPE;
209: v_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE;
210: v_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
211: v_unit_mode igs_as_unit_class.unit_mode%TYPE;
212: CURSOR c_chk_keying_time (cp_keying_time DATE, cp_keying_who igs_as_ins_grd_entry.keying_who%TYPE) IS
213: SELECT 'x'
214: FROM DUAL

Line 357: FROM igs_ps_unit_ofr_opt uoo,

353: sua.unit_attempt_status,
354: pe.person_last_name surname,
355: igs_ge_gen_002.genp_get_initials (pe.person_first_name),
356: sua.version_number
357: FROM igs_ps_unit_ofr_opt uoo,
358: igs_en_su_attempt sua,
359: hz_parties pe,
360: igs_as_unit_class ucl
361: WHERE uoo.unit_cd = p_unit_cd

Line 385: FROM igs_ps_unit_ofr_opt uoo,

381: sua.unit_attempt_status,
382: pe.person_last_name surname,
383: igs_ge_gen_002.genp_get_initials (pe.person_first_name),
384: sua.version_number
385: FROM igs_ps_unit_ofr_opt uoo,
386: igs_en_su_attempt sua,
387: hz_parties pe,
388: igs_as_unit_class ucl
389: WHERE uoo.unit_cd = p_unit_cd

Line 420: FROM igs_ps_unit_ofr_opt uoo,

416: sua.unit_attempt_status,
417: pe.person_last_name surname,
418: igs_ge_gen_002.genp_get_initials (pe.person_first_name),
419: sua.version_number
420: FROM igs_ps_unit_ofr_opt uoo,
421: igs_en_su_attempt sua,
422: hz_parties pe,
423: igs_as_unit_class ucl
424: WHERE uoo.unit_cd = cp_unit_cd

Line 453: FROM igs_ps_unit_ofr_opt uoo,

449: sua.unit_attempt_status,
450: pe.person_last_name surname,
451: igs_ge_gen_002.genp_get_initials (pe.person_first_name),
452: sua.version_number
453: FROM igs_ps_unit_ofr_opt uoo,
454: igs_en_su_attempt sua,
455: hz_parties pe,
456: igs_as_unit_class ucl
457: WHERE uoo.unit_cd = cp_unit_cd

Line 725: cp_teach_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,

721: v_update_who igs_as_msht_su_atmpt.last_updated_by%TYPE;
722: CURSOR c_uop (
723: cp_assess_cal_type IN igs_ca_inst.cal_type%TYPE,
724: cp_assess_sequence_number IN igs_ca_inst.sequence_number%TYPE,
725: cp_teach_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,
726: cp_teach_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE
727: ) IS
728: SELECT DISTINCT uop.unit_cd,
729: uop.version_number,

Line 726: cp_teach_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE

722: CURSOR c_uop (
723: cp_assess_cal_type IN igs_ca_inst.cal_type%TYPE,
724: cp_assess_sequence_number IN igs_ca_inst.sequence_number%TYPE,
725: cp_teach_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,
726: cp_teach_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE
727: ) IS
728: SELECT DISTINCT uop.unit_cd,
729: uop.version_number,
730: uop.cal_type,

Line 735: FROM igs_ps_unit_ofr_opt uop,

731: uop.ci_sequence_number,
732: uop.location_cd,
733: ucl.unit_mode,
734: uop.uoo_id
735: FROM igs_ps_unit_ofr_opt uop,
736: igs_as_unit_class ucl,
737: igs_ca_inst ci,
738: igs_ps_unit_ver uv,
739: igs_ca_stat cs,

Line 826: lp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,

822: ----------------------------------------ASSPL_INS_MSSUA_SORT--------------------
823: -- procedure used to mainly insert student records (orderd by
824: -- PERSON_ID/SURNAME) into MSSUA
825: PROCEDURE asspl_ins_mssua_sort (
826: lp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
827: lp_unit_mode IN igs_as_unit_class.unit_mode%TYPE,
828: lp_sort_by IN VARCHAR2,
829: lp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
830: lp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,

Line 844: cp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,

840: cp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
841: cp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,
842: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
843: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
844: cp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
845: cp_unit_mode IN igs_as_unit_class.unit_mode%TYPE,
846: cp_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
847: ) IS
848: SELECT sua.person_id,

Line 909: cp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,

905: cp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
906: cp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,
907: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
908: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
909: cp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
910: cp_unit_mode IN igs_as_unit_class.unit_mode%TYPE,
911: cp_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
912: ) IS
913: SELECT pe.person_last_name surname,

Line 1435: FROM igs_ps_unit_ofr_opt

1431: -- Get the Unit Section ID
1432: --
1433: /* CURSOR cur_uoo_id IS
1434: SELECT uoo_id
1435: FROM igs_ps_unit_ofr_opt
1436: WHERE unit_cd = p_unit_cd
1437: AND version_number = p_version_number
1438: AND cal_type = p_cal_type
1439: AND ci_sequence_number = p_ci_sequence_number