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_AWARD dependencies on IGS_CA_INST

Line 74: CURSOR c_dlsetup (p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

70:
71: l_cl_fee1 igf_sl_cl_setup.est_orig_fee_perct%TYPE;
72: l_cl_alt_fee1 igf_sl_cl_setup.est_alt_orig_fee_perct%TYPE;
73:
74: CURSOR c_dlsetup (p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
75: p_ci_seq_num igs_ca_inst_all.sequence_number%TYPE)IS
76: SELECT orig_fee_perct_stafford,
77: orig_fee_perct_plus,
78: int_rebate

Line 75: p_ci_seq_num igs_ca_inst_all.sequence_number%TYPE)IS

71: l_cl_fee1 igf_sl_cl_setup.est_orig_fee_perct%TYPE;
72: l_cl_alt_fee1 igf_sl_cl_setup.est_alt_orig_fee_perct%TYPE;
73:
74: CURSOR c_dlsetup (p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
75: p_ci_seq_num igs_ca_inst_all.sequence_number%TYPE)IS
76: SELECT orig_fee_perct_stafford,
77: orig_fee_perct_plus,
78: int_rebate
79: FROM igf_sl_dl_setup

Line 96: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

92: AND awd.fund_id = fundmast.fund_id
93: AND fundmast.fund_code = fundcat.fund_code;
94:
95: FUNCTION get_cl_hold_rel_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
96: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
97: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
98: p_base_id igf_aw_award_all.base_id%TYPE,
99: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
100: RETURN VARCHAR2

Line 97: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,

93: AND fundmast.fund_code = fundcat.fund_code;
94:
95: FUNCTION get_cl_hold_rel_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
96: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
97: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
98: p_base_id igf_aw_award_all.base_id%TYPE,
99: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
100: RETURN VARCHAR2
101: AS

Line 168: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

164: END get_cl_hold_rel_ind;
165:
166: -- Created as part of FA 122 Loans Enhancements
167: FUNCTION get_cl_auto_late_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
168: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
169: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
170: p_base_id igf_aw_award_all.base_id%TYPE,
171: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
172: RETURN VARCHAR2

Line 169: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,

165:
166: -- Created as part of FA 122 Loans Enhancements
167: FUNCTION get_cl_auto_late_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
168: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
169: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
170: p_base_id igf_aw_award_all.base_id%TYPE,
171: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
172: RETURN VARCHAR2
173: AS

Line 245: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

241:
242: END get_cl_auto_late_ind;
243:
244: FUNCTION get_loan_fee1(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
245: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
246: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
247: p_base_id igf_aw_award_all.base_id%TYPE,
248: p_rel_code VARCHAR2,
249: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)

Line 246: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,

242: END get_cl_auto_late_ind;
243:
244: FUNCTION get_loan_fee1(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
245: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
246: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
247: p_base_id igf_aw_award_all.base_id%TYPE,
248: p_rel_code VARCHAR2,
249: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
250: RETURN NUMBER

Line 380: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

376:
377:
378:
379: FUNCTION get_loan_fee2(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
380: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
381: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
382: p_base_id igf_aw_award_all.base_id%TYPE,
383: p_rel_code VARCHAR2,
384: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)

Line 381: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,

377:
378:
379: FUNCTION get_loan_fee2(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
380: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
381: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
382: p_base_id igf_aw_award_all.base_id%TYPE,
383: p_rel_code VARCHAR2,
384: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
385: RETURN NUMBER

Line 662: PROCEDURE get_loan_amts(p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

658: app_exception.raise_exception;
659:
660: END chk_loan_upd_lock;
661:
662: PROCEDURE get_loan_amts(p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
663: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
664: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
665: p_gross_amt IN igf_aw_awd_disb_all.disb_gross_amt%TYPE,
666: p_rebate_amt OUT NOCOPY igf_aw_awd_disb_all.int_rebate_amt%TYPE,

Line 663: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

659:
660: END chk_loan_upd_lock;
661:
662: PROCEDURE get_loan_amts(p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
663: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
664: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
665: p_gross_amt IN igf_aw_awd_disb_all.disb_gross_amt%TYPE,
666: p_rebate_amt OUT NOCOPY igf_aw_awd_disb_all.int_rebate_amt%TYPE,
667: p_loan_fee_amt OUT NOCOPY igf_aw_awd_disb_all.fee_1%TYPE,

Line 726: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

722: END get_loan_amts;
723:
724: PROCEDURE recalc_fees(
725: p_base_id IN igf_aw_award_all.base_id%TYPE,
726: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
727: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
728: p_rel_code IN igf_sl_cl_setup.relationship_cd%TYPE,
729: p_award_id IN igf_sl_loans.award_id%TYPE
730: )

Line 727: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

723:
724: PROCEDURE recalc_fees(
725: p_base_id IN igf_aw_award_all.base_id%TYPE,
726: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
727: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
728: p_rel_code IN igf_sl_cl_setup.relationship_cd%TYPE,
729: p_award_id IN igf_sl_loans.award_id%TYPE
730: )
731: IS

Line 922: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

918: END recalc_fees;
919:
920: PROCEDURE pick_setup(
921: p_base_id IN igf_aw_award_all.base_id%TYPE,
922: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
923: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
924: p_rel_code OUT NOCOPY igf_sl_cl_setup.relationship_cd%TYPE,
925: p_person_id OUT NOCOPY igf_sl_cl_pref_lenders.person_id%TYPE,
926: p_party_id OUT NOCOPY igf_sl_cl_setup.party_id%TYPE, -- this is used in FA 126

Line 923: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

919:
920: PROCEDURE pick_setup(
921: p_base_id IN igf_aw_award_all.base_id%TYPE,
922: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
923: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
924: p_rel_code OUT NOCOPY igf_sl_cl_setup.relationship_cd%TYPE,
925: p_person_id OUT NOCOPY igf_sl_cl_pref_lenders.person_id%TYPE,
926: p_party_id OUT NOCOPY igf_sl_cl_setup.party_id%TYPE, -- this is used in FA 126
927: p_alt_rel_code IN igf_aw_fund_cat_all.alt_rel_code%TYPE )

Line 969: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

965:
966: l_chk_pref_lender c_chk_pref_lender%ROWTYPE;
967:
968: CURSOR c_get_default_lender (
969: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
970: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
971: cp_default_flag igf_sl_cl_setup.default_flag%TYPE
972: )
973: IS

Line 970: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,

966: l_chk_pref_lender c_chk_pref_lender%ROWTYPE;
967:
968: CURSOR c_get_default_lender (
969: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
970: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
971: cp_default_flag igf_sl_cl_setup.default_flag%TYPE
972: )
973: IS
974: SELECT relationship_cd

Line 984: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

980:
981: l_get_default_lender c_get_default_lender%ROWTYPE;
982:
983: CURSOR c_get_ovrd_lender (
984: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
985: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
986: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
987: cp_party_id igf_sl_cl_setup.party_id%TYPE
988: )

Line 985: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,

981: l_get_default_lender c_get_default_lender%ROWTYPE;
982:
983: CURSOR c_get_ovrd_lender (
984: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
985: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
986: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
987: cp_party_id igf_sl_cl_setup.party_id%TYPE
988: )
989: IS

Line 1000: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

996:
997: l_get_ovrd_lender c_get_ovrd_lender%ROWTYPE;
998:
999: CURSOR c_get_ovrd_default_lender (
1000: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
1001: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1002: cp_party_id igf_sl_cl_setup.party_id%TYPE,
1003: cp_default_flag igf_sl_cl_setup.default_flag%TYPE
1004: )

Line 1001: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,

997: l_get_ovrd_lender c_get_ovrd_lender%ROWTYPE;
998:
999: CURSOR c_get_ovrd_default_lender (
1000: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
1001: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1002: cp_party_id igf_sl_cl_setup.party_id%TYPE,
1003: cp_default_flag igf_sl_cl_setup.default_flag%TYPE
1004: )
1005: IS

Line 1017: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

1013: l_get_ovrd_default_lender c_get_ovrd_default_lender%ROWTYPE;
1014:
1015:
1016: CURSOR cur_find_lender (
1017: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
1018: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1019: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE
1020: )
1021: IS

Line 1018: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1014:
1015:
1016: CURSOR cur_find_lender (
1017: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
1018: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1019: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE
1020: )
1021: IS
1022: SELECT relationship_cd