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 IGS_CA_INST

Line 168: g_alternate_code igs_ca_inst_all.alternate_code%TYPE;

164: g_person_log igf_lookups_view.meaning%TYPE;
165: g_year VARCHAR2(80);
166: g_start_date DATE;
167: g_end_date DATE;
168: g_alternate_code igs_ca_inst_all.alternate_code%TYPE;
169: g_student_person_id NUMBER; -- Bug # 4636920 - bvisvana
170:
171:
172: PROCEDURE get_borrower_parent_id (

Line 522: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

518:
519: END get_grp_name;
520:
521: PROCEDURE get_dl_entity_id(p_base_id IN NUMBER,
522: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
523: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
524: p_atd_entity_id_txt OUT NOCOPY VARCHAR2,
525: p_rep_entity_id_txt OUT NOCOPY VARCHAR2,
526: p_message OUT NOCOPY VARCHAR2,

Line 523: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

519: END get_grp_name;
520:
521: PROCEDURE get_dl_entity_id(p_base_id IN NUMBER,
522: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
523: p_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
524: p_atd_entity_id_txt OUT NOCOPY VARCHAR2,
525: p_rep_entity_id_txt OUT NOCOPY VARCHAR2,
526: p_message OUT NOCOPY VARCHAR2,
527: p_return_status OUT NOCOPY VARCHAR2)

Line 530: p_cal_type igs_ca_inst.cal_type%TYPE,

526: p_message OUT NOCOPY VARCHAR2,
527: p_return_status OUT NOCOPY VARCHAR2)
528: IS
529: CURSOR c_get_rep_entity_id_txt(
530: p_cal_type igs_ca_inst.cal_type%TYPE,
531: p_seq_num igs_ca_inst.sequence_number%TYPE,
532: p_atd_entity_id igf_gr_attend_pell.atd_entity_id_txt%TYPE
533: )
534: IS

Line 531: p_seq_num igs_ca_inst.sequence_number%TYPE,

527: p_return_status OUT NOCOPY VARCHAR2)
528: IS
529: CURSOR c_get_rep_entity_id_txt(
530: p_cal_type igs_ca_inst.cal_type%TYPE,
531: p_seq_num igs_ca_inst.sequence_number%TYPE,
532: p_atd_entity_id igf_gr_attend_pell.atd_entity_id_txt%TYPE
533: )
534: IS
535: SELECT rep.rep_entity_id_txt

Line 1079: CURSOR c_awd_yr (cp_cal_type igs_ca_inst.cal_type%TYPE ,

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
1081: SELECT alternate_code
1082: FROM igs_ca_inst
1083: WHERE cal_type = cp_cal_type

Line 1080: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS

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
1081: SELECT alternate_code
1082: FROM igs_ca_inst
1083: WHERE cal_type = cp_cal_type
1084: AND sequence_number = cp_sequence_number ;

Line 1082: FROM igs_ca_inst

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
1081: SELECT alternate_code
1082: FROM igs_ca_inst
1083: WHERE cal_type = cp_cal_type
1084: AND sequence_number = cp_sequence_number ;
1085:
1086: l_person_number igf_ap_fa_con_v.person_number%TYPE;

Line 1087: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;

1083: WHERE cal_type = cp_cal_type
1084: AND sequence_number = cp_sequence_number ;
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:

Line 1246: p_cal_type IN igs_ca_inst.cal_type%TYPE,

1242:
1243: /* Procedure to insert Direct Loan Originations into IGF_SL_LOR */
1244:
1245: PROCEDURE insert_lor_dl_records(
1246: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1247: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1248: p_loan_id IN igf_sl_loans.loan_id%TYPE
1249: )AS
1250: /***************************************************************

Line 1247: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,

1243: /* Procedure to insert Direct Loan Originations into IGF_SL_LOR */
1244:
1245: PROCEDURE insert_lor_dl_records(
1246: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1247: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1248: p_loan_id IN igf_sl_loans.loan_id%TYPE
1249: )AS
1250: /***************************************************************
1251: Created By : mesriniv

Line 1273: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;

1269: ln_origination_id igf_sl_lor_all.origination_id%TYPE;
1270: ld_sch_cert_date DATE;
1271: lv_orig_fee_perct igf_sl_dl_setup_all.orig_fee_perct_stafford%TYPE;
1272: lv_match_flag igf_ap_isir_matched_all.nslds_match_flag%TYPE;
1273: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
1274: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1275: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
1276: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
1277: lv_message VARCHAR2(100);

Line 1274: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;

1270: ld_sch_cert_date DATE;
1271: lv_orig_fee_perct igf_sl_dl_setup_all.orig_fee_perct_stafford%TYPE;
1272: lv_match_flag igf_ap_isir_matched_all.nslds_match_flag%TYPE;
1273: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
1274: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1275: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
1276: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
1277: lv_message VARCHAR2(100);
1278: c_loan_number getloannumber%ROWTYPE;

Line 1275: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;

1271: lv_orig_fee_perct igf_sl_dl_setup_all.orig_fee_perct_stafford%TYPE;
1272: lv_match_flag igf_ap_isir_matched_all.nslds_match_flag%TYPE;
1273: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
1274: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1275: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
1276: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
1277: lv_message VARCHAR2(100);
1278: c_loan_number getloannumber%ROWTYPE;
1279: l_parent_person_id NUMBER;

Line 1276: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;

1272: lv_match_flag igf_ap_isir_matched_all.nslds_match_flag%TYPE;
1273: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
1274: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1275: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
1276: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
1277: lv_message VARCHAR2(100);
1278: c_loan_number getloannumber%ROWTYPE;
1279: l_parent_person_id NUMBER;
1280: l_student_person_id NUMBER;

Line 1472: p_cal_type IN igs_ca_inst.cal_type%TYPE,

1468:
1469: /* Procedure to insert into IGF_SL_LOR for CL Loans*/
1470:
1471: PROCEDURE insert_lor_cl_records(
1472: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1473: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1474: p_loan_id IN igf_sl_loans.loan_id%TYPE,
1475: p_comp_date IN igf_sl_lor.anticip_compl_date%TYPE,
1476: p_grd_cl IN igf_sl_lor.grade_level_code%TYPE

Line 1473: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,

1469: /* Procedure to insert into IGF_SL_LOR for CL Loans*/
1470:
1471: PROCEDURE insert_lor_cl_records(
1472: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1473: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1474: p_loan_id IN igf_sl_loans.loan_id%TYPE,
1475: p_comp_date IN igf_sl_lor.anticip_compl_date%TYPE,
1476: p_grd_cl IN igf_sl_lor.grade_level_code%TYPE
1477: )AS

Line 1986: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

1982:
1983: PROCEDURE update_loan_rec(p_award_id number,
1984: p_fund_id number,
1985: p_base_id number,
1986: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1987: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1988: IS
1989:
1990: CURSOR cur_loan IS

Line 1987: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)

1983: PROCEDURE update_loan_rec(p_award_id number,
1984: p_fund_id number,
1985: p_base_id number,
1986: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1987: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1988: IS
1989:
1990: CURSOR cur_loan IS
1991: SELECT loan.*,

Line 2066: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;

2062: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
2063: alien_dtl_cur igf_sl_gen.person_dtl_cur;
2064: alien_dtl_rec igf_sl_gen.person_dtl_rec;
2065:
2066: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
2067: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
2068: lv_message VARCHAR2(100);
2069:
2070: --Bug# 5006583

Line 2067: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;

2063: alien_dtl_cur igf_sl_gen.person_dtl_cur;
2064: alien_dtl_rec igf_sl_gen.person_dtl_rec;
2065:
2066: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
2067: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
2068: lv_message VARCHAR2(100);
2069:
2070: --Bug# 5006583
2071: CURSOR get_parent_id_cur (cp_loan_id igf_sl_lor.loan_id%TYPE

Line 2601: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

2597:
2598: PROCEDURE create_loan_records(p_award_id number,
2599: p_fund_id number,
2600: p_base_id number,
2601: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
2602: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2603: p_dl_setup BOOLEAN,
2604: p_cl_setup BOOLEAN) IS
2605: /*******************************************************************************

Line 2602: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,

2598: PROCEDURE create_loan_records(p_award_id number,
2599: p_fund_id number,
2600: p_base_id number,
2601: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
2602: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2603: p_dl_setup BOOLEAN,
2604: p_cl_setup BOOLEAN) IS
2605: /*******************************************************************************
2606: Change History :

Line 3045: CURSOR cur_get_base (p_cal_type igs_ca_inst_all.cal_type%TYPE,

3041: person_id = p_person_id;
3042:
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

Line 3046: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,

3042:
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

Line 3159: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE;

3155: from creating Loans
3156:
3157: ***************************************************************/
3158:
3159: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
3160: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
3161:
3162: lv_loan_number igf_sl_loans_all.loan_number%TYPE;
3163:

Line 3160: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

3156:
3157: ***************************************************************/
3158:
3159: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
3160: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
3161:
3162: lv_loan_number igf_sl_loans_all.loan_number%TYPE;
3163:
3164: lv_loan_status igf_sl_loans_all.loan_status%TYPE;

Line 3194: FROM igs_ca_inst ca

3190:
3191: --Cursor to get the alternate code for the calendar instance
3192: CURSOR cur_alternate_code IS
3193: SELECT ca.alternate_code,start_dt,end_dt
3194: FROM igs_ca_inst ca
3195: WHERE ca.cal_type =p_ci_cal_type
3196: AND ca.sequence_number = p_ci_sequence_number;
3197:
3198: --Bug 23241893 LAR Process does not populate loan amount correctly