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 32: PROCEDURE get_loan_amts(p_ci_cal_type IN igs_ca_inst_all.cal_type%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,
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,

Line 33: p_ci_seq_num IN igs_ca_inst_all.sequence_number%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,
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,

Line 48: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

44: --
45: -----------------------------------------------------------------------------------
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,

Line 49: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

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

Line 57: p_ci_cal_type igs_ca_inst.cal_type%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,
61: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)

Line 58: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,

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,
61: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)
62: RETURN NUMBER;

Line 65: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

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,
69: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)

Line 66: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,

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,
69: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE DEFAULT NULL)
70: RETURN NUMBER;

Line 73: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

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)
77: RETURN VARCHAR2;

Line 74: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,

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)
77: RETURN VARCHAR2;
78: FUNCTION get_cl_auto_late_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,

Line 79: p_ci_cal_type igs_ca_inst.cal_type%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)
83: RETURN VARCHAR2;

Line 80: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,

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)
83: RETURN VARCHAR2;
84:

Line 98: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

94: RETURN VARCHAR2;
95:
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: );

Line 99: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

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