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_ALL

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 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 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 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;