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.

[Home] [Help]

APPS.IGS_AS_GEN_004 dependencies on IGS_PS_UNIT_OFR_PAT

Line 776: cp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,

772: AND ucl.unit_class LIKE NVL (p_unit_class, ucl.unit_class)
773: )
774: );
775: CURSOR c_ms1 (
776: cp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
777: cp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,
778: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
779: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
780: cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE

Line 777: cp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,

773: )
774: );
775: CURSOR c_ms1 (
776: cp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
777: cp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,
778: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
779: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
780: cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE
781: ) IS

Line 778: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,

774: );
775: CURSOR c_ms1 (
776: cp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
777: cp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,
778: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
779: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
780: cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE
781: ) IS
782: SELECT sheet_number

Line 779: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,

775: CURSOR c_ms1 (
776: cp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
777: cp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,
778: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
779: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
780: cp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE
781: ) IS
782: SELECT sheet_number
783: FROM igs_as_mark_sheet ms

Line 829: lp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,

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,
831: lp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
832: lp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
833: lp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE,

Line 830: lp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,

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,
831: lp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
832: lp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
833: lp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE,
834: lp_group_sequence_number IN igs_as_mark_sheet.group_sequence_number%TYPE,

Line 831: lp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%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,
831: lp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
832: lp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
833: lp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE,
834: lp_group_sequence_number IN igs_as_mark_sheet.group_sequence_number%TYPE,
835: lp_uoo_id IN NUMBER

Line 832: lp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%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,
831: lp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
832: lp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,
833: lp_ms_sequence_number IN igs_as_mark_sheet.sheet_number%TYPE,
834: lp_group_sequence_number IN igs_as_mark_sheet.group_sequence_number%TYPE,
835: lp_uoo_id IN NUMBER
836: ) IS

Line 840: cp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,

836: ) IS
837: -- select the students to be included (where p_assess_cal_type is specified)
838: -- in mark sheets and ORDER BY person_id
839: CURSOR c_sua_person_id (
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,

Line 841: cp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,

837: -- select the students to be included (where p_assess_cal_type is specified)
838: -- in mark sheets and ORDER BY person_id
839: CURSOR c_sua_person_id (
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,

Line 842: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,

838: -- in mark sheets and ORDER BY person_id
839: CURSOR c_sua_person_id (
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

Line 843: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,

839: CURSOR c_sua_person_id (
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

Line 905: cp_uop_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,

901: -- select the students to be included (where p_assess_cal_type is specified)
902: -- in mark sheets and ORDER BY pe.person_name, person_id
903: --
904: CURSOR c_sua_surname (
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,

Line 906: cp_uop_version_number IN igs_ps_unit_ofr_pat.version_number%TYPE,

902: -- in mark sheets and ORDER BY pe.person_name, person_id
903: --
904: CURSOR c_sua_surname (
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,

Line 907: cp_uop_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,

903: --
904: CURSOR c_sua_surname (
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

Line 908: cp_uop_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE,

904: CURSOR c_sua_surname (
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