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_DB_SF_INTEGRATION dependencies on IGF_AW_FUND_MAST

Line 87: CURSOR cur_disb(cp_cal_type igf_aw_fund_mast_v.ci_cal_type%TYPE,

83:
84: -- Check for Manage Accounts System Option has been added to following cursor
85: -- so that transfer of disbursements for non-sponser parties from Financial Aid
86: -- is not allowed if Manage Accounts Option has value OTHER.
87: CURSOR cur_disb(cp_cal_type igf_aw_fund_mast_v.ci_cal_type%TYPE,
88: cp_sequence_number igf_aw_fund_mast_v.ci_sequence_number%TYPE,
89: cp_fund_id igf_aw_fund_mast_v.fund_id%TYPE,
90: cp_person_id igf_aw_award_v.person_id%TYPE,
91: cp_tp_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,

Line 88: cp_sequence_number igf_aw_fund_mast_v.ci_sequence_number%TYPE,

84: -- Check for Manage Accounts System Option has been added to following cursor
85: -- so that transfer of disbursements for non-sponser parties from Financial Aid
86: -- is not allowed if Manage Accounts Option has value OTHER.
87: CURSOR cur_disb(cp_cal_type igf_aw_fund_mast_v.ci_cal_type%TYPE,
88: cp_sequence_number igf_aw_fund_mast_v.ci_sequence_number%TYPE,
89: cp_fund_id igf_aw_fund_mast_v.fund_id%TYPE,
90: cp_person_id igf_aw_award_v.person_id%TYPE,
91: cp_tp_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,
92: cp_tp_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE,

Line 89: cp_fund_id igf_aw_fund_mast_v.fund_id%TYPE,

85: -- so that transfer of disbursements for non-sponser parties from Financial Aid
86: -- is not allowed if Manage Accounts Option has value OTHER.
87: CURSOR cur_disb(cp_cal_type igf_aw_fund_mast_v.ci_cal_type%TYPE,
88: cp_sequence_number igf_aw_fund_mast_v.ci_sequence_number%TYPE,
89: cp_fund_id igf_aw_fund_mast_v.fund_id%TYPE,
90: cp_person_id igf_aw_award_v.person_id%TYPE,
91: cp_tp_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,
92: cp_tp_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE,
93: cp_manage_accounts igs_fi_control_all.manage_accounts%TYPE

Line 104: igf_aw_fund_mast fnd,

100: fnd.fund_id, fnd.fund_code fund_code
101: FROM igf_db_awd_disb_dtl disb_dlt,
102: igf_aw_awd_disb disb,
103: igf_aw_award awd,
104: igf_aw_fund_mast fnd,
105: igf_aw_fund_cat fcat,
106: igf_ap_fa_base_rec fab
107: WHERE disb_dlt.award_id = disb.award_id
108: AND disb_dlt.disb_num = disb.disb_num

Line 242: FUNCTION validate_fund_id(p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,

238: RETURN FALSE;
239: END IF;
240: END validate_base_id;
241:
242: FUNCTION validate_fund_id(p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
243: p_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
244: p_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE)
245: RETURN BOOLEAN AS
246: /***********************************************************************************************

Line 243: p_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,

239: END IF;
240: END validate_base_id;
241:
242: FUNCTION validate_fund_id(p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
243: p_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
244: p_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE)
245: RETURN BOOLEAN AS
246: /***********************************************************************************************
247:

Line 244: p_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE)

240: END validate_base_id;
241:
242: FUNCTION validate_fund_id(p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
243: p_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
244: p_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE)
245: RETURN BOOLEAN AS
246: /***********************************************************************************************
247:
248: Created By : Sarakshi

Line 259: FROM igf_aw_fund_mast

255: ********************************************************************************************** */
256:
257: CURSOR cur_val IS
258: SELECT 'X'
259: FROM igf_aw_fund_mast
260: WHERE fund_id = p_fund_id
261: AND ci_cal_type =p_cal_type
262: AND ci_sequence_number=p_sequence_number;
263: l_temp VARCHAR2(1);

Line 277: FUNCTION get_bill_desc(p_n_fund_id IN igf_aw_fund_mast.fund_id%TYPE)

273: END IF;
274: END validate_fund_id;
275:
276:
277: FUNCTION get_bill_desc(p_n_fund_id IN igf_aw_fund_mast.fund_id%TYPE)
278: RETURN VARCHAR2 IS
279: ------------------------------------------------------------------
280: --Created by : Sanil Madathil, Oracle IDC
281: --Date created: 03 Jun 2002

Line 291: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%type) IS

287: --
288: --Change History:
289: --Who When What
290: ------------------------------------------------------------------
291: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%type) IS
292: SELECT bill_desc
293: FROM igf_aw_fund_mast
294: WHERE fund_id = cp_fund_id;
295:

Line 293: FROM igf_aw_fund_mast

289: --Who When What
290: ------------------------------------------------------------------
291: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%type) IS
292: SELECT bill_desc
293: FROM igf_aw_fund_mast
294: WHERE fund_id = cp_fund_id;
295:
296: -- cursor c_igf_aw_fund_mast row type variable
297: rec_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;

Line 296: -- cursor c_igf_aw_fund_mast row type variable

292: SELECT bill_desc
293: FROM igf_aw_fund_mast
294: WHERE fund_id = cp_fund_id;
295:
296: -- cursor c_igf_aw_fund_mast row type variable
297: rec_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
298:
299: BEGIN
300: OPEN c_igf_aw_fund_mast(p_n_fund_id);

Line 297: rec_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;

293: FROM igf_aw_fund_mast
294: WHERE fund_id = cp_fund_id;
295:
296: -- cursor c_igf_aw_fund_mast row type variable
297: rec_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
298:
299: BEGIN
300: OPEN c_igf_aw_fund_mast(p_n_fund_id);
301: FETCH c_igf_aw_fund_mast INTO rec_c_igf_aw_fund_mast;

Line 300: OPEN c_igf_aw_fund_mast(p_n_fund_id);

296: -- cursor c_igf_aw_fund_mast row type variable
297: rec_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
298:
299: BEGIN
300: OPEN c_igf_aw_fund_mast(p_n_fund_id);
301: FETCH c_igf_aw_fund_mast INTO rec_c_igf_aw_fund_mast;
302: CLOSE c_igf_aw_fund_mast;
303: RETURN rec_c_igf_aw_fund_mast.bill_desc;
304:

Line 301: FETCH c_igf_aw_fund_mast INTO rec_c_igf_aw_fund_mast;

297: rec_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
298:
299: BEGIN
300: OPEN c_igf_aw_fund_mast(p_n_fund_id);
301: FETCH c_igf_aw_fund_mast INTO rec_c_igf_aw_fund_mast;
302: CLOSE c_igf_aw_fund_mast;
303: RETURN rec_c_igf_aw_fund_mast.bill_desc;
304:
305: END get_bill_desc;

Line 302: CLOSE c_igf_aw_fund_mast;

298:
299: BEGIN
300: OPEN c_igf_aw_fund_mast(p_n_fund_id);
301: FETCH c_igf_aw_fund_mast INTO rec_c_igf_aw_fund_mast;
302: CLOSE c_igf_aw_fund_mast;
303: RETURN rec_c_igf_aw_fund_mast.bill_desc;
304:
305: END get_bill_desc;
306:

Line 303: RETURN rec_c_igf_aw_fund_mast.bill_desc;

299: BEGIN
300: OPEN c_igf_aw_fund_mast(p_n_fund_id);
301: FETCH c_igf_aw_fund_mast INTO rec_c_igf_aw_fund_mast;
302: CLOSE c_igf_aw_fund_mast;
303: RETURN rec_c_igf_aw_fund_mast.bill_desc;
304:
305: END get_bill_desc;
306:
307:

Line 660: l_fee_type igf_aw_fund_mast.fee_type%TYPE;

656: l_var NUMBER(5) := 0;
657: l_count NUMBER(5);
658: l_msg igf_db_awd_disb_dtl.error_desc%TYPE;
659: l_person_id igs_pe_person_v.person_id%TYPE;
660: l_fee_type igf_aw_fund_mast.fee_type%TYPE;
661: l_invoice_desc igs_fi_inv_int.invoice_desc%TYPE;
662: l_amount igf_db_awd_disb_dtl.disb_net_amt%TYPE;
663: l_transaction_type igs_lookups_view.lookup_code%TYPE;
664:

Line 1381: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,

1377: retcode OUT NOCOPY NUMBER,
1378: p_award_year IN VARCHAR2,
1379: p_base_id IN igf_ap_fa_con_v.base_id%TYPE,
1380: p_person_group_id IN igs_pe_persid_group_v.group_id%TYPE,
1381: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
1382: p_term_calendar IN VARCHAR2,
1383: p_d_gl_date IN VARCHAR2
1384: ) AS
1385: /***********************************************************************************************

Line 1439: FROM igf_aw_fund_mast

1435: l_cur_person cur_person%ROWTYPE;
1436:
1437: CURSOR cur_fund IS
1438: SELECT fund_code
1439: FROM igf_aw_fund_mast
1440: WHERE fund_id = p_fund_id;
1441: l_cur_fund cur_fund%ROWTYPE;
1442:
1443: CURSOR cur_base(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,