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_AS_CALC_AWARD_MARK dependencies on IGS_AS_CALC_AWARD_MARK

Line 1: PACKAGE BODY IGS_AS_CALC_AWARD_MARK AS

1: PACKAGE BODY IGS_AS_CALC_AWARD_MARK AS
2: /* $Header: IGSAS57B.pls 120.5 2006/07/31 07:33:11 ijeddy ship $ */
3: /*************************************************************
4: Created By : smanglm
5: Date Created on : 10-Oct-2003

Line 493: || ' NVL(stmpt.mark,igs_as_calc_award_mark.get_mark '

489: AND ulvl.s_adv_stnd_granting_status = 'GRANTED';
490: l_stmt_cp_based VARCHAR2 (4000)
491: := ' SELECT sua.unit_cd, '
492: || ' sua.uoo_id, '
493: || ' NVL(stmpt.mark,igs_as_calc_award_mark.get_mark '
494: || ' (stmpt.grading_schema_cd, '
495: || ' stmpt.version_number,stmpt.grade)) mark, '
496: || ' stmpt.grade, '
497: || ' igs_as_calc_award_mark.get_earned_cp '

Line 497: || ' igs_as_calc_award_mark.get_earned_cp '

493: || ' NVL(stmpt.mark,igs_as_calc_award_mark.get_mark '
494: || ' (stmpt.grading_schema_cd, '
495: || ' stmpt.version_number,stmpt.grade)) mark, '
496: || ' stmpt.grade, '
497: || ' igs_as_calc_award_mark.get_earned_cp '
498: || ' (stmpt.person_id,stmpt.course_cd,sua.unit_cd, '
499: || ' sua.version_number,sua.unit_attempt_status, '
500: || ' sua.cal_type,sua.ci_sequence_number, '
501: || ' sua.uoo_id,sua.override_achievable_cp, '

Line 519: || ' AND NVL(stmpt.mark,igs_as_calc_award_mark.get_mark '

515: || ' NVL(UL.UNIT_LEVEL, UV.UNIT_LEVEL) = :4 AND '
516: || ' LVL.UNIT_LEVEL= UV.UNIT_LEVEL'
517: || ' AND MARK IS NOT NULL '
518: || 'AND sua.uoo_id = stmpt.uoo_id'
519: || ' AND NVL(stmpt.mark,igs_as_calc_award_mark.get_mark '
520: || ' (stmpt.grading_schema_cd, '
521: || ' stmpt.version_number,stmpt.grade)) IS NOT NULL '
522: || ' AND stmpt.outcome_dt = ( SELECT max(outcome_dt) '
523: || ' FROM igs_as_su_stmptout suao '

Line 529: || ' AND igs_as_calc_award_mark.chk_if_excluded_unit (sua.uoo_id,sua.unit_cd,sua.version_number) = ''TRUE'' ';

525: || ' AND suao.course_cd =stmpt.course_cd '
526: || ' AND suao.outcome_dt = stmpt.outcome_dt '
527: || ' AND suao.grading_period_cd = stmpt. grading_period_cd '
528: || ' AND suao.uoo_id= stmpt.uoo_id ) '
529: || ' AND igs_as_calc_award_mark.chk_if_excluded_unit (sua.uoo_id,sua.unit_cd,sua.version_number) = ''TRUE'' ';
530: l_stmt_cp_based_orig VARCHAR2 (4000) := l_stmt_cp_based;
531: l_stmt_priority_based VARCHAR2 (4000)
532: := ' SELECT sua.unit_cd, '
533: || ' sua.uoo_id, '

Line 534: || ' NVL(suao.mark,igs_as_calc_award_mark.get_mark '

530: l_stmt_cp_based_orig VARCHAR2 (4000) := l_stmt_cp_based;
531: l_stmt_priority_based VARCHAR2 (4000)
532: := ' SELECT sua.unit_cd, '
533: || ' sua.uoo_id, '
534: || ' NVL(suao.mark,igs_as_calc_award_mark.get_mark '
535: || ' (suao.grading_schema_cd,suao.version_number,suao.grade)) mark, '
536: || ' suao.grade, '
537: || ' NVL(ul.wam_weighting,NVL( lvl.wam_weighting,1)) wam_weight, '
538: || ' igs_as_calc_award_mark.get_earned_cp '

Line 538: || ' igs_as_calc_award_mark.get_earned_cp '

534: || ' NVL(suao.mark,igs_as_calc_award_mark.get_mark '
535: || ' (suao.grading_schema_cd,suao.version_number,suao.grade)) mark, '
536: || ' suao.grade, '
537: || ' NVL(ul.wam_weighting,NVL( lvl.wam_weighting,1)) wam_weight, '
538: || ' igs_as_calc_award_mark.get_earned_cp '
539: || ' (suao.person_id,suao.course_cd,sua.unit_cd, '
540: || ' sua.version_number,sua.unit_attempt_status, '
541: || ' sua.cal_type,sua.ci_sequence_number, '
542: || ' sua.uoo_id,sua.override_achievable_cp, '

Line 555: || ' AND NVL(suao.mark,igs_as_calc_award_mark.get_mark '

551: || ' AND sua.course_cd = ul.course_cd(+) AND sua.unit_cd = ul.unit_cd(+) '
552: || ' AND sua.version_number = ul.version_number(+) '
553: || ' AND NVL(ul.unit_level,uv.unit_level) = :4 '
554: || ' AND lvl.unit_level = uv.unit_level '
555: || ' AND NVL(suao.mark,igs_as_calc_award_mark.get_mark '
556: || ' (suao.grading_schema_cd,suao.version_number,suao.grade)) IS NOT NULL '
557: || ' AND suao.outcome_dt = ( SELECT max(outcome_dt) '
558: || ' FROM igs_as_su_stmptout_all suao2 '
559: || ' WHERE suao2.person_id = suao.person_id '

Line 563: || ' AND igs_as_calc_award_mark.chk_if_excluded_unit (sua.uoo_id,sua.unit_cd,sua.version_number) = ''TRUE'' ';

559: || ' WHERE suao2.person_id = suao.person_id '
560: || ' AND suao2.course_cd = suao.course_cd '
561: || ' AND suao2.grading_period_cd = suao.grading_period_cd '
562: || ' AND suao2.uoo_id= suao.uoo_id ) '
563: || ' AND igs_as_calc_award_mark.chk_if_excluded_unit (sua.uoo_id,sua.unit_cd,sua.version_number) = ''TRUE'' ';
564: l_stmt_priority_based_orig VARCHAR2 (4000) := l_stmt_priority_based;
565: -- local variables to store the output of the ref cursor
566: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
567: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

Line 585: igs_as_calc_award_mark.get_mark (

581: IS
582: SELECT sua.unit_cd, sua.uoo_id,
583: NVL (
584: suao.mark,
585: igs_as_calc_award_mark.get_mark (
586: suao.grading_schema_cd,
587: suao.version_number,
588: suao.grade
589: )

Line 593: igs_as_calc_award_mark.get_earned_cp (

589: )
590: ) mark,
591: suao.grade,
592: NVL (ul.wam_weighting, NVL (lvl.wam_weighting, 1)) wam_weight,
593: igs_as_calc_award_mark.get_earned_cp (
594: suao.person_id,
595: suao.course_cd,
596: sua.unit_cd,
597: sua.version_number,

Line 625: igs_as_calc_award_mark.get_mark (

621: AND NVL (ul.unit_level, uv.unit_level) = cp_unit_level
622: AND lvl.unit_level = uv.unit_level
623: AND NVL (
624: suao.mark,
625: igs_as_calc_award_mark.get_mark (
626: suao.grading_schema_cd,
627: suao.version_number,
628: suao.grade
629: )

Line 1663: -- by making a call to procedure pr_calc_award_mark of package igs_as_calc_award_mark.

1659:
1660: -- increment the totla spa record selected by 1;
1661: l_total_spa_rec := l_total_spa_rec + 1;
1662: ---- Get the award mark, Honors level, grading schema and grading schem version
1663: -- by making a call to procedure pr_calc_award_mark of package igs_as_calc_award_mark.
1664:
1665: igs_as_calc_award_mark.pr_calc_award_mark(
1666: p_person_id => spaa_rec.person_id,
1667: p_course_cd => spaa_rec.course_cd ,

Line 1665: igs_as_calc_award_mark.pr_calc_award_mark(

1661: l_total_spa_rec := l_total_spa_rec + 1;
1662: ---- Get the award mark, Honors level, grading schema and grading schem version
1663: -- by making a call to procedure pr_calc_award_mark of package igs_as_calc_award_mark.
1664:
1665: igs_as_calc_award_mark.pr_calc_award_mark(
1666: p_person_id => spaa_rec.person_id,
1667: p_course_cd => spaa_rec.course_cd ,
1668: p_award_cd => spaa_rec.award_cd,
1669: p_award_mark => lAwdMark,

Line 1800: END igs_as_calc_award_mark;

1796: WHEN OTHERS THEN
1797: fnd_file.put_line (fnd_file.LOG, 'Error encountered : ' || SQLERRM);
1798: End fn_ret_unit_lvl_mark;
1799:
1800: END igs_as_calc_award_mark;