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_ADI_UPLD_AIO_PKG dependencies on IGS_EN_SU_ATTEMPT

Line 5: p_person_id IN igs_en_su_attempt.person_id%TYPE,

1: PACKAGE BODY igs_as_adi_upld_aio_pkg AS
2: /* $Header: IGSAS44B.pls 120.7 2006/05/29 06:26:14 ijeddy ship $ */
3: --
4: FUNCTION get_sua_yop (
5: p_person_id IN igs_en_su_attempt.person_id%TYPE,
6: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
7: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
9: ) RETURN VARCHAR2 AS

Line 6: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

2: /* $Header: IGSAS44B.pls 120.7 2006/05/29 06:26:14 ijeddy ship $ */
3: --
4: FUNCTION get_sua_yop (
5: p_person_id IN igs_en_su_attempt.person_id%TYPE,
6: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
7: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
9: ) RETURN VARCHAR2 AS
10: --

Line 7: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

3: --
4: FUNCTION get_sua_yop (
5: p_person_id IN igs_en_su_attempt.person_id%TYPE,
6: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
7: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
9: ) RETURN VARCHAR2 AS
10: --
11: -- This function returns the Unit Set Code of any YOP specific Student Unit

Line 8: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE

4: FUNCTION get_sua_yop (
5: p_person_id IN igs_en_su_attempt.person_id%TYPE,
6: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
7: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE
9: ) RETURN VARCHAR2 AS
10: --
11: -- This function returns the Unit Set Code of any YOP specific Student Unit
12: -- Set Attempts which have Selection and Requirements Complete/End Dates

Line 74: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,

70: --
71: -- Get the uoo_id based on the pk columns for Unit Section
72: --
73: CURSOR cur_uoo_id (
74: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
75: cp_version_number igs_en_su_attempt.version_number%TYPE,
76: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
77: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
78: cp_unit_class igs_en_su_attempt.unit_class%TYPE,

Line 75: cp_version_number igs_en_su_attempt.version_number%TYPE,

71: -- Get the uoo_id based on the pk columns for Unit Section
72: --
73: CURSOR cur_uoo_id (
74: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
75: cp_version_number igs_en_su_attempt.version_number%TYPE,
76: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
77: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
78: cp_unit_class igs_en_su_attempt.unit_class%TYPE,
79: cp_location_cd igs_en_su_attempt.location_cd%TYPE

Line 76: cp_cal_type igs_en_su_attempt.cal_type%TYPE,

72: --
73: CURSOR cur_uoo_id (
74: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
75: cp_version_number igs_en_su_attempt.version_number%TYPE,
76: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
77: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
78: cp_unit_class igs_en_su_attempt.unit_class%TYPE,
79: cp_location_cd igs_en_su_attempt.location_cd%TYPE
80: ) IS

Line 77: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

73: CURSOR cur_uoo_id (
74: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
75: cp_version_number igs_en_su_attempt.version_number%TYPE,
76: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
77: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
78: cp_unit_class igs_en_su_attempt.unit_class%TYPE,
79: cp_location_cd igs_en_su_attempt.location_cd%TYPE
80: ) IS
81: SELECT uoo_id

Line 78: cp_unit_class igs_en_su_attempt.unit_class%TYPE,

74: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
75: cp_version_number igs_en_su_attempt.version_number%TYPE,
76: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
77: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
78: cp_unit_class igs_en_su_attempt.unit_class%TYPE,
79: cp_location_cd igs_en_su_attempt.location_cd%TYPE
80: ) IS
81: SELECT uoo_id
82: FROM igs_ps_unit_ofr_opt

Line 79: cp_location_cd igs_en_su_attempt.location_cd%TYPE

75: cp_version_number igs_en_su_attempt.version_number%TYPE,
76: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
77: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
78: cp_unit_class igs_en_su_attempt.unit_class%TYPE,
79: cp_location_cd igs_en_su_attempt.location_cd%TYPE
80: ) IS
81: SELECT uoo_id
82: FROM igs_ps_unit_ofr_opt
83: WHERE unit_cd = cp_unit_cd

Line 621: CURSOR c_assessment_id (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

617: WHERE hzp.party_number = p_person_number;
618: --
619: --
620: --
621: CURSOR c_assessment_id (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
622: SELECT ai.ass_id,
623: gs.grading_schema_cd,
624: gs.version_number
625: FROM igs_as_assessmnt_itm ai,

Line 669: cp_cal_type igs_en_su_attempt_all.cal_type%TYPE,

665: --
666: --
667: --
668: CURSOR c_uoo_id (
669: cp_cal_type igs_en_su_attempt_all.cal_type%TYPE,
670: cp_ci_sequence_number igs_en_su_attempt_all.ci_sequence_number%TYPE,
671: cp_person_id hz_parties.party_id%TYPE
672: ) IS
673: SELECT uoo_id

Line 670: cp_ci_sequence_number igs_en_su_attempt_all.ci_sequence_number%TYPE,

666: --
667: --
668: CURSOR c_uoo_id (
669: cp_cal_type igs_en_su_attempt_all.cal_type%TYPE,
670: cp_ci_sequence_number igs_en_su_attempt_all.ci_sequence_number%TYPE,
671: cp_person_id hz_parties.party_id%TYPE
672: ) IS
673: SELECT uoo_id
674: FROM igs_en_su_attempt_all

Line 674: FROM igs_en_su_attempt_all

670: cp_ci_sequence_number igs_en_su_attempt_all.ci_sequence_number%TYPE,
671: cp_person_id hz_parties.party_id%TYPE
672: ) IS
673: SELECT uoo_id
674: FROM igs_en_su_attempt_all
675: WHERE unit_cd = p_unit_cd
676: AND cal_type = cp_cal_type
677: AND ci_sequence_number = cp_ci_sequence_number
678: AND person_id = cp_person_id

Line 694: cp_person_id igs_en_su_attempt_all.person_id%TYPE,

690: --
691: --
692: --
693: CURSOR c_unit_enroll_status (
694: cp_person_id igs_en_su_attempt_all.person_id%TYPE,
695: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
696: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE
697: ) IS
698: SELECT unit_attempt_status

Line 695: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

691: --
692: --
693: CURSOR c_unit_enroll_status (
694: cp_person_id igs_en_su_attempt_all.person_id%TYPE,
695: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
696: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE
697: ) IS
698: SELECT unit_attempt_status
699: FROM igs_en_su_attempt_all

Line 696: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE

692: --
693: CURSOR c_unit_enroll_status (
694: cp_person_id igs_en_su_attempt_all.person_id%TYPE,
695: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
696: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE
697: ) IS
698: SELECT unit_attempt_status
699: FROM igs_en_su_attempt_all
700: WHERE person_id = cp_person_id

Line 699: FROM igs_en_su_attempt_all

695: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
696: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE
697: ) IS
698: SELECT unit_attempt_status
699: FROM igs_en_su_attempt_all
700: WHERE person_id = cp_person_id
701: AND course_cd = cp_course_cd
702: AND uoo_id = cp_uoo_id;
703: --

Line 707: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,

703: --
704: --
705: --
706: CURSOR c_ass_item_exist (
707: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
708: cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE,
709: cp_person_id hz_parties.party_id%TYPE,
710: cp_reference VARCHAR2
711: ) IS

Line 724: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,

720: --
721: --
722: --
723: CURSOR c_ass_item_grade_exist (
724: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
725: cp_person_id hz_parties.party_id%TYPE,
726: cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE,
727: cp_reference VARCHAR2
728: ) IS