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_EN_STDNT_PS_ATT

Line 54: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

50: --
51: -- Forward Declaration of Local procedures
52: --
53: PROCEDURE get_stat_dtls(
54: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
55: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
56: p_system_stat IN VARCHAR2,
57: p_cumulative_ind IN VARCHAR2,
58: p_stat_type IN OUT NOCOPY igs_pr_stat_type.stat_type%TYPE,

Line 55: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

51: -- Forward Declaration of Local procedures
52: --
53: PROCEDURE get_stat_dtls(
54: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
55: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
56: p_system_stat IN VARCHAR2,
57: p_cumulative_ind IN VARCHAR2,
58: p_stat_type IN OUT NOCOPY igs_pr_stat_type.stat_type%TYPE,
59: p_org_unit_cd OUT NOCOPY igs_pr_org_stat.org_unit_cd%TYPE,

Line 96: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

92: -- swaghmar; 15-Sep-2005; Bug 4491456
93: -- Modified the signature
94:
95: PROCEDURE get_adv_stats(
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,

Line 97: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

93: -- Modified the signature
94:
95: PROCEDURE get_adv_stats(
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,

Line 401: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

397:
398:
399:
400: PROCEDURE get_stat_dtls(
401: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
402: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
403: p_system_stat IN VARCHAR2,
404: p_cumulative_ind IN VARCHAR2,
405: p_stat_type IN OUT NOCOPY igs_pr_stat_type.stat_type%TYPE,

Line 402: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

398:
399:
400: PROCEDURE get_stat_dtls(
401: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
402: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
403: p_system_stat IN VARCHAR2,
404: p_cumulative_ind IN VARCHAR2,
405: p_stat_type IN OUT NOCOPY igs_pr_stat_type.stat_type%TYPE,
406: p_org_unit_cd OUT NOCOPY igs_pr_org_stat.org_unit_cd%TYPE,

Line 440: FROM igs_en_stdnt_ps_att spa,

436: st.derivation,
437: orst.include_standard_ind,
438: orst.include_local_ind,
439: orst.include_other_ind
440: FROM igs_en_stdnt_ps_att spa,
441: igs_ps_ver crv,
442: igs_pr_stat_type st,
443: igs_pr_org_stat orst
444: WHERE spa.person_id = p_person_id

Line 822: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

818: RETURN NULL;
819: END chk_unit_ref_cd;
820:
821: PROCEDURE get_adv_stats(
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,

Line 823: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

819: END chk_unit_ref_cd;
820:
821: PROCEDURE get_adv_stats(
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,

Line 1106: FROM igs_en_stdnt_ps_att spa,

1102: SELECT sua.unit_attempt_status,
1103: NVL(sua.override_achievable_cp , sua.override_enrolled_cp ) sua_override_cp,
1104: NVL(uc.achievable_credit_points, uc.enrolled_credit_points) uc_credit_points,
1105: NVL(uv.achievable_credit_points, uv.enrolled_credit_points) uv_credit_points
1106: FROM igs_en_stdnt_ps_att spa,
1107: igs_ps_ver pv,
1108: igs_en_su_attempt_ALL sua,
1109: igs_ps_unit_ver uv,
1110: igs_ps_usec_cps uc

Line 1569: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

1565: -- kdande; 23-Apr-2003; Bug# 2829262
1566: -- Added p_uoo_id parameter to the FUNCTION get_sua_cp
1567: --
1568: PROCEDURE get_sua_cp(
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,

Line 1570: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

1566: -- Added p_uoo_id parameter to the FUNCTION get_sua_cp
1567: --
1568: PROCEDURE get_sua_cp(
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,

Line 1711: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

1707: -- Added p_uoo_id parameter to the FUNCTION get_sua_gpa
1708: -- swaghmar; 15-Sep-2005; Bug 4491456 - Modified the signature
1709: --
1710: PROCEDURE get_sua_gpa(
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,

Line 1712: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

1708: -- swaghmar; 15-Sep-2005; Bug 4491456 - Modified the signature
1709: --
1710: PROCEDURE get_sua_gpa(
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,

Line 1846: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,

1842: -- Modified the signature
1843: --
1844:
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 ,

Line 1847: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,

1843: --
1844:
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,

Line 1897: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,

1893: -- Modified the signature
1894: --
1895:
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 ,

Line 1898: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,

1894: --
1895:
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,

Line 2344: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

2340: -- swaghmar; 15-Sep-2005; Bug 4491456
2341: -- Modified the signature
2342: --
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,

Line 2345: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

2341: -- Modified the signature
2342: --
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,

Line 2460: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

2456: p_data => p_msg_data);
2457: END get_cp_stats;
2458:
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,

Line 2461: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

2457: END get_cp_stats;
2458:
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,