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.

[Home] [Help]

APPS.IGF_SL_AWARD dependencies on IGF_SL_CL_SETUP

Line 28: g_rel_code igf_sl_cl_setup.relationship_cd%TYPE;

24: (reverse chronological order - newest change first)
25: ***************************************************************/
26:
27: g_base_id igf_aw_award_all.base_id%TYPE;
28: g_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
29: g_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
30: g_party_id igf_sl_cl_setup.party_id%TYPE;
31:
32: PROCEDURE get_loan_amts(p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 30: g_party_id igf_sl_cl_setup.party_id%TYPE;

26:
27: g_base_id igf_aw_award_all.base_id%TYPE;
28: g_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
29: g_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
30: g_party_id igf_sl_cl_setup.party_id%TYPE;
31:
32: PROCEDURE get_loan_amts(p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
33: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
34: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,

Line 50: p_rel_code OUT NOCOPY igf_sl_cl_setup.relationship_cd%TYPE,

46: PROCEDURE pick_setup(
47: p_base_id IN igf_aw_award_all.base_id%TYPE,
48: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
49: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
50: p_rel_code OUT NOCOPY igf_sl_cl_setup.relationship_cd%TYPE,
51: p_person_id OUT NOCOPY igf_sl_cl_pref_lenders.person_id%TYPE,
52: p_party_id OUT NOCOPY igf_sl_cl_setup.party_id%TYPE,
53: p_alt_rel_code IN igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL
54: );

Line 52: p_party_id OUT NOCOPY igf_sl_cl_setup.party_id%TYPE,

48: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
49: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
50: p_rel_code OUT NOCOPY igf_sl_cl_setup.relationship_cd%TYPE,
51: p_person_id OUT NOCOPY igf_sl_cl_pref_lenders.person_id%TYPE,
52: p_party_id OUT NOCOPY igf_sl_cl_setup.party_id%TYPE,
53: p_alt_rel_code IN igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL
54: );
55:
56: FUNCTION get_loan_fee1(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,

Line 100: p_rel_code IN igf_sl_cl_setup.relationship_cd%TYPE,

96: PROCEDURE recalc_fees(
97: p_base_id IN igf_aw_award_all.base_id%TYPE,
98: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
99: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
100: p_rel_code IN igf_sl_cl_setup.relationship_cd%TYPE,
101: p_award_id IN igf_sl_loans.award_id%TYPE
102: );
103:
104:

Line 115: RETURN igf_sl_cl_setup_all.cl_version%TYPE;

111: FUNCTION chk_loan_increase (p_n_award_id igf_aw_award_all.award_id%TYPE)
112: RETURN BOOLEAN;
113:
114: FUNCTION get_loan_cl_version (p_n_award_id igf_aw_award_all.award_id%TYPE)
115: RETURN igf_sl_cl_setup_all.cl_version%TYPE;
116:
117: FUNCTION chk_fund_st_chg ( p_n_award_id IN igf_aw_award_all.award_id%TYPE,
118: p_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE
119: )