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.IGF_AW_PACKAGING dependencies on IGS_PS_VER

Line 510: p_prog_cd IN igs_ps_ver_v.course_cd%type,

506: RETURN l_disb_round_factor;
507: END get_disb_round_factor;
508:
509: FUNCTION get_prog_elig(
510: p_prog_cd IN igs_ps_ver_v.course_cd%type,
511: p_prog_ver IN igs_ps_ver_v.version_number%type,
512: p_fund_source IN igf_aw_fund_cat_all.fund_source%type
513: )
514: RETURN BOOLEAN

Line 511: p_prog_ver IN igs_ps_ver_v.version_number%type,

507: END get_disb_round_factor;
508:
509: FUNCTION get_prog_elig(
510: p_prog_cd IN igs_ps_ver_v.course_cd%type,
511: p_prog_ver IN igs_ps_ver_v.version_number%type,
512: p_fund_source IN igf_aw_fund_cat_all.fund_source%type
513: )
514: RETURN BOOLEAN
515: IS

Line 537: cp_stud_program_cd igs_ps_ver_v.course_cd%type,

533: -------------------------------------------------------------------
534:
535: -- Check program eligibility for actual data
536: CURSOR c_chk_prog_elig_with_ver(
537: cp_stud_program_cd igs_ps_ver_v.course_cd%type,
538: cp_stud_program_ver igs_ps_ver_v.version_number%type,
539: cp_fund_source igf_aw_fund_cat_all.fund_source%type
540: )
541: IS

Line 538: cp_stud_program_ver igs_ps_ver_v.version_number%type,

534:
535: -- Check program eligibility for actual data
536: CURSOR c_chk_prog_elig_with_ver(
537: cp_stud_program_cd igs_ps_ver_v.course_cd%type,
538: cp_stud_program_ver igs_ps_ver_v.version_number%type,
539: cp_fund_source igf_aw_fund_cat_all.fund_source%type
540: )
541: IS
542: SELECT DECODE(cp_fund_source,

Line 547: FROM IGS_PS_VER_V

543: 'STATE', UPPER(state_financial_aid),
544: 'FEDERAL', UPPER(federal_financial_aid),
545: 'INSTITUTIONAL', UPPER(institutional_financial_aid),
546: NULL) prog_eligibility
547: FROM IGS_PS_VER_V
548: WHERE course_cd = cp_stud_program_cd AND
549: version_number = cp_stud_program_ver;
550:
551: l_chk_prog_elig_with_ver c_chk_prog_elig_with_ver%ROWTYPE;

Line 555: cp_stud_program_cd igs_ps_ver_v.course_cd%type,

551: l_chk_prog_elig_with_ver c_chk_prog_elig_with_ver%ROWTYPE;
552:
553: -- Check program eligibility for anticipated data
554: CURSOR c_chk_prog_elig_wout_ver(
555: cp_stud_program_cd igs_ps_ver_v.course_cd%type,
556: cp_fund_source igf_aw_fund_cat_all.fund_source%type
557: )
558: IS
559: SELECT 'x' FROM dual

Line 561: ( SELECT * FROM IGS_PS_VER_V

557: )
558: IS
559: SELECT 'x' FROM dual
560: WHERE EXISTS
561: ( SELECT * FROM IGS_PS_VER_V
562: WHERE course_cd = cp_stud_program_cd AND
563: DECODE(cp_fund_source,
564: 'STATE', UPPER(state_financial_aid),
565: 'FEDERAL', UPPER(federal_financial_aid),

Line 626: l_program_cd igs_ps_ver_all.course_cd%TYPE;

622: --
623: --Change History:
624: --Who When What
625: -------------------------------------------------------------------
626: l_program_cd igs_ps_ver_all.course_cd%TYPE;
627: l_version_num igs_ps_ver_all.version_number%TYPE;
628: l_program_type igs_ps_ver_all.course_type%TYPE;
629: l_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
630: l_term_start_date DATE := NULL;

Line 627: l_version_num igs_ps_ver_all.version_number%TYPE;

623: --Change History:
624: --Who When What
625: -------------------------------------------------------------------
626: l_program_cd igs_ps_ver_all.course_cd%TYPE;
627: l_version_num igs_ps_ver_all.version_number%TYPE;
628: l_program_type igs_ps_ver_all.course_type%TYPE;
629: l_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
630: l_term_start_date DATE := NULL;
631: l_term_end_date DATE := NULL;

Line 628: l_program_type igs_ps_ver_all.course_type%TYPE;

624: --Who When What
625: -------------------------------------------------------------------
626: l_program_cd igs_ps_ver_all.course_cd%TYPE;
627: l_version_num igs_ps_ver_all.version_number%TYPE;
628: l_program_type igs_ps_ver_all.course_type%TYPE;
629: l_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
630: l_term_start_date DATE := NULL;
631: l_term_end_date DATE := NULL;
632:

Line 629: l_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;

625: -------------------------------------------------------------------
626: l_program_cd igs_ps_ver_all.course_cd%TYPE;
627: l_version_num igs_ps_ver_all.version_number%TYPE;
628: l_program_type igs_ps_ver_all.course_type%TYPE;
629: l_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
630: l_term_start_date DATE := NULL;
631: l_term_end_date DATE := NULL;
632:
633: BEGIN

Line 5784: l_stud_program_cd igs_ps_ver_v.course_cd%TYPE;

5780: WHERE fmdet.formula_code = cp_group_code
5781: AND fmdet.ci_cal_type = cp_ci_cal_type
5782: AND fmdet.ci_sequence_number = cp_ci_sequence_number);
5783:
5784: l_stud_program_cd igs_ps_ver_v.course_cd%TYPE;
5785: l_stud_program_ver igs_ps_ver_v.version_number%TYPE;
5786: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
5787: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;
5788:

Line 5785: l_stud_program_ver igs_ps_ver_v.version_number%TYPE;

5781: AND fmdet.ci_cal_type = cp_ci_cal_type
5782: AND fmdet.ci_sequence_number = cp_ci_sequence_number);
5783:
5784: l_stud_program_cd igs_ps_ver_v.course_cd%TYPE;
5785: l_stud_program_ver igs_ps_ver_v.version_number%TYPE;
5786: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
5787: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;
5788:
5789: -- Returns the fund source of the given fund

Line 5816: igs_ps_ver prog

5812: FROM
5813: igf_aw_awd_prd_term awd_per,
5814: igs_ca_inst_all cal_inst,
5815: igf_ap_fa_ant_data ant_data,
5816: igs_ps_ver prog
5817: WHERE
5818: awd_per.ld_cal_type = cal_inst.cal_type AND
5819: awd_per.ld_sequence_number = cal_inst.sequence_number AND
5820: ant_data.ld_cal_type = awd_per.ld_cal_type AND