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_GR_PELL_CALC dependencies on IGF_GR_PELL_SETUP

Line 270: cp_course_cd IN igf_gr_pell_setup_all.course_cd%TYPE,

266: CLOSE c_get_prog_frm_adm;
267: END get_key_prog_ver_frm_adm;
268:
269: PROCEDURE get_pell_setup ( cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
270: cp_course_cd IN igf_gr_pell_setup_all.course_cd%TYPE,
271: cp_version_number IN igf_gr_pell_setup_all.version_number%TYPE,
272: cp_cal_type IN igs_ca_inst.cal_type%TYPE,
273: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE,
274: cp_pell_setup_rec IN OUT NOCOPY igf_gr_pell_setup_all%ROWTYPE ,

Line 271: cp_version_number IN igf_gr_pell_setup_all.version_number%TYPE,

267: END get_key_prog_ver_frm_adm;
268:
269: PROCEDURE get_pell_setup ( cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
270: cp_course_cd IN igf_gr_pell_setup_all.course_cd%TYPE,
271: cp_version_number IN igf_gr_pell_setup_all.version_number%TYPE,
272: cp_cal_type IN igs_ca_inst.cal_type%TYPE,
273: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE,
274: cp_pell_setup_rec IN OUT NOCOPY igf_gr_pell_setup_all%ROWTYPE ,
275: cp_message OUT NOCOPY VARCHAR2,

Line 274: cp_pell_setup_rec IN OUT NOCOPY igf_gr_pell_setup_all%ROWTYPE ,

270: cp_course_cd IN igf_gr_pell_setup_all.course_cd%TYPE,
271: cp_version_number IN igf_gr_pell_setup_all.version_number%TYPE,
272: cp_cal_type IN igs_ca_inst.cal_type%TYPE,
273: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE,
274: cp_pell_setup_rec IN OUT NOCOPY igf_gr_pell_setup_all%ROWTYPE ,
275: cp_message OUT NOCOPY VARCHAR2,
276: cp_return_status OUT NOCOPY VARCHAR2
277: )
278: IS

Line 303: l_att_pell_id igf_gr_pell_setup_all.rep_pell_id%TYPE

299:
300: CURSOR c_get_rep_pell_id(
301: l_cal_type igs_ca_inst.cal_type%TYPE,
302: l_seq_num igs_ca_inst.sequence_number%TYPE,
303: l_att_pell_id igf_gr_pell_setup_all.rep_pell_id%TYPE
304: )
305: IS
306: SELECT rep.reporting_pell_cd
307: FROM igf_gr_attend_pell gap, igf_gr_report_pell rep

Line 316: l_reporting_pell_id igf_gr_pell_setup.rep_pell_id%TYPE,

312:
313: CURSOR c_pell_setup(
314: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
315: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
316: l_reporting_pell_id igf_gr_pell_setup.rep_pell_id%TYPE,
317: l_course_cd igf_gr_pell_setup.course_cd%TYPE,
318: l_version_number igf_gr_pell_setup.version_number%TYPE
319: )
320: IS

Line 317: l_course_cd igf_gr_pell_setup.course_cd%TYPE,

313: CURSOR c_pell_setup(
314: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
315: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
316: l_reporting_pell_id igf_gr_pell_setup.rep_pell_id%TYPE,
317: l_course_cd igf_gr_pell_setup.course_cd%TYPE,
318: l_version_number igf_gr_pell_setup.version_number%TYPE
319: )
320: IS
321: SELECT pell.*

Line 318: l_version_number igf_gr_pell_setup.version_number%TYPE

314: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
315: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
316: l_reporting_pell_id igf_gr_pell_setup.rep_pell_id%TYPE,
317: l_course_cd igf_gr_pell_setup.course_cd%TYPE,
318: l_version_number igf_gr_pell_setup.version_number%TYPE
319: )
320: IS
321: SELECT pell.*
322: FROM igf_gr_pell_setup_all pell

Line 322: FROM igf_gr_pell_setup_all pell

318: l_version_number igf_gr_pell_setup.version_number%TYPE
319: )
320: IS
321: SELECT pell.*
322: FROM igf_gr_pell_setup_all pell
323: WHERE pell.ci_cal_type = l_ci_cal_type
324: AND pell.ci_sequence_number = l_ci_sequence_number
325: AND pell.rep_pell_id = l_reporting_pell_id
326: AND pell.course_cd = l_course_cd

Line 332: l_reporting_pell_id igf_gr_pell_setup.rep_pell_id%TYPE

328:
329: CURSOR c_pell_def_setup(
330: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
331: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
332: l_reporting_pell_id igf_gr_pell_setup.rep_pell_id%TYPE
333: )
334: IS
335: SELECT pell.*
336: FROM igf_gr_pell_setup_all pell

Line 336: FROM igf_gr_pell_setup_all pell

332: l_reporting_pell_id igf_gr_pell_setup.rep_pell_id%TYPE
333: )
334: IS
335: SELECT pell.*
336: FROM igf_gr_pell_setup_all pell
337: WHERE pell.ci_cal_type = l_ci_cal_type
338: AND pell.ci_sequence_number = l_ci_sequence_number
339: AND pell.rep_pell_id = l_reporting_pell_id
340: AND pell.course_cd IS NULL

Line 348: l_ovrd_setup_rec igf_gr_pell_setup_all%ROWTYPE;

344: l_rep_pell_id igf_gr_attend_pell.attending_pell_cd%TYPE;
345: l_ret_status VARCHAR2(30);
346: l_msg_data VARCHAR2(30);
347: l_stu_num VARCHAR2(30);
348: l_ovrd_setup_rec igf_gr_pell_setup_all%ROWTYPE;
349:
350:
351: -- Entity ID declarations
352: CURSOR c_get_rep_entity_id_txt(

Line 368: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE

364:
365: CURSOR c_pell_def_setup_cod(
366: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
367: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,
368: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE
369: )
370: IS
371: SELECT pell.*
372: FROM igf_gr_pell_setup_all pell

Line 372: FROM igf_gr_pell_setup_all pell

368: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE
369: )
370: IS
371: SELECT pell.*
372: FROM igf_gr_pell_setup_all pell
373: WHERE pell.ci_cal_type = l_ci_cal_type
374: AND pell.ci_sequence_number = l_ci_sequence_number
375: AND pell.rep_entity_id_txt = l_rep_entity_id
376: AND pell.course_cd IS NULL

Line 382: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE,

378:
379: CURSOR c_pell_ovrd_setup_cod(
380: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
381: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,
382: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE,
383: l_course_cd igf_gr_pell_setup_all.course_cd%TYPE,
384: l_version_number igf_gr_pell_setup_all.version_number%TYPE
385: )
386: IS

Line 383: l_course_cd igf_gr_pell_setup_all.course_cd%TYPE,

379: CURSOR c_pell_ovrd_setup_cod(
380: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
381: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,
382: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE,
383: l_course_cd igf_gr_pell_setup_all.course_cd%TYPE,
384: l_version_number igf_gr_pell_setup_all.version_number%TYPE
385: )
386: IS
387: SELECT pell.*

Line 384: l_version_number igf_gr_pell_setup_all.version_number%TYPE

380: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
381: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,
382: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE,
383: l_course_cd igf_gr_pell_setup_all.course_cd%TYPE,
384: l_version_number igf_gr_pell_setup_all.version_number%TYPE
385: )
386: IS
387: SELECT pell.*
388: FROM igf_gr_pell_setup_all pell

Line 388: FROM igf_gr_pell_setup_all pell

384: l_version_number igf_gr_pell_setup_all.version_number%TYPE
385: )
386: IS
387: SELECT pell.*
388: FROM igf_gr_pell_setup_all pell
389: WHERE pell.ci_cal_type = l_ci_cal_type
390: AND pell.ci_sequence_number = l_ci_sequence_number
391: AND pell.rep_entity_id_txt = l_rep_entity_id
392: AND pell.course_cd = l_course_cd

Line 684: cp_pell_setup_rec IN igf_gr_pell_setup_all%ROWTYPE ,

680:
681:
682: PROCEDURE get_pell_coa_efc (cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
683: cp_attendance_type IN igf_ap_attend_map.attendance_type%TYPE,
684: cp_pell_setup_rec IN igf_gr_pell_setup_all%ROWTYPE ,
685: cp_coa OUT NOCOPY NUMBER,
686: cp_efc OUT NOCOPY NUMBER,
687: cp_pell_schedule_code OUT NOCOPY VARCHAR2,
688: cp_message OUT NOCOPY VARCHAR2,

Line 806: cp_pell_setup_rec IN igf_gr_pell_setup_all%ROWTYPE ,

802: PROCEDURE get_pell_attendance_type (
803: cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
804: cp_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
805: cp_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
806: cp_pell_setup_rec IN igf_gr_pell_setup_all%ROWTYPE ,
807: cp_attendance_type IN OUT NOCOPY igf_ap_attend_map.attendance_type%TYPE,
808: cp_message OUT NOCOPY VARCHAR2,
809: cp_return_status OUT NOCOPY VARCHAR2
810: )

Line 883: l_enrl_mode igf_gr_pell_setup.enr_in_mt_code%TYPE;

879: l_credit_pts igs_en_su_attempt.override_achievable_cp%TYPE ;
880: l_fte igs_en_su_attempt.override_achievable_cp%TYPE ;
881:
882: l_effctive_cens_dt DATE;
883: l_enrl_mode igf_gr_pell_setup.enr_in_mt_code%TYPE;
884:
885:
886: CURSOR c_get_pell_att(
887: l_att_type igf_ap_attend_map_all.attendance_type%TYPE,

Line 1879: cp_pell_seq_id OUT NOCOPY igf_gr_pell_setup_all.pell_seq_id%TYPE,

1875: cp_pell_tab IN OUT NOCOPY pell_tab,
1876: cp_return_status IN OUT NOCOPY VARCHAR2,
1877: cp_message IN OUT NOCOPY VARCHAR2,
1878: cp_called_from IN VARCHAR2,
1879: cp_pell_seq_id OUT NOCOPY igf_gr_pell_setup_all.pell_seq_id%TYPE,
1880: cp_pell_schedule_code OUT NOCOPY VARCHAR2
1881: ) IS
1882: /*
1883: || Created By : CDCRUZ

Line 2096: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;

2092: dp.adplans_id = l_plan_id;
2093:
2094: l_dp_details_rec c_dp_details%ROWTYPE;
2095:
2096: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;
2097: l_pell_schedule VARCHAR2(30);
2098: l_pell_attend_type VARCHAR2(30);
2099: l_message fnd_new_messages.message_text%TYPE;
2100: l_return_status VARCHAR2(30);

Line 3256: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;

3252: UPPER(fmast.fund_code) = 'PELL';
3253:
3254: l_awd_round_fact_rec cur_get_awd_round_fact%ROWTYPE;
3255:
3256: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;
3257: l_pell_schedule VARCHAR2(30);
3258: l_message fnd_new_messages.message_text%TYPE;
3259: l_return_status VARCHAR2(30);
3260:

Line 3543: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;

3539: l_ft_coa NUMBER;
3540: l_ft_aid NUMBER;
3541: l_program_cd igs_en_stdnt_ps_att.course_cd%TYPE;
3542: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;
3543: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;
3544: l_ft_efc NUMBER;
3545: l_pell_schedule_code VARCHAR2(30);
3546:
3547: