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_ORG_STAT

Line 59: p_org_unit_cd OUT NOCOPY igs_pr_org_stat.org_unit_cd%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,
63: p_derivation OUT NOCOPY igs_pr_stat_type.derivation%TYPE,

Line 60: p_include_std_ind OUT NOCOPY igs_pr_org_stat.include_standard_ind%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,
63: p_derivation OUT NOCOPY igs_pr_stat_type.derivation%TYPE,
64: p_init_msg_list IN VARCHAR2,

Line 61: p_include_local_ind OUT NOCOPY igs_pr_org_stat.include_local_ind%TYPE,

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,
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,

Line 62: p_include_other_ind OUT NOCOPY igs_pr_org_stat.include_other_ind%TYPE,

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,
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,

Line 72: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,

68:
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,

Line 84: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,

80: FUNCTION chk_sua_ref_cd(
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,

Line 99: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,

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,
103: p_include_local_ind IN VARCHAR2,

Line 143: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,

139:
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,

Line 167: FROM igs_pr_org_stat_ref ostr1

163:
164: CURSOR c_org_setup
165: IS
166: SELECT ostr1.include_or_exclude
167: FROM igs_pr_org_stat_ref ostr1
168: WHERE ostr1.stat_type = p_stat_type
169: AND ostr1.org_unit_cd = p_org_unit_cd;
170:
171: CURSOR c_org_included

Line 183: FROM igs_pr_org_stat_ref ostr1

179: AND refcd.reference_cd_type = rct.reference_cd_type
180: AND rct.s_reference_cd_type = 'STATS'
181: AND urc.deleted_date IS NULL
182: AND EXISTS ( SELECT 'X'
183: FROM igs_pr_org_stat_ref ostr1
184: WHERE ostr1.stat_type = p_stat_type
185: AND ostr1.org_unit_cd = p_org_unit_cd
186: AND ostr1.unit_ref_cd = refcd.reference_cd
187: AND ostr1.include_or_exclude = 'INCLUDE');

Line 201: FROM igs_pr_org_stat_ref ostr1

197: AND refcd.reference_cd_type = rct.reference_cd_type
198: AND rct.s_reference_cd_type = 'STATS'
199: AND urc.deleted_date IS NULL
200: AND EXISTS ( SELECT 'X'
201: FROM igs_pr_org_stat_ref ostr1
202: WHERE ostr1.stat_type = p_stat_type
203: AND ostr1.org_unit_cd = p_org_unit_cd
204: AND ostr1.unit_ref_cd = refcd.reference_cd
205: AND ostr1.include_or_exclude = 'EXCLUDE');

Line 406: p_org_unit_cd OUT NOCOPY igs_pr_org_stat.org_unit_cd%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,
410: p_derivation OUT NOCOPY igs_pr_stat_type.derivation%TYPE,

Line 407: p_include_std_ind OUT NOCOPY igs_pr_org_stat.include_standard_ind%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,
410: p_derivation OUT NOCOPY igs_pr_stat_type.derivation%TYPE,
411: p_init_msg_list IN VARCHAR2,

Line 408: p_include_local_ind OUT NOCOPY igs_pr_org_stat.include_local_ind%TYPE,

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,
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,

Line 409: p_include_other_ind OUT NOCOPY igs_pr_org_stat.include_other_ind%TYPE,

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,
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,

Line 443: igs_pr_org_stat orst

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
447: AND spa.version_number = crv.version_number

Line 604: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,

600:
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,

Line 627: FROM igs_pr_org_stat_ref ostr1

623: --------------------------------------------------------------------------
624:
625: CURSOR c_org_setup IS
626: SELECT ostr1.include_or_exclude
627: FROM igs_pr_org_stat_ref ostr1
628: WHERE ostr1.stat_type = p_stat_type AND ostr1.org_unit_cd =
629: p_org_unit_cd;
630:
631: CURSOR c_org_included IS

Line 639: FROM igs_pr_org_stat_ref ostr1

635: AND urc.version_number = p_unit_version_number
636: AND urc.reference_cd_type = rct.reference_cd_type
637: AND rct.s_reference_cd_type = 'STATS'
638: AND EXISTS( SELECT 'X'
639: FROM igs_pr_org_stat_ref ostr1
640: WHERE ostr1.stat_type = p_stat_type
641: AND ostr1.org_unit_cd = p_org_unit_cd
642: AND ostr1.unit_ref_cd = urc.reference_cd
643: AND ostr1.include_or_exclude = 'INCLUDE');

Line 653: FROM igs_pr_org_stat_ref ostr1

649: AND urc.version_number = p_unit_version_number
650: AND urc.reference_cd_type = rct.reference_cd_type
651: AND rct.s_reference_cd_type = 'STATS'
652: AND EXISTS( SELECT 'X'
653: FROM igs_pr_org_stat_ref ostr1
654: WHERE ostr1.stat_type = p_stat_type
655: AND ostr1.org_unit_cd = p_org_unit_cd
656: AND ostr1.unit_ref_cd = urc.reference_cd
657: AND ostr1.include_or_exclude = 'EXCLUDE');

Line 825: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,

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,
829: p_include_local_ind IN VARCHAR2,

Line 1311: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,

1307: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1308: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
1309: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
1310: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
1311: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
1312: p_system_stat IN VARCHAR2,
1313: p_earned_cp OUT NOCOPY NUMBER,
1314: p_attempted_cp OUT NOCOPY NUMBER,
1315: p_gpa_value OUT NOCOPY NUMBER,

Line 1341: l_org_unit_cd igs_pr_org_stat.org_unit_cd%TYPE;

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;
1345: l_derivation igs_pr_stat_type.derivation%TYPE;

Line 1342: l_include_std_ind igs_pr_org_stat.include_standard_ind%TYPE;

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;
1345: l_derivation igs_pr_stat_type.derivation%TYPE;
1346: l_earned_cp NUMBER;

Line 1343: l_include_local_ind igs_pr_org_stat.include_local_ind%TYPE;

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;
1345: l_derivation igs_pr_stat_type.derivation%TYPE;
1346: l_earned_cp NUMBER;
1347: l_attempted_cp NUMBER;

Line 1344: l_include_other_ind igs_pr_org_stat.include_other_ind%TYPE;

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;
1345: l_derivation igs_pr_stat_type.derivation%TYPE;
1346: l_earned_cp NUMBER;
1347: l_attempted_cp NUMBER;
1348: l_gpa_cp NUMBER;

Line 2003: l_org_unit_cd igs_pr_org_stat.org_unit_cd%TYPE;

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;
2007: l_derivation igs_pr_stat_type.derivation%TYPE;

Line 2004: l_include_std_ind igs_pr_org_stat.include_standard_ind%TYPE;

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;
2007: l_derivation igs_pr_stat_type.derivation%TYPE;
2008: l_init_msg_list VARCHAR2(20);

Line 2005: l_include_local_ind igs_pr_org_stat.include_local_ind%TYPE;

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;
2007: l_derivation igs_pr_stat_type.derivation%TYPE;
2008: l_init_msg_list VARCHAR2(20);
2009: l_return_status VARCHAR2(30);

Line 2006: l_include_other_ind igs_pr_org_stat.include_other_ind%TYPE;

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;
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);

Line 2587: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,

2583: FUNCTION chk_sua_ref_cd(
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,

Line 2597: FROM igs_pr_org_stat_ref ostr1

2593: RETURN VARCHAR2 AS
2594:
2595: CURSOR c_org_setup IS
2596: SELECT ostr1.include_or_exclude
2597: FROM igs_pr_org_stat_ref ostr1
2598: WHERE ostr1.stat_type = p_stat_type AND ostr1.org_unit_cd = p_org_unit_cd;
2599:
2600: CURSOR c_org_included IS
2601: SELECT 'X'

Line 2612: FROM igs_pr_org_stat_ref ostr1

2608: AND urc.deleted_date IS NULL
2609: AND rct.s_reference_cd_type = 'STATS'
2610: AND EXISTS (
2611: SELECT 'X'
2612: FROM igs_pr_org_stat_ref ostr1
2613: WHERE ostr1.stat_type = p_stat_type
2614: AND ostr1.org_unit_cd = p_org_unit_cd
2615: AND ostr1.unit_ref_cd = urc.reference_cd
2616: AND ostr1.include_or_exclude = 'INCLUDE');

Line 2629: FROM igs_pr_org_stat_ref ostr1

2625: AND urc.reference_cd_type = rct.reference_cd_type
2626: AND urc.deleted_date IS NULL
2627: AND rct.s_reference_cd_type = 'STATS'
2628: AND EXISTS( SELECT 'X'
2629: FROM igs_pr_org_stat_ref ostr1
2630: WHERE ostr1.stat_type = p_stat_type
2631: AND ostr1.org_unit_cd = p_org_unit_cd
2632: AND ostr1.unit_ref_cd = urc.reference_cd
2633: AND ostr1.include_or_exclude = 'EXCLUDE');