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_PR_STAT_TYPE

Line 58: p_stat_type IN OUT NOCOPY igs_pr_stat_type.stat_type%TYPE,

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,
60: p_include_std_ind OUT NOCOPY igs_pr_org_stat.include_standard_ind%TYPE,
61: p_include_local_ind OUT NOCOPY igs_pr_org_stat.include_local_ind%TYPE,
62: p_include_other_ind OUT NOCOPY igs_pr_org_stat.include_other_ind%TYPE,

Line 63: p_derivation OUT NOCOPY igs_pr_stat_type.derivation%TYPE,

59: p_org_unit_cd OUT NOCOPY igs_pr_org_stat.org_unit_cd%TYPE,
60: p_include_std_ind OUT NOCOPY igs_pr_org_stat.include_standard_ind%TYPE,
61: p_include_local_ind OUT NOCOPY igs_pr_org_stat.include_local_ind%TYPE,
62: p_include_other_ind OUT NOCOPY igs_pr_org_stat.include_other_ind%TYPE,
63: p_derivation OUT NOCOPY igs_pr_stat_type.derivation%TYPE,
64: p_init_msg_list IN VARCHAR2,
65: p_return_status OUT NOCOPY VARCHAR2,
66: p_msg_count OUT NOCOPY NUMBER,
67: p_msg_data OUT NOCOPY VARCHAR2);

Line 73: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,

69: FUNCTION chk_unit_ref_cd(
70: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
71: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
72: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
73: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
74: p_init_msg_list IN VARCHAR2,
75: p_return_status OUT NOCOPY VARCHAR2,
76: p_msg_count OUT NOCOPY NUMBER,
77: p_msg_data OUT NOCOPY VARCHAR2)

Line 85: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,

81: P_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
82: P_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
83: P_uoo_id IN NUMBER,
84: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
85: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
86: p_init_msg_list IN VARCHAR2,
87: p_return_status OUT NOCOPY VARCHAR2,
88: p_msg_count OUT NOCOPY NUMBER,
89: p_msg_data OUT NOCOPY VARCHAR2)

Line 98: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,

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,
102: p_cumulative_ind IN VARCHAR2,

Line 144: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,

140:
141: FUNCTION chk_av_unit_ref_cd (
142: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,
143: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
144: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
145: p_init_msg_list IN VARCHAR2,
146: p_return_status OUT NOCOPY VARCHAR2,
147: p_msg_count OUT NOCOPY NUMBER,
148: p_msg_data OUT NOCOPY VARCHAR2

Line 405: p_stat_type IN OUT NOCOPY igs_pr_stat_type.stat_type%TYPE,

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,
407: p_include_std_ind OUT NOCOPY igs_pr_org_stat.include_standard_ind%TYPE,
408: p_include_local_ind OUT NOCOPY igs_pr_org_stat.include_local_ind%TYPE,
409: p_include_other_ind OUT NOCOPY igs_pr_org_stat.include_other_ind%TYPE,

Line 410: p_derivation OUT NOCOPY igs_pr_stat_type.derivation%TYPE,

406: p_org_unit_cd OUT NOCOPY igs_pr_org_stat.org_unit_cd%TYPE,
407: p_include_std_ind OUT NOCOPY igs_pr_org_stat.include_standard_ind%TYPE,
408: p_include_local_ind OUT NOCOPY igs_pr_org_stat.include_local_ind%TYPE,
409: p_include_other_ind OUT NOCOPY igs_pr_org_stat.include_other_ind%TYPE,
410: p_derivation OUT NOCOPY igs_pr_stat_type.derivation%TYPE,
411: p_init_msg_list IN VARCHAR2,
412: p_return_status OUT NOCOPY VARCHAR2,
413: p_msg_count OUT NOCOPY NUMBER,
414: p_msg_data OUT NOCOPY VARCHAR2) IS

Line 442: igs_pr_stat_type st,

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
445: AND spa.course_cd = p_course_cd
446: AND spa.course_cd = crv.course_cd

Line 469: FROM igs_pr_stat_type st, igs_pr_inst_stat inst

465: st.derivation,
466: inst.include_standard_ind,
467: inst.include_local_ind,
468: inst.include_other_ind
469: FROM igs_pr_stat_type st, igs_pr_inst_stat inst
470: WHERE st.stat_type = inst.stat_type
471: AND (inst.stat_type = p_stat_type
472: OR p_stat_type IS NULL
473: AND ((p_system_stat IS NULL AND inst.standard_ind = 'Y')

Line 605: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,

601: FUNCTION chk_unit_ref_cd(
602: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
603: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
604: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
605: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
606: p_init_msg_list IN VARCHAR2,
607: p_return_status OUT NOCOPY VARCHAR2,
608: p_msg_count OUT NOCOPY NUMBER,
609: p_msg_data OUT NOCOPY VARCHAR2)

Line 824: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,

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,
828: p_cumulative_ind IN VARCHAR2,

Line 1340: l_stat_type igs_pr_stat_type.stat_type%TYPE;

1336: -- swaghmar; 15-Sep-2005; Bug 4491456 Modified the signature
1337: -- swaghmar; 15-Jun-2006; Bug 5260180
1338: --------------------------------------------------------------------------
1339:
1340: l_stat_type igs_pr_stat_type.stat_type%TYPE;
1341: l_org_unit_cd igs_pr_org_stat.org_unit_cd%TYPE;
1342: l_include_std_ind igs_pr_org_stat.include_standard_ind%TYPE;
1343: l_include_local_ind igs_pr_org_stat.include_local_ind%TYPE;
1344: l_include_other_ind igs_pr_org_stat.include_other_ind%TYPE;

Line 1345: l_derivation igs_pr_stat_type.derivation%TYPE;

1341: l_org_unit_cd igs_pr_org_stat.org_unit_cd%TYPE;
1342: l_include_std_ind igs_pr_org_stat.include_standard_ind%TYPE;
1343: l_include_local_ind igs_pr_org_stat.include_local_ind%TYPE;
1344: l_include_other_ind igs_pr_org_stat.include_other_ind%TYPE;
1345: l_derivation igs_pr_stat_type.derivation%TYPE;
1346: l_earned_cp NUMBER;
1347: l_attempted_cp NUMBER;
1348: l_gpa_cp NUMBER;
1349: l_gpa_quality_points NUMBER;

Line 1575: p_stat_type IN igs_pr_stat_type.stat_type%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,
1579: p_init_msg_list IN VARCHAR2,

Line 1717: p_stat_type IN igs_pr_stat_type.stat_type%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,
1721: p_gpa_cp OUT NOCOPY NUMBER,

Line 1848: p_stat_type IN igs_pr_stat_type.stat_type%TYPE ,

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,
1852: p_cumulative_ind IN VARCHAR2,

Line 1899: p_stat_type IN igs_pr_stat_type.stat_type%TYPE ,

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,
1903: p_cumulative_ind IN VARCHAR2,

Line 1976: CURSOR c_sas(cp_stat_type igs_pr_stat_type.stat_type%TYPE) IS

1972: )
1973: ORDER BY sua.unit_cd ASC, sua.ci_end_dt ASC;
1974:
1975:
1976: CURSOR c_sas(cp_stat_type igs_pr_stat_type.stat_type%TYPE) IS
1977: SELECT sas.earned_credit_points,
1978: sas.attempted_credit_points,
1979: sas.gpa,
1980: sas.gpa_credit_points,

Line 2002: l_stat_type igs_pr_stat_type.stat_type%TYPE;

1998: l_attempted_cp_total NUMBER := 0;
1999: l_gpa_cp_total NUMBER := 0;
2000: l_gpa_qp_total NUMBER := 0;
2001: l_gpa_value NUMBER := 0;
2002: l_stat_type igs_pr_stat_type.stat_type%TYPE;
2003: l_org_unit_cd igs_pr_org_stat.org_unit_cd%TYPE;
2004: l_include_std_ind igs_pr_org_stat.include_standard_ind%TYPE;
2005: l_include_local_ind igs_pr_org_stat.include_local_ind%TYPE;
2006: l_include_other_ind igs_pr_org_stat.include_other_ind%TYPE;

Line 2007: l_derivation igs_pr_stat_type.derivation%TYPE;

2003: l_org_unit_cd igs_pr_org_stat.org_unit_cd%TYPE;
2004: l_include_std_ind igs_pr_org_stat.include_standard_ind%TYPE;
2005: l_include_local_ind igs_pr_org_stat.include_local_ind%TYPE;
2006: l_include_other_ind igs_pr_org_stat.include_other_ind%TYPE;
2007: l_derivation igs_pr_stat_type.derivation%TYPE;
2008: l_init_msg_list VARCHAR2(20);
2009: l_return_status VARCHAR2(30);
2010: l_msg_count NUMBER(2);
2011: l_msg_data VARCHAR2(30);

Line 2346: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,

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,
2350: p_cumulative_ind IN VARCHAR2,

Line 2462: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,

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,
2466: p_cumulative_ind IN VARCHAR2,

Line 2588: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,

2584: P_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
2585: P_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
2586: P_uoo_id IN NUMBER,
2587: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
2588: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
2589: p_init_msg_list IN VARCHAR2,
2590: p_return_status OUT NOCOPY VARCHAR2,
2591: p_msg_count OUT NOCOPY NUMBER,
2592: p_msg_data OUT NOCOPY VARCHAR2)