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_PR_CP_GPA dependencies on IGS_CA_INST

Line 100: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

96: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
97: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
98: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
99: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
100: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
101: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
102: p_cumulative_ind IN VARCHAR2,
103: p_include_local_ind IN VARCHAR2,
104: p_include_other_ind IN VARCHAR2,

Line 101: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

97: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
98: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
99: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
100: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
101: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
102: p_cumulative_ind IN VARCHAR2,
103: p_include_local_ind IN VARCHAR2,
104: p_include_other_ind IN VARCHAR2,
105: p_earned_cp OUT NOCOPY NUMBER,

Line 826: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

822: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
823: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
824: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
825: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
826: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
827: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
828: p_cumulative_ind IN VARCHAR2,
829: p_include_local_ind IN VARCHAR2,
830: p_include_other_ind IN VARCHAR2,

Line 827: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

823: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
824: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
825: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
826: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
827: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
828: p_cumulative_ind IN VARCHAR2,
829: p_include_local_ind IN VARCHAR2,
830: p_include_other_ind IN VARCHAR2,
831: p_earned_cp OUT NOCOPY NUMBER,

Line 873: FROM igs_av_stnd_unit asu, igs_or_inst_org_base_v inst, igs_ca_inst ci

869: asu.grading_schema_cd,
870: asu.grd_sch_version_number,
871: asu.grade,
872: asu.av_stnd_unit_id
873: FROM igs_av_stnd_unit asu, igs_or_inst_org_base_v inst, igs_ca_inst ci
874: WHERE asu.person_id = p_person_id
875: AND asu.as_course_cd = p_course_cd
876: AND asu.s_adv_stnd_granting_status IN ('GRANTED', 'APPROVED')
877: AND asu.s_adv_stnd_recognition_type = 'CREDIT'

Line 891: FROM igs_ca_inst ci2

887: AND p_load_cal_type = asu.cal_type
888: AND p_load_ci_sequence_number = asu.ci_sequence_number)
889: OR (p_cumulative_ind = 'Y'
890: AND 0 < (SELECT COUNT(*)
891: FROM igs_ca_inst ci2
892: WHERE p_load_cal_type = ci2.cal_type
893: AND p_load_ci_sequence_number =
894: ci2.sequence_number
895: AND ci.start_dt <= ci2.start_dt)));

Line 910: FROM igs_av_stnd_unit_lvl asul, igs_or_inst_org_base_v inst, igs_ca_inst ci

906: AND gsg.grade = cp_grade;
907:
908: CURSOR c_asul IS
909: SELECT SUM(NVL(asul.credit_points, 0)) sumvalue
910: FROM igs_av_stnd_unit_lvl asul, igs_or_inst_org_base_v inst, igs_ca_inst ci
911: WHERE asul.person_id = p_person_id
912: AND asul.as_course_cd = p_course_cd
913: AND asul.s_adv_stnd_granting_status IN ('GRANTED', 'APPROVED')
914: AND NVL(asul.expiry_dt, SYSDATE + 1) > SYSDATE

Line 927: FROM igs_ca_inst ci2

923: AND p_load_cal_type = asul.cal_type
924: AND p_load_ci_sequence_number = asul.ci_sequence_number)
925: OR (p_cumulative_ind = 'Y'
926: AND 0 < (SELECT COUNT(*)
927: FROM igs_ca_inst ci2
928: WHERE p_load_cal_type = ci2.cal_type
929: AND p_load_ci_sequence_number =
930: ci2.sequence_number
931: AND ci.start_dt <= ci2.start_dt)));

Line 1573: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,

1569: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
1570: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
1571: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
1572: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
1573: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,
1574: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1575: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
1576: p_system_stat IN VARCHAR2,
1577: p_earned_cp OUT NOCOPY NUMBER,

Line 1574: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

1570: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
1571: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
1572: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
1573: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,
1574: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1575: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
1576: p_system_stat IN VARCHAR2,
1577: p_earned_cp OUT NOCOPY NUMBER,
1578: p_attempted_cp OUT NOCOPY NUMBER,

Line 1715: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,

1711: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
1712: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
1713: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
1714: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
1715: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,
1716: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1717: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
1718: p_system_stat IN VARCHAR2,
1719: p_init_msg_list IN VARCHAR2,

Line 1716: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

1712: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
1713: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
1714: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
1715: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,
1716: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1717: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
1718: p_system_stat IN VARCHAR2,
1719: p_init_msg_list IN VARCHAR2,
1720: p_gpa_value OUT NOCOPY NUMBER,

Line 1849: p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,

1845: PROCEDURE get_all_stats(
1846: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
1847: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,
1848: p_stat_type IN igs_pr_stat_type.stat_type%TYPE ,
1849: p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,
1850: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
1851: p_system_stat IN VARCHAR2,
1852: p_cumulative_ind IN VARCHAR2,
1853: p_earned_cp OUT NOCOPY NUMBER,

Line 1850: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,

1846: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
1847: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,
1848: p_stat_type IN igs_pr_stat_type.stat_type%TYPE ,
1849: p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,
1850: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
1851: p_system_stat IN VARCHAR2,
1852: p_cumulative_ind IN VARCHAR2,
1853: p_earned_cp OUT NOCOPY NUMBER,
1854: p_attempted_cp OUT NOCOPY NUMBER,

Line 1900: p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,

1896: PROCEDURE get_all_stats_new(
1897: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
1898: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,
1899: p_stat_type IN igs_pr_stat_type.stat_type%TYPE ,
1900: p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,
1901: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
1902: p_system_stat IN VARCHAR2,
1903: p_cumulative_ind IN VARCHAR2,
1904: p_earned_cp OUT NOCOPY NUMBER,

Line 1901: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,

1897: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
1898: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,
1899: p_stat_type IN igs_pr_stat_type.stat_type%TYPE ,
1900: p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,
1901: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
1902: p_system_stat IN VARCHAR2,
1903: p_cumulative_ind IN VARCHAR2,
1904: p_earned_cp OUT NOCOPY NUMBER,
1905: p_attempted_cp OUT NOCOPY NUMBER,

Line 1944: FROM igs_en_su_attempt_ALL sua, igs_ca_inst ci1

1940: --
1941: CURSOR c_sua_uv IS
1942: SELECT sua.person_id,sua.course_cd, sua.unit_cd, sua.version_number, sua.cal_type, sua.ci_sequence_number,
1943: sua.uoo_id ,sua.unit_attempt_status
1944: FROM igs_en_su_attempt_ALL sua, igs_ca_inst ci1
1945: WHERE sua.person_id = p_person_id
1946: AND sua.course_cd = p_course_cd
1947: AND sua.unit_attempt_status IN
1948: ('COMPLETED', 'DUPLICATE', 'ENROLLED', 'DISCONTIN')

Line 1963: FROM igs_ca_inst ci2, igs_ca_load_to_teach_v ltt2

1959: ltt1.teach_ci_sequence_number)
1960: )
1961: OR ( p_cumulative_ind = 'Y'
1962: AND EXISTS ( SELECT 'X'
1963: FROM igs_ca_inst ci2, igs_ca_load_to_teach_v ltt2
1964: WHERE ci2.cal_type = p_load_cal_type
1965: AND ci2.sequence_number =
1966: p_load_ci_sequence_number
1967: AND sua.cal_type = ltt2.teach_cal_type

Line 2347: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

2343: PROCEDURE get_cp_stats(
2344: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
2345: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
2346: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
2347: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2348: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2349: p_system_stat IN VARCHAR2,
2350: p_cumulative_ind IN VARCHAR2,
2351: p_earned_cp OUT NOCOPY NUMBER,

Line 2348: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

2344: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
2345: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
2346: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
2347: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2348: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2349: p_system_stat IN VARCHAR2,
2350: p_cumulative_ind IN VARCHAR2,
2351: p_earned_cp OUT NOCOPY NUMBER,
2352: p_attempted_cp OUT NOCOPY NUMBER,

Line 2463: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

2459: PROCEDURE get_gpa_stats(
2460: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
2461: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
2462: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
2463: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2464: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2465: p_system_stat IN VARCHAR2,
2466: p_cumulative_ind IN VARCHAR2,
2467: p_gpa_value OUT NOCOPY NUMBER,

Line 2464: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

2460: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
2461: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
2462: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
2463: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2464: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2465: p_system_stat IN VARCHAR2,
2466: p_cumulative_ind IN VARCHAR2,
2467: p_gpa_value OUT NOCOPY NUMBER,
2468: p_gpa_cp OUT NOCOPY NUMBER,