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_AWARD_ALL

Line 27: g_base_id igf_aw_award_all.base_id%TYPE;

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

Line 47: p_base_id IN igf_aw_award_all.base_id%TYPE,

43: -- combined fee int rebate anount and disb net amonut for Direct Loans
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,

Line 59: p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,

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

Line 67: p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,

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

Line 75: p_base_id igf_aw_award_all.base_id%TYPE DEFAULT NULL,

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

Line 81: p_base_id igf_aw_award_all.base_id%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:
85:

Line 97: p_base_id IN igf_aw_award_all.base_id%TYPE,

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

Line 105: FUNCTION chk_chg_enable (p_n_award_id igf_aw_award_all.award_id%TYPE)

101: p_award_id IN igf_sl_loans.award_id%TYPE
102: );
103:
104:
105: FUNCTION chk_chg_enable (p_n_award_id igf_aw_award_all.award_id%TYPE)
106: RETURN BOOLEAN;
107:
108: FUNCTION chk_add_new_disb (p_n_award_id igf_aw_award_all.award_id%TYPE)
109: RETURN BOOLEAN;

Line 108: FUNCTION chk_add_new_disb (p_n_award_id igf_aw_award_all.award_id%TYPE)

104:
105: FUNCTION chk_chg_enable (p_n_award_id igf_aw_award_all.award_id%TYPE)
106: RETURN BOOLEAN;
107:
108: FUNCTION chk_add_new_disb (p_n_award_id igf_aw_award_all.award_id%TYPE)
109: RETURN BOOLEAN;
110:
111: FUNCTION chk_loan_increase (p_n_award_id igf_aw_award_all.award_id%TYPE)
112: RETURN BOOLEAN;

Line 111: FUNCTION chk_loan_increase (p_n_award_id igf_aw_award_all.award_id%TYPE)

107:
108: FUNCTION chk_add_new_disb (p_n_award_id igf_aw_award_all.award_id%TYPE)
109: RETURN BOOLEAN;
110:
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;

Line 114: FUNCTION get_loan_cl_version (p_n_award_id igf_aw_award_all.award_id%TYPE)

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

Line 117: FUNCTION chk_fund_st_chg ( p_n_award_id IN igf_aw_award_all.award_id%TYPE,

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: )
120: RETURN BOOLEAN;
121: