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_SL_LAR_CREATION dependencies on IGF_AP_FA_BASE_REC

Line 152: g_person_id igf_ap_fa_base_rec_all.person_id%TYPE;

148: -- Parameters below is declared to hold the fund id in the
149: -- award rec loop. (Bug 2385334)
150: g_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE; -- Bug 4568942
151: g_award_id igf_aw_award_all.award_id%TYPE;
152: g_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
153: gn_transaction_num igf_ap_isir_matched_all.transaction_num%TYPE;
154: gv_atd_entity_id_txt VARCHAR2(30);
155: gv_rep_entity_id_txt VARCHAR2(30);
156:

Line 194: igf_ap_fa_base_rec base

190: FROM
191: igs_pe_relationships_v v,
192: igf_aw_award_all awd,
193: igf_sl_loans_all loans,
194: igf_ap_fa_base_rec base
195: WHERE
196: base.person_id = v.object_id
197: AND base.base_id = awd.base_id
198: AND awd.award_id = loans.award_id

Line 476: FROM igf_ap_fa_base_rec_all

472: p_cal_type VARCHAR2,
473: p_seq_number NUMBER)
474: IS
475: SELECT base_id
476: FROM igf_ap_fa_base_rec_all
477: WHERE base_id = p_base_id AND
478: ci_cal_type = p_cal_type AND
479: ci_sequence_number = p_seq_number;
480:

Line 625: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

621: CURSOR c_base_id(cp_award_id igf_aw_award_all.award_id%TYPE) IS
622: SELECT base_id
623: FROM igf_aw_award_all
624: WHERE award_id = cp_award_id;
625: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
626:
627: p_start_dt DATE;
628: l_start_dt DATE;
629: l_end_dt DATE;

Line 685: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

681: CURSOR c_base_id(cp_award_id igf_aw_award_all.award_id%TYPE) IS
682: SELECT base_id
683: FROM igf_aw_award_all
684: WHERE award_id = cp_award_id;
685: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
686:
687: p_end_dt DATE;
688: l_start_dt DATE;
689: l_end_dt DATE;

Line 924: PROCEDURE get_dl_cl_std_code ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

920: app_exception.raise_exception;
921:
922: END ret_loan_number;
923:
924: PROCEDURE get_dl_cl_std_code ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
925: p_class_standing IN igs_pr_css_class_std_v.class_standing%TYPE ,
926: p_program_type IN igs_ps_ver_all.course_type%TYPE ,
927: p_dl_std_code OUT NOCOPY igf_ap_class_std_map.dl_std_code%TYPE ,
928: p_cl_std_code OUT NOCOPY igf_ap_class_std_map.cl_std_code%TYPE )

Line 942: CURSOR c_person_info ( cp_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS

938: Who When What
939: ***************************************************************/
940:
941: -- Cursor to get person_id, ci_cal_type and ci_sequence_number
942: CURSOR c_person_info ( cp_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
943: SELECT person_id, ci_cal_type, ci_sequence_number
944: FROM igf_ap_fa_base_rec
945: WHERE base_id = cp_base_id ;
946: lv_person_info_rec c_person_info%ROWTYPE ;

Line 944: FROM igf_ap_fa_base_rec

940:
941: -- Cursor to get person_id, ci_cal_type and ci_sequence_number
942: CURSOR c_person_info ( cp_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
943: SELECT person_id, ci_cal_type, ci_sequence_number
944: FROM igf_ap_fa_base_rec
945: WHERE base_id = cp_base_id ;
946: lv_person_info_rec c_person_info%ROWTYPE ;
947:
948: -- Cursor to get cs_schdl_id, class_std_id, css_class_std_id

Line 962: CURSOR c_dl_cl_std_code ( cp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE ,

958: AND CSSV.class_standing = cp_class_standing ;
959: lv_class_std_rec c_class_std%ROWTYPE ;
960:
961: -- Cursor to get dl_std_code
962: CURSOR c_dl_cl_std_code ( cp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE ,
963: cp_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE ,
964: cp_cs_schdl_id igf_ap_pr_prg_type.igs_pr_cs_schdl_id%TYPE ,
965: cp_css_class_std_id igf_ap_class_std_map.igs_pr_css_class_std_id%TYPE ) IS
966: SELECT CSM.dl_std_code,

Line 963: cp_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE ,

959: lv_class_std_rec c_class_std%ROWTYPE ;
960:
961: -- Cursor to get dl_std_code
962: CURSOR c_dl_cl_std_code ( cp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE ,
963: cp_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE ,
964: cp_cs_schdl_id igf_ap_pr_prg_type.igs_pr_cs_schdl_id%TYPE ,
965: cp_css_class_std_id igf_ap_class_std_map.igs_pr_css_class_std_id%TYPE ) IS
966: SELECT CSM.dl_std_code,
967: CSM.cl_std_code

Line 978: CURSOR c_get_acad_hist ( cp_person_id igf_ap_fa_base_rec.person_id%TYPE ) IS

974: AND CSM.igs_pr_css_class_std_id = cp_css_class_std_id ;
975: lv_dl_cl_std_code_rec c_dl_cl_std_code%ROWTYPE ;
976:
977: -- Cursor to get acad history ( institutions attended by the student )
978: CURSOR c_get_acad_hist ( cp_person_id igf_ap_fa_base_rec.person_id%TYPE ) IS
979: SELECT COUNT(institution_code)
980: FROM igs_ad_acad_history_v acad, igs_or_org_inst_type org
981: WHERE acad.institution_type = org.institution_type
982: AND person_id = cp_person_id

Line 1045: PROCEDURE return_entities ( P_base_id IN igf_ap_fa_base_rec.base_id%TYPE,

1041: app_exception.raise_exception;
1042: END get_dl_cl_std_code ;
1043:
1044:
1045: PROCEDURE return_entities ( P_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1046: p_grd_dl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1047: p_enrl_stat OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,
1048: p_grd_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1049: p_anticip_comp_date OUT NOCOPY igf_sl_lor.anticip_compl_date%TYPE) IS

Line 1076: FROM igf_ap_fa_base_rec

1072: ***************************************************************/
1073:
1074: CURSOR c_cal_seq (cp_baseid NUMBER) IS
1075: SELECT ci_cal_type, ci_sequence_number
1076: FROM igf_ap_fa_base_rec
1077: WHERE base_id = cp_baseid;
1078:
1079: CURSOR c_awd_yr (cp_cal_type igs_ca_inst.cal_type%TYPE ,
1080: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS

Line 1089: l_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;

1085:
1086: l_person_number igf_ap_fa_con_v.person_number%TYPE;
1087: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;
1088: l_cal_seq_rec c_cal_seq%ROWTYPE;
1089: l_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
1090: l_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
1091:
1092:
1093: -- Declarations as part of bug 2385334

Line 1090: l_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;

1086: l_person_number igf_ap_fa_con_v.person_number%TYPE;
1087: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;
1088: l_cal_seq_rec c_cal_seq%ROWTYPE;
1089: l_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
1090: l_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
1091:
1092:
1093: -- Declarations as part of bug 2385334
1094: lv_class_standing igs_pr_css_class_std_v.class_standing%TYPE;

Line 1167: PROCEDURE get_fa_base_details(p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,

1163: WHEN NO_DATA_FOUND THEN
1164: NULL;
1165: END return_entities;
1166:
1167: PROCEDURE get_fa_base_details(p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1168: p_s_default_status OUT NOCOPY igf_sl_lor.s_default_status%TYPE,
1169: p_grade_dl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1170: p_grade_cl OUT NOCOPY igf_sl_lor.grade_level_code%TYPE,
1171: p_enroll_code OUT NOCOPY igf_sl_lor.enrollment_code%TYPE,

Line 1191: lv_nslds_data_override_flg igf_ap_fa_base_rec_all.nslds_data_override_flg%TYPE;

1187: ***************************************************************/
1188:
1189: lv_s_default_status igf_sl_lor_all.s_default_status%TYPE;
1190: lv_match_flag igf_ap_isir_matched_all.nslds_match_flag%TYPE;
1191: lv_nslds_data_override_flg igf_ap_fa_base_rec_all.nslds_data_override_flg%TYPE;
1192: lv_adnl_unsub_loan_elig_flag igf_ap_fa_base_rec_all.adnl_unsub_loan_elig_flag%TYPE;
1193:
1194: CURSOR cur_nslds_data IS
1195: SELECT isirm.nslds_match_flag, NVL(fabase.nslds_data_override_flg,'N'),isirm.transaction_num,

Line 1192: lv_adnl_unsub_loan_elig_flag igf_ap_fa_base_rec_all.adnl_unsub_loan_elig_flag%TYPE;

1188:
1189: lv_s_default_status igf_sl_lor_all.s_default_status%TYPE;
1190: lv_match_flag igf_ap_isir_matched_all.nslds_match_flag%TYPE;
1191: lv_nslds_data_override_flg igf_ap_fa_base_rec_all.nslds_data_override_flg%TYPE;
1192: lv_adnl_unsub_loan_elig_flag igf_ap_fa_base_rec_all.adnl_unsub_loan_elig_flag%TYPE;
1193:
1194: CURSOR cur_nslds_data IS
1195: SELECT isirm.nslds_match_flag, NVL(fabase.nslds_data_override_flg,'N'),isirm.transaction_num,
1196: NVL(fabase.adnl_unsub_loan_elig_flag,'N') adnl_unsub_loan_elig_flag -- FA134

Line 1198: igf_ap_fa_base_rec_all fabase

1194: CURSOR cur_nslds_data IS
1195: SELECT isirm.nslds_match_flag, NVL(fabase.nslds_data_override_flg,'N'),isirm.transaction_num,
1196: NVL(fabase.adnl_unsub_loan_elig_flag,'N') adnl_unsub_loan_elig_flag -- FA134
1197: FROM igf_ap_isir_matched_all isirm,
1198: igf_ap_fa_base_rec_all fabase
1199: WHERE fabase.base_id = p_base_id
1200: AND fabase.base_id = isirm.base_id
1201: AND isirm.payment_isir = 'Y'
1202: AND isirm.system_record_type = 'ORIGINAL';

Line 2004: igf_ap_fa_base_rec_all fa

2000: FROM igf_sl_loans_all loan,
2001: igf_aw_award_all awd,
2002: igf_aw_fund_mast_all fmast,
2003: igf_aw_fund_cat_all fcat,
2004: igf_ap_fa_base_rec_all fa
2005: WHERE loan.award_id = awd.award_id
2006: AND awd.fund_id = fmast.fund_id
2007: AND fmast.fund_code = fcat.fund_code
2008: AND fmast.ci_cal_type = p_ci_cal_type

Line 2079: igf_ap_fa_base_rec base

2075: FROM
2076: igs_pe_relationships_v v,
2077: igf_aw_award_all awd,
2078: igf_sl_loans_all loans,
2079: igf_ap_fa_base_rec base
2080: WHERE
2081: base.person_id = v.object_ID
2082: AND base.base_id = awd.base_id
2083: AND awd.award_id = loans.award_id

Line 2648: igf_ap_fa_base_rec_all fabase

2644: igf_sl_loans_all loan,
2645: igf_aw_award_all awd,
2646: igf_aw_fund_mast_all fmast,
2647: igf_aw_fund_cat_all fcat,
2648: igf_ap_fa_base_rec_all fabase
2649: WHERE
2650: loan.award_id = awd.award_id AND
2651: awd.fund_id = fmast.fund_id AND
2652: awd.base_id = fabase.base_id AND

Line 3029: FUNCTION per_in_fa ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

3025:
3026: END create_loan_records;
3027:
3028:
3029: FUNCTION per_in_fa ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
3030: p_ci_cal_type VARCHAR2,
3031: p_ci_sequence_number NUMBER,
3032: p_base_id OUT NOCOPY NUMBER
3033: )

Line 3036: CURSOR cur_get_pers_num ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

3032: p_base_id OUT NOCOPY NUMBER
3033: )
3034: RETURN VARCHAR2
3035: IS
3036: CURSOR cur_get_pers_num ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
3037: IS
3038: SELECT person_number
3039: FROM igs_pe_person_base_v
3040: WHERE

Line 3047: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

3043: get_pers_num_rec cur_get_pers_num%ROWTYPE;
3044:
3045: CURSOR cur_get_base (p_cal_type igs_ca_inst_all.cal_type%TYPE,
3046: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
3047: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
3048: IS
3049: SELECT
3050: base_id
3051: FROM

Line 3052: igf_ap_fa_base_rec_all

3048: IS
3049: SELECT
3050: base_id
3051: FROM
3052: igf_ap_fa_base_rec_all
3053: WHERE
3054: person_id = p_person_id AND
3055: ci_cal_type = p_cal_type AND
3056: ci_sequence_number = p_sequence_number;

Line 3208: igf_ap_fa_base_rec_all base,

3204: IS
3205: SELECT awd.award_id,fmast.fund_code
3206: FROM igf_aw_award_all awd,
3207: igf_aw_fund_mast_all fmast,
3208: igf_ap_fa_base_rec_all base,
3209: igf_aw_fund_cat_all fcat
3210: WHERE awd.fund_id = fmast.fund_id
3211: AND awd.base_id = base.base_id
3212: AND awd.award_status = 'ACCEPTED'