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 IGF_AW_FUND_CAT

Line 34: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%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,
35: p_gross_amt IN igf_aw_awd_disb_all.disb_gross_amt%TYPE,
36: p_rebate_amt OUT NOCOPY igf_aw_awd_disb_all.int_rebate_amt%TYPE,
37: p_loan_fee_amt OUT NOCOPY igf_aw_awd_disb_all.fee_1%TYPE,
38: p_net_amt OUT NOCOPY igf_aw_awd_disb_all.disb_net_amt%TYPE);

Line 53: p_alt_rel_code IN igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL

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,
57: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

Line 56: FUNCTION get_loan_fee1(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%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,
57: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
58: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
59: p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,
60: p_rel_code VARCHAR2 DEFAULT NULL,

Line 61: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)

57: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
58: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
59: p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,
60: p_rel_code VARCHAR2 DEFAULT NULL,
61: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)
62: RETURN NUMBER;
63:
64: FUNCTION get_loan_fee2(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
65: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

Line 64: FUNCTION get_loan_fee2(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,

60: p_rel_code VARCHAR2 DEFAULT NULL,
61: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)
62: RETURN NUMBER;
63:
64: FUNCTION get_loan_fee2(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
65: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
66: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
67: p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,
68: p_rel_code VARCHAR2 DEFAULT NULL,

Line 69: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)

65: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
66: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
67: p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,
68: p_rel_code VARCHAR2 DEFAULT NULL,
69: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)
70: RETURN NUMBER;
71:
72: FUNCTION get_cl_hold_rel_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
73: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

Line 72: FUNCTION get_cl_hold_rel_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,

68: p_rel_code VARCHAR2 DEFAULT NULL,
69: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)
70: RETURN NUMBER;
71:
72: FUNCTION get_cl_hold_rel_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
73: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
74: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
75: p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,
76: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)

Line 76: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)

72: FUNCTION get_cl_hold_rel_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
73: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
74: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
75: p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,
76: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)
77: RETURN VARCHAR2;
78: FUNCTION get_cl_auto_late_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
79: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
80: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,

Line 78: FUNCTION get_cl_auto_late_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,

74: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
75: p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,
76: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)
77: RETURN VARCHAR2;
78: FUNCTION get_cl_auto_late_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
79: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
80: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
81: p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,
82: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)

Line 82: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)

78: FUNCTION get_cl_auto_late_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
79: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
80: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
81: p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,
82: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)
83: RETURN VARCHAR2;
84:
85:
86: FUNCTION chk_disb_date(p_award_id igf_sl_loans.award_id%TYPE,

Line 93: FUNCTION get_alt_rel_code(p_fund_code igf_aw_fund_cat_all.fund_code%TYPE)

89: RETURN VARCHAR2;
90:
91: FUNCTION chk_loan_upd_lock(p_award_id igf_sl_loans.award_id%TYPE)
92: RETURN VARCHAR2;
93: FUNCTION get_alt_rel_code(p_fund_code igf_aw_fund_cat_all.fund_code%TYPE)
94: RETURN VARCHAR2;
95:
96: PROCEDURE recalc_fees(
97: p_base_id IN igf_aw_award_all.base_id%TYPE,