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_GEN dependencies on IGF_AP_FA_BASE_REC_ALL

Line 303: FUNCTION get_per_num ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE)

299:
300:
301: END get_calendar_desc;
302:
303: FUNCTION get_per_num ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE)
304: RETURN VARCHAR2
305: IS
306: --------------------------------------------------------------------------------------------
307: --

Line 314: CURSOR cur_fa_pers ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

310: -- Purpose : Returns person number for the Base id passed
311: --
312: --------------------------------------------------------------------------------------------
313:
314: CURSOR cur_fa_pers ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
315: IS
316: SELECT person_number
317: FROM igs_pe_person_base_v
318: WHERE person_id =

Line 353: FUNCTION get_per_num ( p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,

349: END get_per_num;
350:
351:
352:
353: FUNCTION get_per_num ( p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
354: p_person_number OUT NOCOPY igf_ap_person_v.person_number%TYPE )
355: RETURN BOOLEAN
356: IS
357: --------------------------------------------------------------------------------------------

Line 366: CURSOR cur_fa_pers ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

362: -- financial aid
363: --
364: --------------------------------------------------------------------------------------------
365:
366: CURSOR cur_fa_pers ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
367: IS
368: SELECT person_number
369: FROM igf_ap_person_v
370: WHERE

Line 399: FUNCTION get_person_id ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

395:
396: END get_per_num;
397:
398:
399: FUNCTION get_person_id ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
400: RETURN VARCHAR2
401: IS
402: --------------------------------------------------------------------------------------------
403: --

Line 410: CURSOR cur_fa_pers ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

406: -- Purpose : Returns Person ID for the Base id passed
407: --
408: --------------------------------------------------------------------------------------------
409:
410: CURSOR cur_fa_pers ( p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
411: IS
412: SELECT person_id
413: FROM igf_ap_fa_base_rec
414: WHERE

Line 442: FUNCTION get_per_num_oss ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

438:
439: END get_person_id;
440:
441:
442: FUNCTION get_per_num_oss ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
443: RETURN VARCHAR2
444: IS
445: --------------------------------------------------------------------------------------------
446: --

Line 453: CURSOR cur_fa_pers ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

449: -- Purpose : Returns person number for the Base id passed
450: --
451: --------------------------------------------------------------------------------------------
452:
453: CURSOR cur_fa_pers ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
454: IS
455: SELECT person_number
456: FROM igs_pe_person_base_v
457: WHERE

Line 2099: CURSOR cur_tufees_code (p_exp igf_ap_fa_base_rec_all.pell_alt_expense%TYPE,

2095: base_id = p_base_id;
2096:
2097: get_alt_rec cur_get_alt%ROWTYPE;
2098:
2099: CURSOR cur_tufees_code (p_exp igf_ap_fa_base_rec_all.pell_alt_expense%TYPE,
2100: p_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,
2101: p_sequence_number igf_gr_rfms_all.ci_sequence_number%TYPE)
2102: IS
2103: SELECT ltfees.lt_fees_code

Line 2678: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,

2674: --
2675:
2676: PROCEDURE get_base_id(p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2677: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2678: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
2679: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
2680: p_err_msg OUT NOCOPY VARCHAR2
2681: )
2682: IS

Line 2679: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,

2675:
2676: PROCEDURE get_base_id(p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2677: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2678: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
2679: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
2680: p_err_msg OUT NOCOPY VARCHAR2
2681: )
2682: IS
2683:

Line 2691: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

2687: --
2688:
2689: CURSOR cur_get_base (p_cal_type igs_ca_inst_all.cal_type%TYPE,
2690: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2691: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
2692: IS
2693: SELECT
2694: base_id
2695: FROM

Line 2736: PROCEDURE update_current_ssn (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

2732: app_exception.raise_exception;
2733:
2734: END get_base_id;
2735:
2736: PROCEDURE update_current_ssn (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
2737: p_cur_ssn IN igf_ap_isir_matched_all.current_ssn%TYPE,
2738: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE)
2739: IS
2740: --

Line 2747: CURSOR cur_get_pell (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

2743: -- update_current_ssn
2744: -- updates current ssn with the new value from active isir
2745: --
2746:
2747: CURSOR cur_get_pell (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
2748: IS
2749: SELECT pell.*
2750: FROM
2751: igf_gr_rfms pell