APPS.IGS_DA_XML_PKG dependencies on IGS_PR_ORG_STAT

Line 52: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

48: p_person_id IN igs_en_su_attempt.person_id%TYPE,
49: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
50: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
51: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
52: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
53: ) AS
54: --
55: v_gpa NUMBER;
56: v_gpa_cp NUMBER;

Line 185: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

181: p_person_id IN igs_en_su_attempt.person_id%TYPE,
182: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
183: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
184: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
185: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
186: ) AS
187: --
188: v_cum_gpa NUMBER;
189: v_cum_gpa_cp NUMBER;

Line 247: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

243: p_person_id IN igs_en_su_attempt.person_id%TYPE,
244: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
245: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
246: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
247: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
248: ) RETURN NUMBER AS
249: --
250: BEGIN
251: --

Line 283: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

279: p_person_id IN igs_en_su_attempt.person_id%TYPE,
280: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
281: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
282: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
283: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
284: ) RETURN NUMBER AS
285: --
286: BEGIN
287: --

Line 319: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

315: p_person_id IN igs_en_su_attempt.person_id%TYPE,
316: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
317: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
318: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
319: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
320: ) RETURN NUMBER AS
321: --
322: BEGIN
323: --

Line 355: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

351: p_person_id IN igs_en_su_attempt.person_id%TYPE,
352: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
353: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
354: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
355: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
356: ) RETURN NUMBER AS
357: --
358: BEGIN
359: --

Line 391: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

387: p_person_id IN igs_en_su_attempt.person_id%TYPE,
388: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
389: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
390: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
391: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
392: ) RETURN VARCHAR2 AS
393: --
394: BEGIN
395: --

Line 427: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

423: p_person_id IN igs_en_su_attempt.person_id%TYPE,
424: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
425: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
426: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
427: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
428: ) RETURN NUMBER AS
429: --
430: BEGIN
431: --

Line 463: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

459: p_person_id IN igs_en_su_attempt.person_id%TYPE,
460: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
461: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
462: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
463: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
464: ) RETURN VARCHAR2 AS
465: --
466: BEGIN
467: --

Line 499: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

495: p_person_id IN igs_en_su_attempt.person_id%TYPE,
496: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
497: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
498: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
499: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
500: ) RETURN NUMBER AS
501: --
502: BEGIN
503: --

Line 535: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

531: p_person_id IN igs_en_su_attempt.person_id%TYPE,
532: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
533: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
534: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
535: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
536: ) RETURN NUMBER AS
537: --
538: BEGIN
539: --

Line 571: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

567: p_person_id IN igs_en_su_attempt.person_id%TYPE,
568: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
569: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
570: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
571: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
572: ) RETURN NUMBER AS
573: --
574: BEGIN
575: --

Line 607: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

603: p_person_id IN igs_en_su_attempt.person_id%TYPE,
604: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
605: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
606: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
607: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
608: ) RETURN NUMBER AS
609: --
610: BEGIN
611: --

Line 643: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

639: p_person_id IN igs_en_su_attempt.person_id%TYPE,
640: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
641: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
642: p_load_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
643: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
644: ) RETURN NUMBER AS
645: --
646: BEGIN
647: --

Line 798: p_stat_type IN igs_pr_org_stat.stat_type%TYPE

794: p_version_number IN igs_en_su_attempt.version_number%TYPE,
795: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
796: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
797: p_unit_attempt_status IN igs_en_su_attempt.unit_attempt_status%TYPE,
798: p_stat_type IN igs_pr_org_stat.stat_type%TYPE
799: ) RETURN VARCHAR2 AS
800: --
801: CURSOR suao_gsg_cur is
802: SELECT suao.grade, gsg.grade valid_grade, gsg.repeat_grade