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

Line 23: -- x_donot_repkg_if_code ,x_re_pkg_verif_flag of igf_aw_fund_mast_pkg.insert_row

19: -- and removed the code logic to log 'IGF_AW_FND_RLOVR_LD_NTFND'
20: -- as the later message is obsoleted.
21: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Modified sponsor_fund_rollover and sponsor_student_rollover
22: --akandreg 29-Mar-2006 Bug 4765537. Passed appropriate values to parameters x_lock_award_flag,
23: -- x_donot_repkg_if_code ,x_re_pkg_verif_flag of igf_aw_fund_mast_pkg.insert_row
24: --museshad 14-Jul-2005 Build FA 140.
25: -- Modified TBH call due to the addition of new
26: -- columns to igf_aw_fund_mast_all table.
27: --museshad 25-May-2005 Build FA 157.

Line 26: -- columns to igf_aw_fund_mast_all table.

22: --akandreg 29-Mar-2006 Bug 4765537. Passed appropriate values to parameters x_lock_award_flag,
23: -- x_donot_repkg_if_code ,x_re_pkg_verif_flag of igf_aw_fund_mast_pkg.insert_row
24: --museshad 14-Jul-2005 Build FA 140.
25: -- Modified TBH call due to the addition of new
26: -- columns to igf_aw_fund_mast_all table.
27: --museshad 25-May-2005 Build FA 157.
28: -- New column 'DISB_ROUNDING_CODE' has been added
29: -- to the table 'IGF_AW_FUND_MAST_ALL'.
30: -- Modified calls to TBH.

Line 29: -- to the table 'IGF_AW_FUND_MAST_ALL'.

25: -- Modified TBH call due to the addition of new
26: -- columns to igf_aw_fund_mast_all table.
27: --museshad 25-May-2005 Build FA 157.
28: -- New column 'DISB_ROUNDING_CODE' has been added
29: -- to the table 'IGF_AW_FUND_MAST_ALL'.
30: -- Modified calls to TBH.
31: --brajendr 13-Oct-2004 FA152 COA and FA137 Repackaging design changes
32: -- Added the new column to the form and the TBH calls
33: --veramach July 2004 FA 151 HR Integration(bug #3709292)

Line 39: -- p_cal_type,p_sequence_number and from cursor c_igf_aw_fund_mast and its usage.Modified function lookup_desc.

35: --vvutukur 18-Jul-2003 Enh#3038511.FICR106 Build. Modified procedure sponsor_rollover.
36: --pathipat 28-Apr-2003 Enh 2831569 - Commercial Receivables build
37: -- Modified sponsor_rollover() - Added call to chk_manage_account()
38: --vvutukur 25-Mar-2003 Bug#2822725.Modified procedures sponsor_fund_rollover,sponsor_student_rollover to remove parameters
39: -- p_cal_type,p_sequence_number and from cursor c_igf_aw_fund_mast and its usage.Modified function lookup_desc.
40: --vchappid 18-Feb-2003 Bug 2785649, Sponsor Code is made mandatory. Modified cursor c_igf_aw_fund_mast
41: -- for removing handling NULL value of Fund ID input parameter
42: -- Fund Id is made mandatory. When this parameter is null, process will error out
43: --adhawan 06-nov-2002 Obsoletion of sap_type from the tbh of igf_aw_fund_mast_pkg

Line 40: --vchappid 18-Feb-2003 Bug 2785649, Sponsor Code is made mandatory. Modified cursor c_igf_aw_fund_mast

36: --pathipat 28-Apr-2003 Enh 2831569 - Commercial Receivables build
37: -- Modified sponsor_rollover() - Added call to chk_manage_account()
38: --vvutukur 25-Mar-2003 Bug#2822725.Modified procedures sponsor_fund_rollover,sponsor_student_rollover to remove parameters
39: -- p_cal_type,p_sequence_number and from cursor c_igf_aw_fund_mast and its usage.Modified function lookup_desc.
40: --vchappid 18-Feb-2003 Bug 2785649, Sponsor Code is made mandatory. Modified cursor c_igf_aw_fund_mast
41: -- for removing handling NULL value of Fund ID input parameter
42: -- Fund Id is made mandatory. When this parameter is null, process will error out
43: --adhawan 06-nov-2002 Obsoletion of sap_type from the tbh of igf_aw_fund_mast_pkg
44: --2613536

Line 43: --adhawan 06-nov-2002 Obsoletion of sap_type from the tbh of igf_aw_fund_mast_pkg

39: -- p_cal_type,p_sequence_number and from cursor c_igf_aw_fund_mast and its usage.Modified function lookup_desc.
40: --vchappid 18-Feb-2003 Bug 2785649, Sponsor Code is made mandatory. Modified cursor c_igf_aw_fund_mast
41: -- for removing handling NULL value of Fund ID input parameter
42: -- Fund Id is made mandatory. When this parameter is null, process will error out
43: --adhawan 06-nov-2002 Obsoletion of sap_type from the tbh of igf_aw_fund_mast_pkg
44: --2613536
45: -- adhawan 31-oct-2002 Added gift_aid to insert row of Fund Manager
46: --2613546
47: -------------------------------------------------------------------

Line 72: FUNCTION validate_fund(p_fund IN igf_aw_fund_mast.fund_id%TYPE ,

68: p_msg_val IN VARCHAR2
69: ) ;
70:
71: -- function to validate the fund
72: FUNCTION validate_fund(p_fund IN igf_aw_fund_mast.fund_id%TYPE ,
73: p_cal_type IN igs_ca_inst.cal_type%TYPE,
74: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
75: p_err_message OUT NOCOPY VARCHAR2
76: ) RETURN BOOLEAN;

Line 87: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE

83:
84: -- procedure which rollover over the sponsor fund details
85: PROCEDURE sponsor_fund_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,
86: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
87: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE
88: ) ;
89:
90: -- procedure which rollover over the sponsor student relation
91: PROCEDURE sponsor_student_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 93: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE

89:
90: -- procedure which rollover over the sponsor student relation
91: PROCEDURE sponsor_student_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,
92: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
93: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE
94: );
95:
96: -- Forward declaration of functions/procedures ends here
97:

Line 98: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter

94: );
95:
96: -- Forward declaration of functions/procedures ends here
97:
98: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter
99: -- This cursor definition is public to this package body;
100: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
101: SELECT fmast.*
102: FROM igf_aw_fund_mast fmast ,

Line 100: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS

96: -- Forward declaration of functions/procedures ends here
97:
98: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter
99: -- This cursor definition is public to this package body;
100: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
101: SELECT fmast.*
102: FROM igf_aw_fund_mast fmast ,
103: igf_aw_fund_cat fcat
104: WHERE fmast.fund_code = fcat.fund_code

Line 102: FROM igf_aw_fund_mast fmast ,

98: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter
99: -- This cursor definition is public to this package body;
100: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
101: SELECT fmast.*
102: FROM igf_aw_fund_mast fmast ,
103: igf_aw_fund_cat fcat
104: WHERE fmast.fund_code = fcat.fund_code
105: AND fmast.fund_id = cp_fund_id
106: AND fcat.sys_fund_type = g_c_fund_type

Line 129: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

125: PROCEDURE sponsor_rollover ( errbuf OUT NOCOPY VARCHAR2 ,
126: retcode OUT NOCOPY NUMBER ,
127: p_award_year IN VARCHAR2 ,
128: p_rollover IN VARCHAR2 ,
129: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
130: p_run_mode IN VARCHAR2
131: ) IS
132: ------------------------------------------------------------------
133: --Created by : Sanil Madathil, Oracle IDC

Line 177: -- cursor variable for c_igf_aw_fund_mast

173: l_sc_sequence_number igs_ca_inst_all.sequence_number%TYPE;
174: l_err_message VARCHAR2(30);
175: -- cursor variable for c_igf_aw_cal_rel
176: l_c_igf_aw_cal_rel c_igf_aw_cal_rel%ROWTYPE;
177: -- cursor variable for c_igf_aw_fund_mast
178: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
179:
180: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
181: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;

Line 178: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;

174: l_err_message VARCHAR2(30);
175: -- cursor variable for c_igf_aw_cal_rel
176: l_c_igf_aw_cal_rel c_igf_aw_cal_rel%ROWTYPE;
177: -- cursor variable for c_igf_aw_fund_mast
178: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
179:
180: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
181: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
182:

Line 200: -- get sponsor fund code from igf_aw_fund_mast to get fund code for fund id parameter

196: OPEN c_igs_lookups(cp_run_flag => p_run_mode);
197: FETCH c_igs_lookups INTO l_c_igs_lookups;
198: CLOSE c_igs_lookups;
199:
200: -- get sponsor fund code from igf_aw_fund_mast to get fund code for fund id parameter
201: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund_id);
202: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
203: CLOSE c_igf_aw_fund_mast;
204:

Line 201: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund_id);

197: FETCH c_igs_lookups INTO l_c_igs_lookups;
198: CLOSE c_igs_lookups;
199:
200: -- get sponsor fund code from igf_aw_fund_mast to get fund code for fund id parameter
201: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund_id);
202: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
203: CLOSE c_igf_aw_fund_mast;
204:
205: -- log all the parameters passed to the process

Line 202: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;

198: CLOSE c_igs_lookups;
199:
200: -- get sponsor fund code from igf_aw_fund_mast to get fund code for fund id parameter
201: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund_id);
202: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
203: CLOSE c_igf_aw_fund_mast;
204:
205: -- log all the parameters passed to the process
206: log_messages(lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_YEAR'),p_award_year);

Line 203: CLOSE c_igf_aw_fund_mast;

199:
200: -- get sponsor fund code from igf_aw_fund_mast to get fund code for fund id parameter
201: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund_id);
202: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
203: CLOSE c_igf_aw_fund_mast;
204:
205: -- log all the parameters passed to the process
206: log_messages(lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_YEAR'),p_award_year);
207: log_messages(lookup_desc('IGF_AW_LOOKUPS_MSG','FUND_CODE'),l_c_igf_aw_fund_mast.fund_code||' '||l_c_igf_aw_fund_mast.description);

Line 207: log_messages(lookup_desc('IGF_AW_LOOKUPS_MSG','FUND_CODE'),l_c_igf_aw_fund_mast.fund_code||' '||l_c_igf_aw_fund_mast.description);

203: CLOSE c_igf_aw_fund_mast;
204:
205: -- log all the parameters passed to the process
206: log_messages(lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_YEAR'),p_award_year);
207: log_messages(lookup_desc('IGF_AW_LOOKUPS_MSG','FUND_CODE'),l_c_igf_aw_fund_mast.fund_code||' '||l_c_igf_aw_fund_mast.description);
208: log_messages(lookup_desc('IGF_AW_LOOKUPS_MSG','TEST_MODE'),l_c_igs_lookups.meaning);
209:
210: -- Obtain the value of manage_accounts in the System Options form
211: -- If it is null then this process is not available, so error out.

Line 406: FUNCTION validate_fund(p_fund IN igf_aw_fund_mast.fund_id%TYPE ,

402: fnd_file.put_line(fnd_file.log,fnd_message.get);
403: END log_messages;
404:
405:
406: FUNCTION validate_fund(p_fund IN igf_aw_fund_mast.fund_id%TYPE ,
407: p_cal_type IN igs_ca_inst.cal_type%TYPE,
408: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
409: p_err_message OUT NOCOPY VARCHAR2
410: ) RETURN BOOLEAN IS

Line 424: --vvutukur 07-Mar-2003 Bug#2822725. Removed parameters cal_type,sequence_number to open the cursor c_igf_aw_fund_mast.

420: --Known limitations/enhancements and/or remarks:
421: --
422: --Change History:
423: --Who When What
424: --vvutukur 07-Mar-2003 Bug#2822725. Removed parameters cal_type,sequence_number to open the cursor c_igf_aw_fund_mast.
425: ------------------------------------------------------------------
426: -- cursor variable for c_igf_aw_fund_mast
427: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
428: BEGIN

Line 426: -- cursor variable for c_igf_aw_fund_mast

422: --Change History:
423: --Who When What
424: --vvutukur 07-Mar-2003 Bug#2822725. Removed parameters cal_type,sequence_number to open the cursor c_igf_aw_fund_mast.
425: ------------------------------------------------------------------
426: -- cursor variable for c_igf_aw_fund_mast
427: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
428: BEGIN
429: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
430: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;

Line 427: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;

423: --Who When What
424: --vvutukur 07-Mar-2003 Bug#2822725. Removed parameters cal_type,sequence_number to open the cursor c_igf_aw_fund_mast.
425: ------------------------------------------------------------------
426: -- cursor variable for c_igf_aw_fund_mast
427: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
428: BEGIN
429: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
430: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
431: IF c_igf_aw_fund_mast%NOTFOUND THEN

Line 429: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);

425: ------------------------------------------------------------------
426: -- cursor variable for c_igf_aw_fund_mast
427: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
428: BEGIN
429: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
430: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
431: IF c_igf_aw_fund_mast%NOTFOUND THEN
432: CLOSE c_igf_aw_fund_mast;
433: p_err_message := 'IGS_GE_INVALID_VALUE';

Line 430: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;

426: -- cursor variable for c_igf_aw_fund_mast
427: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
428: BEGIN
429: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
430: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
431: IF c_igf_aw_fund_mast%NOTFOUND THEN
432: CLOSE c_igf_aw_fund_mast;
433: p_err_message := 'IGS_GE_INVALID_VALUE';
434: RETURN (FALSE);

Line 431: IF c_igf_aw_fund_mast%NOTFOUND THEN

427: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
428: BEGIN
429: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
430: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
431: IF c_igf_aw_fund_mast%NOTFOUND THEN
432: CLOSE c_igf_aw_fund_mast;
433: p_err_message := 'IGS_GE_INVALID_VALUE';
434: RETURN (FALSE);
435: END IF;

Line 432: CLOSE c_igf_aw_fund_mast;

428: BEGIN
429: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
430: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
431: IF c_igf_aw_fund_mast%NOTFOUND THEN
432: CLOSE c_igf_aw_fund_mast;
433: p_err_message := 'IGS_GE_INVALID_VALUE';
434: RETURN (FALSE);
435: END IF;
436: CLOSE c_igf_aw_fund_mast;

Line 436: CLOSE c_igf_aw_fund_mast;

432: CLOSE c_igf_aw_fund_mast;
433: p_err_message := 'IGS_GE_INVALID_VALUE';
434: RETURN (FALSE);
435: END IF;
436: CLOSE c_igf_aw_fund_mast;
437: p_err_message := NULL;
438: RETURN (TRUE);
439: END validate_fund;
440:

Line 492: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE

488:
489: -- procedure which rollover over the sponsor fund details
490: PROCEDURE sponsor_fund_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,
491: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
492: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE
493: ) IS
494: ------------------------------------------------------------------
495: --Created by : Sanil Madathil, Oracle IDC
496: --Date created: 24 Jan 2001

Line 511: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_aw_fund_mast, igf_sp_fc,

507: --gurprsin 31-May-2006 Bug 5213852, Logged the new message 'IGF_SP_NO_FUND_TERM_MAP' and removed the code logic to
508: -- log 'IGF_AW_FND_RLOVR_LD_NTFND' as the later message is obsoleted. This new message
509: -- will be logged when user tries to rollover Sponsor setup and the associated term
510: -- calendar mapping does not exist for the destination award year.
511: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_aw_fund_mast, igf_sp_fc,
512: -- igf_sp_prg, igf_sp_unit are now rounded off to currency precision
513: --akandreg 29-Mar-2006 Bug 4765537. Passed appropriate values to parameters x_lock_award_flag,
514: -- x_donot_repkg_if_code ,x_re_pkg_verif_flag of igf_aw_fund_mast_pkg.insert_row
515: --museshad 14-Jul-2005 Build FA 140.

Line 514: -- x_donot_repkg_if_code ,x_re_pkg_verif_flag of igf_aw_fund_mast_pkg.insert_row

510: -- calendar mapping does not exist for the destination award year.
511: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_aw_fund_mast, igf_sp_fc,
512: -- igf_sp_prg, igf_sp_unit are now rounded off to currency precision
513: --akandreg 29-Mar-2006 Bug 4765537. Passed appropriate values to parameters x_lock_award_flag,
514: -- x_donot_repkg_if_code ,x_re_pkg_verif_flag of igf_aw_fund_mast_pkg.insert_row
515: --museshad 14-Jul-2005 Build FA 140.
516: -- Modified TBH call due to the addition of new
517: -- columns to igf_aw_fund_mast_all table.
518: --museshad 25-May-2005 Build# FA157 - Bug# 4382371.

Line 517: -- columns to igf_aw_fund_mast_all table.

513: --akandreg 29-Mar-2006 Bug 4765537. Passed appropriate values to parameters x_lock_award_flag,
514: -- x_donot_repkg_if_code ,x_re_pkg_verif_flag of igf_aw_fund_mast_pkg.insert_row
515: --museshad 14-Jul-2005 Build FA 140.
516: -- Modified TBH call due to the addition of new
517: -- columns to igf_aw_fund_mast_all table.
518: --museshad 25-May-2005 Build# FA157 - Bug# 4382371.
519: -- New column 'DISB_ROUNDING_CODE' has been added
520: -- to the table 'IGF_AW_FUND_MAST_ALL'.
521: -- Modified calls to TBH.

Line 520: -- to the table 'IGF_AW_FUND_MAST_ALL'.

516: -- Modified TBH call due to the addition of new
517: -- columns to igf_aw_fund_mast_all table.
518: --museshad 25-May-2005 Build# FA157 - Bug# 4382371.
519: -- New column 'DISB_ROUNDING_CODE' has been added
520: -- to the table 'IGF_AW_FUND_MAST_ALL'.
521: -- Modified calls to TBH.
522: --vvutukur 07-Mar-2003 Bug#2822725. Removed parameters p_cal_type,p_sequence_number of this procedure as they are not required.
523: -- Also same have been removed from cursor c_igf_aw_fund_mast and its usage.
524: --smvk 09-Feb-2003 Bug # 2758812. Added send_without_doc column.

Line 523: -- Also same have been removed from cursor c_igf_aw_fund_mast and its usage.

519: -- New column 'DISB_ROUNDING_CODE' has been added
520: -- to the table 'IGF_AW_FUND_MAST_ALL'.
521: -- Modified calls to TBH.
522: --vvutukur 07-Mar-2003 Bug#2822725. Removed parameters p_cal_type,p_sequence_number of this procedure as they are not required.
523: -- Also same have been removed from cursor c_igf_aw_fund_mast and its usage.
524: --smvk 09-Feb-2003 Bug # 2758812. Added send_without_doc column.
525: ------------------------------------------------------------------
526:
527: l_msg_str_0 VARCHAR2(32767) := NULL;

Line 532: l_fund_id igf_aw_fund_mast_all.fund_id%TYPE;

528: l_msg_str_1 VARCHAR2(32767) := NULL;
529: l_message_name VARCHAR2(30) := NULL;
530: l_err_exception EXCEPTION;
531: l_rowid VARCHAR2(25);
532: l_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
533: l_fee_cls_id igf_sp_fc_all.fee_cls_id%TYPE;
534: l_fee_cls_prg_id igf_sp_prg_all.fee_cls_prg_id%TYPE;
535: l_fee_cls_unit_id igf_sp_unit_all.fee_cls_unit_id%TYPE;
536:

Line 537: CURSOR c_igf_aw_fund_tp( cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS

533: l_fee_cls_id igf_sp_fc_all.fee_cls_id%TYPE;
534: l_fee_cls_prg_id igf_sp_prg_all.fee_cls_prg_id%TYPE;
535: l_fee_cls_unit_id igf_sp_unit_all.fee_cls_unit_id%TYPE;
536:
537: CURSOR c_igf_aw_fund_tp( cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
538: SELECT *
539: FROM igf_aw_fund_tp_v ftp
540: WHERE ftp.fund_id = cp_fund_id
541: ORDER BY tp_cal_type,tp_sequence_number;

Line 545: CURSOR c_igf_sp_fc(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS

541: ORDER BY tp_cal_type,tp_sequence_number;
542:
543: l_c_igf_aw_fund_tp c_igf_aw_fund_tp%ROWTYPE;
544:
545: CURSOR c_igf_sp_fc(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
546: SELECT *
547: FROM igf_sp_fc_v
548: WHERE fund_id = cp_fund_id
549: ORDER BY fee_cls_id;

Line 570: -- cursor variable for c_igf_aw_fund_mast

566:
567: l_c_igf_sp_unit c_igf_sp_unit%ROWTYPE;
568: -- cursor variable for c_igf_aw_cal_rel
569: l_c_igf_aw_cal_rel c_igf_aw_cal_rel%ROWTYPE;
570: -- cursor variable for c_igf_aw_fund_mast
571: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
572: BEGIN
573:
574: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);

Line 571: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;

567: l_c_igf_sp_unit c_igf_sp_unit%ROWTYPE;
568: -- cursor variable for c_igf_aw_cal_rel
569: l_c_igf_aw_cal_rel c_igf_aw_cal_rel%ROWTYPE;
570: -- cursor variable for c_igf_aw_fund_mast
571: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
572: BEGIN
573:
574: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
575: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;

Line 574: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);

570: -- cursor variable for c_igf_aw_fund_mast
571: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
572: BEGIN
573:
574: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
575: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
576: CLOSE c_igf_aw_fund_mast;
577:
578: -- log the relavant details

Line 575: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;

571: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
572: BEGIN
573:
574: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
575: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
576: CLOSE c_igf_aw_fund_mast;
577:
578: -- log the relavant details
579: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','FUND_CODE'),32) ||

Line 576: CLOSE c_igf_aw_fund_mast;

572: BEGIN
573:
574: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
575: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
576: CLOSE c_igf_aw_fund_mast;
577:
578: -- log the relavant details
579: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','FUND_CODE'),32) ||
580: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_YEAR'),19) ||

Line 587: l_msg_str_1 := RPAD(l_c_igf_aw_fund_mast.fund_code,32)||

583: lookup_desc('IGF_AW_LOOKUPS_MSG','TOT_SPNSR_AMT');
584:
585: fnd_file.put_line(fnd_file.log,l_msg_str_0);
586: fnd_file.put_line(fnd_file.log,' ');
587: l_msg_str_1 := RPAD(l_c_igf_aw_fund_mast.fund_code,32)||
588: RPAD((p_sc_cal_type||' '||p_sc_seq_num),19) ||
589: NVL(RPAD(TO_CHAR(l_c_igf_aw_fund_mast.min_credit_points),19),' ') ||
590: NVL(RPAD(l_c_igf_aw_fund_mast.enrollment_status,32),' ' )||
591: TO_CHAR(l_c_igf_aw_fund_mast.max_yearly_amt);

Line 589: NVL(RPAD(TO_CHAR(l_c_igf_aw_fund_mast.min_credit_points),19),' ') ||

585: fnd_file.put_line(fnd_file.log,l_msg_str_0);
586: fnd_file.put_line(fnd_file.log,' ');
587: l_msg_str_1 := RPAD(l_c_igf_aw_fund_mast.fund_code,32)||
588: RPAD((p_sc_cal_type||' '||p_sc_seq_num),19) ||
589: NVL(RPAD(TO_CHAR(l_c_igf_aw_fund_mast.min_credit_points),19),' ') ||
590: NVL(RPAD(l_c_igf_aw_fund_mast.enrollment_status,32),' ' )||
591: TO_CHAR(l_c_igf_aw_fund_mast.max_yearly_amt);
592:
593: fnd_file.put_line(fnd_file.log,l_msg_str_1);

Line 590: NVL(RPAD(l_c_igf_aw_fund_mast.enrollment_status,32),' ' )||

586: fnd_file.put_line(fnd_file.log,' ');
587: l_msg_str_1 := RPAD(l_c_igf_aw_fund_mast.fund_code,32)||
588: RPAD((p_sc_cal_type||' '||p_sc_seq_num),19) ||
589: NVL(RPAD(TO_CHAR(l_c_igf_aw_fund_mast.min_credit_points),19),' ') ||
590: NVL(RPAD(l_c_igf_aw_fund_mast.enrollment_status,32),' ' )||
591: TO_CHAR(l_c_igf_aw_fund_mast.max_yearly_amt);
592:
593: fnd_file.put_line(fnd_file.log,l_msg_str_1);
594: fnd_file.put_line(fnd_file.log,' ');

Line 591: TO_CHAR(l_c_igf_aw_fund_mast.max_yearly_amt);

587: l_msg_str_1 := RPAD(l_c_igf_aw_fund_mast.fund_code,32)||
588: RPAD((p_sc_cal_type||' '||p_sc_seq_num),19) ||
589: NVL(RPAD(TO_CHAR(l_c_igf_aw_fund_mast.min_credit_points),19),' ') ||
590: NVL(RPAD(l_c_igf_aw_fund_mast.enrollment_status,32),' ' )||
591: TO_CHAR(l_c_igf_aw_fund_mast.max_yearly_amt);
592:
593: fnd_file.put_line(fnd_file.log,l_msg_str_1);
594: fnd_file.put_line(fnd_file.log,' ');
595:

Line 604: igf_aw_fund_mast_pkg.insert_row (

600: l_fund_id := NULL;
601: BEGIN
602: -- rollover the fund to new award year
603: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
604: igf_aw_fund_mast_pkg.insert_row (
605: x_mode => 'R',
606: x_rowid => l_rowid,
607: x_fund_id => l_fund_id,
608: x_fund_code => l_c_igf_aw_fund_mast.fund_code,

Line 608: x_fund_code => l_c_igf_aw_fund_mast.fund_code,

604: igf_aw_fund_mast_pkg.insert_row (
605: x_mode => 'R',
606: x_rowid => l_rowid,
607: x_fund_id => l_fund_id,
608: x_fund_code => l_c_igf_aw_fund_mast.fund_code,
609: x_ci_cal_type => p_sc_cal_type,
610: x_ci_sequence_number => p_sc_seq_num,
611: x_description => l_c_igf_aw_fund_mast.description,
612: x_discontinue_fund => l_c_igf_aw_fund_mast.discontinue_fund,

Line 611: x_description => l_c_igf_aw_fund_mast.description,

607: x_fund_id => l_fund_id,
608: x_fund_code => l_c_igf_aw_fund_mast.fund_code,
609: x_ci_cal_type => p_sc_cal_type,
610: x_ci_sequence_number => p_sc_seq_num,
611: x_description => l_c_igf_aw_fund_mast.description,
612: x_discontinue_fund => l_c_igf_aw_fund_mast.discontinue_fund,
613: x_entitlement => l_c_igf_aw_fund_mast.entitlement,
614: x_auto_pkg => l_c_igf_aw_fund_mast.auto_pkg,
615: x_self_help => l_c_igf_aw_fund_mast.self_help,

Line 612: x_discontinue_fund => l_c_igf_aw_fund_mast.discontinue_fund,

608: x_fund_code => l_c_igf_aw_fund_mast.fund_code,
609: x_ci_cal_type => p_sc_cal_type,
610: x_ci_sequence_number => p_sc_seq_num,
611: x_description => l_c_igf_aw_fund_mast.description,
612: x_discontinue_fund => l_c_igf_aw_fund_mast.discontinue_fund,
613: x_entitlement => l_c_igf_aw_fund_mast.entitlement,
614: x_auto_pkg => l_c_igf_aw_fund_mast.auto_pkg,
615: x_self_help => l_c_igf_aw_fund_mast.self_help,
616: x_allow_man_pkg => l_c_igf_aw_fund_mast.allow_man_pkg,

Line 613: x_entitlement => l_c_igf_aw_fund_mast.entitlement,

609: x_ci_cal_type => p_sc_cal_type,
610: x_ci_sequence_number => p_sc_seq_num,
611: x_description => l_c_igf_aw_fund_mast.description,
612: x_discontinue_fund => l_c_igf_aw_fund_mast.discontinue_fund,
613: x_entitlement => l_c_igf_aw_fund_mast.entitlement,
614: x_auto_pkg => l_c_igf_aw_fund_mast.auto_pkg,
615: x_self_help => l_c_igf_aw_fund_mast.self_help,
616: x_allow_man_pkg => l_c_igf_aw_fund_mast.allow_man_pkg,
617: x_update_need => l_c_igf_aw_fund_mast.update_need,

Line 614: x_auto_pkg => l_c_igf_aw_fund_mast.auto_pkg,

610: x_ci_sequence_number => p_sc_seq_num,
611: x_description => l_c_igf_aw_fund_mast.description,
612: x_discontinue_fund => l_c_igf_aw_fund_mast.discontinue_fund,
613: x_entitlement => l_c_igf_aw_fund_mast.entitlement,
614: x_auto_pkg => l_c_igf_aw_fund_mast.auto_pkg,
615: x_self_help => l_c_igf_aw_fund_mast.self_help,
616: x_allow_man_pkg => l_c_igf_aw_fund_mast.allow_man_pkg,
617: x_update_need => l_c_igf_aw_fund_mast.update_need,
618: x_disburse_fund => l_c_igf_aw_fund_mast.disburse_fund,

Line 615: x_self_help => l_c_igf_aw_fund_mast.self_help,

611: x_description => l_c_igf_aw_fund_mast.description,
612: x_discontinue_fund => l_c_igf_aw_fund_mast.discontinue_fund,
613: x_entitlement => l_c_igf_aw_fund_mast.entitlement,
614: x_auto_pkg => l_c_igf_aw_fund_mast.auto_pkg,
615: x_self_help => l_c_igf_aw_fund_mast.self_help,
616: x_allow_man_pkg => l_c_igf_aw_fund_mast.allow_man_pkg,
617: x_update_need => l_c_igf_aw_fund_mast.update_need,
618: x_disburse_fund => l_c_igf_aw_fund_mast.disburse_fund,
619: x_available_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.available_amt),

Line 616: x_allow_man_pkg => l_c_igf_aw_fund_mast.allow_man_pkg,

612: x_discontinue_fund => l_c_igf_aw_fund_mast.discontinue_fund,
613: x_entitlement => l_c_igf_aw_fund_mast.entitlement,
614: x_auto_pkg => l_c_igf_aw_fund_mast.auto_pkg,
615: x_self_help => l_c_igf_aw_fund_mast.self_help,
616: x_allow_man_pkg => l_c_igf_aw_fund_mast.allow_man_pkg,
617: x_update_need => l_c_igf_aw_fund_mast.update_need,
618: x_disburse_fund => l_c_igf_aw_fund_mast.disburse_fund,
619: x_available_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.available_amt),
620: x_offered_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.offered_amt),

Line 617: x_update_need => l_c_igf_aw_fund_mast.update_need,

613: x_entitlement => l_c_igf_aw_fund_mast.entitlement,
614: x_auto_pkg => l_c_igf_aw_fund_mast.auto_pkg,
615: x_self_help => l_c_igf_aw_fund_mast.self_help,
616: x_allow_man_pkg => l_c_igf_aw_fund_mast.allow_man_pkg,
617: x_update_need => l_c_igf_aw_fund_mast.update_need,
618: x_disburse_fund => l_c_igf_aw_fund_mast.disburse_fund,
619: x_available_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.available_amt),
620: x_offered_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.offered_amt),
621: x_pending_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.pending_amt),

Line 618: x_disburse_fund => l_c_igf_aw_fund_mast.disburse_fund,

614: x_auto_pkg => l_c_igf_aw_fund_mast.auto_pkg,
615: x_self_help => l_c_igf_aw_fund_mast.self_help,
616: x_allow_man_pkg => l_c_igf_aw_fund_mast.allow_man_pkg,
617: x_update_need => l_c_igf_aw_fund_mast.update_need,
618: x_disburse_fund => l_c_igf_aw_fund_mast.disburse_fund,
619: x_available_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.available_amt),
620: x_offered_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.offered_amt),
621: x_pending_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.pending_amt),
622: x_accepted_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.accepted_amt),

Line 619: x_available_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.available_amt),

615: x_self_help => l_c_igf_aw_fund_mast.self_help,
616: x_allow_man_pkg => l_c_igf_aw_fund_mast.allow_man_pkg,
617: x_update_need => l_c_igf_aw_fund_mast.update_need,
618: x_disburse_fund => l_c_igf_aw_fund_mast.disburse_fund,
619: x_available_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.available_amt),
620: x_offered_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.offered_amt),
621: x_pending_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.pending_amt),
622: x_accepted_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.accepted_amt),
623: x_declined_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.declined_amt),

Line 620: x_offered_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.offered_amt),

616: x_allow_man_pkg => l_c_igf_aw_fund_mast.allow_man_pkg,
617: x_update_need => l_c_igf_aw_fund_mast.update_need,
618: x_disburse_fund => l_c_igf_aw_fund_mast.disburse_fund,
619: x_available_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.available_amt),
620: x_offered_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.offered_amt),
621: x_pending_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.pending_amt),
622: x_accepted_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.accepted_amt),
623: x_declined_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.declined_amt),
624: x_cancelled_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.cancelled_amt),

Line 621: x_pending_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.pending_amt),

617: x_update_need => l_c_igf_aw_fund_mast.update_need,
618: x_disburse_fund => l_c_igf_aw_fund_mast.disburse_fund,
619: x_available_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.available_amt),
620: x_offered_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.offered_amt),
621: x_pending_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.pending_amt),
622: x_accepted_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.accepted_amt),
623: x_declined_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.declined_amt),
624: x_cancelled_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.cancelled_amt),
625: x_remaining_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.remaining_amt),

Line 622: x_accepted_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.accepted_amt),

618: x_disburse_fund => l_c_igf_aw_fund_mast.disburse_fund,
619: x_available_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.available_amt),
620: x_offered_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.offered_amt),
621: x_pending_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.pending_amt),
622: x_accepted_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.accepted_amt),
623: x_declined_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.declined_amt),
624: x_cancelled_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.cancelled_amt),
625: x_remaining_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.remaining_amt),
626: x_enrollment_status => l_c_igf_aw_fund_mast.enrollment_status,

Line 623: x_declined_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.declined_amt),

619: x_available_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.available_amt),
620: x_offered_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.offered_amt),
621: x_pending_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.pending_amt),
622: x_accepted_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.accepted_amt),
623: x_declined_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.declined_amt),
624: x_cancelled_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.cancelled_amt),
625: x_remaining_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.remaining_amt),
626: x_enrollment_status => l_c_igf_aw_fund_mast.enrollment_status,
627: x_prn_award_letter => l_c_igf_aw_fund_mast.prn_award_letter,

Line 624: x_cancelled_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.cancelled_amt),

620: x_offered_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.offered_amt),
621: x_pending_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.pending_amt),
622: x_accepted_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.accepted_amt),
623: x_declined_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.declined_amt),
624: x_cancelled_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.cancelled_amt),
625: x_remaining_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.remaining_amt),
626: x_enrollment_status => l_c_igf_aw_fund_mast.enrollment_status,
627: x_prn_award_letter => l_c_igf_aw_fund_mast.prn_award_letter,
628: x_over_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.over_award_amt),

Line 625: x_remaining_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.remaining_amt),

621: x_pending_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.pending_amt),
622: x_accepted_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.accepted_amt),
623: x_declined_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.declined_amt),
624: x_cancelled_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.cancelled_amt),
625: x_remaining_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.remaining_amt),
626: x_enrollment_status => l_c_igf_aw_fund_mast.enrollment_status,
627: x_prn_award_letter => l_c_igf_aw_fund_mast.prn_award_letter,
628: x_over_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.over_award_amt),
629: x_over_award_perct => l_c_igf_aw_fund_mast.over_award_perct,

Line 626: x_enrollment_status => l_c_igf_aw_fund_mast.enrollment_status,

622: x_accepted_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.accepted_amt),
623: x_declined_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.declined_amt),
624: x_cancelled_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.cancelled_amt),
625: x_remaining_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.remaining_amt),
626: x_enrollment_status => l_c_igf_aw_fund_mast.enrollment_status,
627: x_prn_award_letter => l_c_igf_aw_fund_mast.prn_award_letter,
628: x_over_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.over_award_amt),
629: x_over_award_perct => l_c_igf_aw_fund_mast.over_award_perct,
630: x_min_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_award_amt),

Line 627: x_prn_award_letter => l_c_igf_aw_fund_mast.prn_award_letter,

623: x_declined_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.declined_amt),
624: x_cancelled_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.cancelled_amt),
625: x_remaining_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.remaining_amt),
626: x_enrollment_status => l_c_igf_aw_fund_mast.enrollment_status,
627: x_prn_award_letter => l_c_igf_aw_fund_mast.prn_award_letter,
628: x_over_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.over_award_amt),
629: x_over_award_perct => l_c_igf_aw_fund_mast.over_award_perct,
630: x_min_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_award_amt),
631: x_max_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_award_amt),

Line 628: x_over_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.over_award_amt),

624: x_cancelled_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.cancelled_amt),
625: x_remaining_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.remaining_amt),
626: x_enrollment_status => l_c_igf_aw_fund_mast.enrollment_status,
627: x_prn_award_letter => l_c_igf_aw_fund_mast.prn_award_letter,
628: x_over_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.over_award_amt),
629: x_over_award_perct => l_c_igf_aw_fund_mast.over_award_perct,
630: x_min_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_award_amt),
631: x_max_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_award_amt),
632: x_max_yearly_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_yearly_amt),

Line 629: x_over_award_perct => l_c_igf_aw_fund_mast.over_award_perct,

625: x_remaining_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.remaining_amt),
626: x_enrollment_status => l_c_igf_aw_fund_mast.enrollment_status,
627: x_prn_award_letter => l_c_igf_aw_fund_mast.prn_award_letter,
628: x_over_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.over_award_amt),
629: x_over_award_perct => l_c_igf_aw_fund_mast.over_award_perct,
630: x_min_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_award_amt),
631: x_max_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_award_amt),
632: x_max_yearly_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_yearly_amt),
633: x_max_life_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_life_amt),

Line 630: x_min_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_award_amt),

626: x_enrollment_status => l_c_igf_aw_fund_mast.enrollment_status,
627: x_prn_award_letter => l_c_igf_aw_fund_mast.prn_award_letter,
628: x_over_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.over_award_amt),
629: x_over_award_perct => l_c_igf_aw_fund_mast.over_award_perct,
630: x_min_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_award_amt),
631: x_max_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_award_amt),
632: x_max_yearly_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_yearly_amt),
633: x_max_life_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_life_amt),
634: x_max_life_term => l_c_igf_aw_fund_mast.max_life_term,

Line 631: x_max_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_award_amt),

627: x_prn_award_letter => l_c_igf_aw_fund_mast.prn_award_letter,
628: x_over_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.over_award_amt),
629: x_over_award_perct => l_c_igf_aw_fund_mast.over_award_perct,
630: x_min_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_award_amt),
631: x_max_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_award_amt),
632: x_max_yearly_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_yearly_amt),
633: x_max_life_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_life_amt),
634: x_max_life_term => l_c_igf_aw_fund_mast.max_life_term,
635: x_fm_fc_methd => l_c_igf_aw_fund_mast.fm_fc_methd,

Line 632: x_max_yearly_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_yearly_amt),

628: x_over_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.over_award_amt),
629: x_over_award_perct => l_c_igf_aw_fund_mast.over_award_perct,
630: x_min_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_award_amt),
631: x_max_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_award_amt),
632: x_max_yearly_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_yearly_amt),
633: x_max_life_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_life_amt),
634: x_max_life_term => l_c_igf_aw_fund_mast.max_life_term,
635: x_fm_fc_methd => l_c_igf_aw_fund_mast.fm_fc_methd,
636: x_roundoff_fact => l_c_igf_aw_fund_mast.roundoff_fact,

Line 633: x_max_life_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_life_amt),

629: x_over_award_perct => l_c_igf_aw_fund_mast.over_award_perct,
630: x_min_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_award_amt),
631: x_max_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_award_amt),
632: x_max_yearly_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_yearly_amt),
633: x_max_life_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_life_amt),
634: x_max_life_term => l_c_igf_aw_fund_mast.max_life_term,
635: x_fm_fc_methd => l_c_igf_aw_fund_mast.fm_fc_methd,
636: x_roundoff_fact => l_c_igf_aw_fund_mast.roundoff_fact,
637: x_replace_fc => l_c_igf_aw_fund_mast.replace_fc,

Line 634: x_max_life_term => l_c_igf_aw_fund_mast.max_life_term,

630: x_min_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_award_amt),
631: x_max_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_award_amt),
632: x_max_yearly_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_yearly_amt),
633: x_max_life_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_life_amt),
634: x_max_life_term => l_c_igf_aw_fund_mast.max_life_term,
635: x_fm_fc_methd => l_c_igf_aw_fund_mast.fm_fc_methd,
636: x_roundoff_fact => l_c_igf_aw_fund_mast.roundoff_fact,
637: x_replace_fc => l_c_igf_aw_fund_mast.replace_fc,
638: x_allow_overaward => l_c_igf_aw_fund_mast.allow_overaward,

Line 635: x_fm_fc_methd => l_c_igf_aw_fund_mast.fm_fc_methd,

631: x_max_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_award_amt),
632: x_max_yearly_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_yearly_amt),
633: x_max_life_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_life_amt),
634: x_max_life_term => l_c_igf_aw_fund_mast.max_life_term,
635: x_fm_fc_methd => l_c_igf_aw_fund_mast.fm_fc_methd,
636: x_roundoff_fact => l_c_igf_aw_fund_mast.roundoff_fact,
637: x_replace_fc => l_c_igf_aw_fund_mast.replace_fc,
638: x_allow_overaward => l_c_igf_aw_fund_mast.allow_overaward,
639: x_pckg_awd_stat => l_c_igf_aw_fund_mast.pckg_awd_stat,

Line 636: x_roundoff_fact => l_c_igf_aw_fund_mast.roundoff_fact,

632: x_max_yearly_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_yearly_amt),
633: x_max_life_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_life_amt),
634: x_max_life_term => l_c_igf_aw_fund_mast.max_life_term,
635: x_fm_fc_methd => l_c_igf_aw_fund_mast.fm_fc_methd,
636: x_roundoff_fact => l_c_igf_aw_fund_mast.roundoff_fact,
637: x_replace_fc => l_c_igf_aw_fund_mast.replace_fc,
638: x_allow_overaward => l_c_igf_aw_fund_mast.allow_overaward,
639: x_pckg_awd_stat => l_c_igf_aw_fund_mast.pckg_awd_stat,
640: x_org_record_req => l_c_igf_aw_fund_mast.org_record_req,

Line 637: x_replace_fc => l_c_igf_aw_fund_mast.replace_fc,

633: x_max_life_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_life_amt),
634: x_max_life_term => l_c_igf_aw_fund_mast.max_life_term,
635: x_fm_fc_methd => l_c_igf_aw_fund_mast.fm_fc_methd,
636: x_roundoff_fact => l_c_igf_aw_fund_mast.roundoff_fact,
637: x_replace_fc => l_c_igf_aw_fund_mast.replace_fc,
638: x_allow_overaward => l_c_igf_aw_fund_mast.allow_overaward,
639: x_pckg_awd_stat => l_c_igf_aw_fund_mast.pckg_awd_stat,
640: x_org_record_req => l_c_igf_aw_fund_mast.org_record_req,
641: x_disb_record_req => l_c_igf_aw_fund_mast.disb_record_req,

Line 638: x_allow_overaward => l_c_igf_aw_fund_mast.allow_overaward,

634: x_max_life_term => l_c_igf_aw_fund_mast.max_life_term,
635: x_fm_fc_methd => l_c_igf_aw_fund_mast.fm_fc_methd,
636: x_roundoff_fact => l_c_igf_aw_fund_mast.roundoff_fact,
637: x_replace_fc => l_c_igf_aw_fund_mast.replace_fc,
638: x_allow_overaward => l_c_igf_aw_fund_mast.allow_overaward,
639: x_pckg_awd_stat => l_c_igf_aw_fund_mast.pckg_awd_stat,
640: x_org_record_req => l_c_igf_aw_fund_mast.org_record_req,
641: x_disb_record_req => l_c_igf_aw_fund_mast.disb_record_req,
642: x_prom_note_req => l_c_igf_aw_fund_mast.prom_note_req,

Line 639: x_pckg_awd_stat => l_c_igf_aw_fund_mast.pckg_awd_stat,

635: x_fm_fc_methd => l_c_igf_aw_fund_mast.fm_fc_methd,
636: x_roundoff_fact => l_c_igf_aw_fund_mast.roundoff_fact,
637: x_replace_fc => l_c_igf_aw_fund_mast.replace_fc,
638: x_allow_overaward => l_c_igf_aw_fund_mast.allow_overaward,
639: x_pckg_awd_stat => l_c_igf_aw_fund_mast.pckg_awd_stat,
640: x_org_record_req => l_c_igf_aw_fund_mast.org_record_req,
641: x_disb_record_req => l_c_igf_aw_fund_mast.disb_record_req,
642: x_prom_note_req => l_c_igf_aw_fund_mast.prom_note_req,
643: x_min_num_disb => l_c_igf_aw_fund_mast.min_num_disb,

Line 640: x_org_record_req => l_c_igf_aw_fund_mast.org_record_req,

636: x_roundoff_fact => l_c_igf_aw_fund_mast.roundoff_fact,
637: x_replace_fc => l_c_igf_aw_fund_mast.replace_fc,
638: x_allow_overaward => l_c_igf_aw_fund_mast.allow_overaward,
639: x_pckg_awd_stat => l_c_igf_aw_fund_mast.pckg_awd_stat,
640: x_org_record_req => l_c_igf_aw_fund_mast.org_record_req,
641: x_disb_record_req => l_c_igf_aw_fund_mast.disb_record_req,
642: x_prom_note_req => l_c_igf_aw_fund_mast.prom_note_req,
643: x_min_num_disb => l_c_igf_aw_fund_mast.min_num_disb,
644: x_max_num_disb => l_c_igf_aw_fund_mast.max_num_disb,

Line 641: x_disb_record_req => l_c_igf_aw_fund_mast.disb_record_req,

637: x_replace_fc => l_c_igf_aw_fund_mast.replace_fc,
638: x_allow_overaward => l_c_igf_aw_fund_mast.allow_overaward,
639: x_pckg_awd_stat => l_c_igf_aw_fund_mast.pckg_awd_stat,
640: x_org_record_req => l_c_igf_aw_fund_mast.org_record_req,
641: x_disb_record_req => l_c_igf_aw_fund_mast.disb_record_req,
642: x_prom_note_req => l_c_igf_aw_fund_mast.prom_note_req,
643: x_min_num_disb => l_c_igf_aw_fund_mast.min_num_disb,
644: x_max_num_disb => l_c_igf_aw_fund_mast.max_num_disb,
645: x_fee_type => l_c_igf_aw_fund_mast.fee_type,

Line 642: x_prom_note_req => l_c_igf_aw_fund_mast.prom_note_req,

638: x_allow_overaward => l_c_igf_aw_fund_mast.allow_overaward,
639: x_pckg_awd_stat => l_c_igf_aw_fund_mast.pckg_awd_stat,
640: x_org_record_req => l_c_igf_aw_fund_mast.org_record_req,
641: x_disb_record_req => l_c_igf_aw_fund_mast.disb_record_req,
642: x_prom_note_req => l_c_igf_aw_fund_mast.prom_note_req,
643: x_min_num_disb => l_c_igf_aw_fund_mast.min_num_disb,
644: x_max_num_disb => l_c_igf_aw_fund_mast.max_num_disb,
645: x_fee_type => l_c_igf_aw_fund_mast.fee_type,
646: x_total_offered => l_c_igf_aw_fund_mast.total_offered,

Line 643: x_min_num_disb => l_c_igf_aw_fund_mast.min_num_disb,

639: x_pckg_awd_stat => l_c_igf_aw_fund_mast.pckg_awd_stat,
640: x_org_record_req => l_c_igf_aw_fund_mast.org_record_req,
641: x_disb_record_req => l_c_igf_aw_fund_mast.disb_record_req,
642: x_prom_note_req => l_c_igf_aw_fund_mast.prom_note_req,
643: x_min_num_disb => l_c_igf_aw_fund_mast.min_num_disb,
644: x_max_num_disb => l_c_igf_aw_fund_mast.max_num_disb,
645: x_fee_type => l_c_igf_aw_fund_mast.fee_type,
646: x_total_offered => l_c_igf_aw_fund_mast.total_offered,
647: x_total_accepted => l_c_igf_aw_fund_mast.total_accepted,

Line 644: x_max_num_disb => l_c_igf_aw_fund_mast.max_num_disb,

640: x_org_record_req => l_c_igf_aw_fund_mast.org_record_req,
641: x_disb_record_req => l_c_igf_aw_fund_mast.disb_record_req,
642: x_prom_note_req => l_c_igf_aw_fund_mast.prom_note_req,
643: x_min_num_disb => l_c_igf_aw_fund_mast.min_num_disb,
644: x_max_num_disb => l_c_igf_aw_fund_mast.max_num_disb,
645: x_fee_type => l_c_igf_aw_fund_mast.fee_type,
646: x_total_offered => l_c_igf_aw_fund_mast.total_offered,
647: x_total_accepted => l_c_igf_aw_fund_mast.total_accepted,
648: x_total_declined => l_c_igf_aw_fund_mast.total_declined,

Line 645: x_fee_type => l_c_igf_aw_fund_mast.fee_type,

641: x_disb_record_req => l_c_igf_aw_fund_mast.disb_record_req,
642: x_prom_note_req => l_c_igf_aw_fund_mast.prom_note_req,
643: x_min_num_disb => l_c_igf_aw_fund_mast.min_num_disb,
644: x_max_num_disb => l_c_igf_aw_fund_mast.max_num_disb,
645: x_fee_type => l_c_igf_aw_fund_mast.fee_type,
646: x_total_offered => l_c_igf_aw_fund_mast.total_offered,
647: x_total_accepted => l_c_igf_aw_fund_mast.total_accepted,
648: x_total_declined => l_c_igf_aw_fund_mast.total_declined,
649: x_total_revoked => l_c_igf_aw_fund_mast.total_revoked,

Line 646: x_total_offered => l_c_igf_aw_fund_mast.total_offered,

642: x_prom_note_req => l_c_igf_aw_fund_mast.prom_note_req,
643: x_min_num_disb => l_c_igf_aw_fund_mast.min_num_disb,
644: x_max_num_disb => l_c_igf_aw_fund_mast.max_num_disb,
645: x_fee_type => l_c_igf_aw_fund_mast.fee_type,
646: x_total_offered => l_c_igf_aw_fund_mast.total_offered,
647: x_total_accepted => l_c_igf_aw_fund_mast.total_accepted,
648: x_total_declined => l_c_igf_aw_fund_mast.total_declined,
649: x_total_revoked => l_c_igf_aw_fund_mast.total_revoked,
650: x_total_cancelled => l_c_igf_aw_fund_mast.total_cancelled,

Line 647: x_total_accepted => l_c_igf_aw_fund_mast.total_accepted,

643: x_min_num_disb => l_c_igf_aw_fund_mast.min_num_disb,
644: x_max_num_disb => l_c_igf_aw_fund_mast.max_num_disb,
645: x_fee_type => l_c_igf_aw_fund_mast.fee_type,
646: x_total_offered => l_c_igf_aw_fund_mast.total_offered,
647: x_total_accepted => l_c_igf_aw_fund_mast.total_accepted,
648: x_total_declined => l_c_igf_aw_fund_mast.total_declined,
649: x_total_revoked => l_c_igf_aw_fund_mast.total_revoked,
650: x_total_cancelled => l_c_igf_aw_fund_mast.total_cancelled,
651: x_total_disbursed => l_c_igf_aw_fund_mast.total_disbursed,

Line 648: x_total_declined => l_c_igf_aw_fund_mast.total_declined,

644: x_max_num_disb => l_c_igf_aw_fund_mast.max_num_disb,
645: x_fee_type => l_c_igf_aw_fund_mast.fee_type,
646: x_total_offered => l_c_igf_aw_fund_mast.total_offered,
647: x_total_accepted => l_c_igf_aw_fund_mast.total_accepted,
648: x_total_declined => l_c_igf_aw_fund_mast.total_declined,
649: x_total_revoked => l_c_igf_aw_fund_mast.total_revoked,
650: x_total_cancelled => l_c_igf_aw_fund_mast.total_cancelled,
651: x_total_disbursed => l_c_igf_aw_fund_mast.total_disbursed,
652: x_total_committed => l_c_igf_aw_fund_mast.total_committed,

Line 649: x_total_revoked => l_c_igf_aw_fund_mast.total_revoked,

645: x_fee_type => l_c_igf_aw_fund_mast.fee_type,
646: x_total_offered => l_c_igf_aw_fund_mast.total_offered,
647: x_total_accepted => l_c_igf_aw_fund_mast.total_accepted,
648: x_total_declined => l_c_igf_aw_fund_mast.total_declined,
649: x_total_revoked => l_c_igf_aw_fund_mast.total_revoked,
650: x_total_cancelled => l_c_igf_aw_fund_mast.total_cancelled,
651: x_total_disbursed => l_c_igf_aw_fund_mast.total_disbursed,
652: x_total_committed => l_c_igf_aw_fund_mast.total_committed,
653: x_committed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.committed_amt),

Line 650: x_total_cancelled => l_c_igf_aw_fund_mast.total_cancelled,

646: x_total_offered => l_c_igf_aw_fund_mast.total_offered,
647: x_total_accepted => l_c_igf_aw_fund_mast.total_accepted,
648: x_total_declined => l_c_igf_aw_fund_mast.total_declined,
649: x_total_revoked => l_c_igf_aw_fund_mast.total_revoked,
650: x_total_cancelled => l_c_igf_aw_fund_mast.total_cancelled,
651: x_total_disbursed => l_c_igf_aw_fund_mast.total_disbursed,
652: x_total_committed => l_c_igf_aw_fund_mast.total_committed,
653: x_committed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.committed_amt),
654: x_disbursed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.disbursed_amt),

Line 651: x_total_disbursed => l_c_igf_aw_fund_mast.total_disbursed,

647: x_total_accepted => l_c_igf_aw_fund_mast.total_accepted,
648: x_total_declined => l_c_igf_aw_fund_mast.total_declined,
649: x_total_revoked => l_c_igf_aw_fund_mast.total_revoked,
650: x_total_cancelled => l_c_igf_aw_fund_mast.total_cancelled,
651: x_total_disbursed => l_c_igf_aw_fund_mast.total_disbursed,
652: x_total_committed => l_c_igf_aw_fund_mast.total_committed,
653: x_committed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.committed_amt),
654: x_disbursed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.disbursed_amt),
655: x_awd_notice_txt => l_c_igf_aw_fund_mast.awd_notice_txt,

Line 652: x_total_committed => l_c_igf_aw_fund_mast.total_committed,

648: x_total_declined => l_c_igf_aw_fund_mast.total_declined,
649: x_total_revoked => l_c_igf_aw_fund_mast.total_revoked,
650: x_total_cancelled => l_c_igf_aw_fund_mast.total_cancelled,
651: x_total_disbursed => l_c_igf_aw_fund_mast.total_disbursed,
652: x_total_committed => l_c_igf_aw_fund_mast.total_committed,
653: x_committed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.committed_amt),
654: x_disbursed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.disbursed_amt),
655: x_awd_notice_txt => l_c_igf_aw_fund_mast.awd_notice_txt,
656: x_attribute_category => l_c_igf_aw_fund_mast.attribute_category,

Line 653: x_committed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.committed_amt),

649: x_total_revoked => l_c_igf_aw_fund_mast.total_revoked,
650: x_total_cancelled => l_c_igf_aw_fund_mast.total_cancelled,
651: x_total_disbursed => l_c_igf_aw_fund_mast.total_disbursed,
652: x_total_committed => l_c_igf_aw_fund_mast.total_committed,
653: x_committed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.committed_amt),
654: x_disbursed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.disbursed_amt),
655: x_awd_notice_txt => l_c_igf_aw_fund_mast.awd_notice_txt,
656: x_attribute_category => l_c_igf_aw_fund_mast.attribute_category,
657: x_attribute1 => l_c_igf_aw_fund_mast.attribute1,

Line 654: x_disbursed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.disbursed_amt),

650: x_total_cancelled => l_c_igf_aw_fund_mast.total_cancelled,
651: x_total_disbursed => l_c_igf_aw_fund_mast.total_disbursed,
652: x_total_committed => l_c_igf_aw_fund_mast.total_committed,
653: x_committed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.committed_amt),
654: x_disbursed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.disbursed_amt),
655: x_awd_notice_txt => l_c_igf_aw_fund_mast.awd_notice_txt,
656: x_attribute_category => l_c_igf_aw_fund_mast.attribute_category,
657: x_attribute1 => l_c_igf_aw_fund_mast.attribute1,
658: x_attribute2 => l_c_igf_aw_fund_mast.attribute2,

Line 655: x_awd_notice_txt => l_c_igf_aw_fund_mast.awd_notice_txt,

651: x_total_disbursed => l_c_igf_aw_fund_mast.total_disbursed,
652: x_total_committed => l_c_igf_aw_fund_mast.total_committed,
653: x_committed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.committed_amt),
654: x_disbursed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.disbursed_amt),
655: x_awd_notice_txt => l_c_igf_aw_fund_mast.awd_notice_txt,
656: x_attribute_category => l_c_igf_aw_fund_mast.attribute_category,
657: x_attribute1 => l_c_igf_aw_fund_mast.attribute1,
658: x_attribute2 => l_c_igf_aw_fund_mast.attribute2,
659: x_attribute3 => l_c_igf_aw_fund_mast.attribute3,

Line 656: x_attribute_category => l_c_igf_aw_fund_mast.attribute_category,

652: x_total_committed => l_c_igf_aw_fund_mast.total_committed,
653: x_committed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.committed_amt),
654: x_disbursed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.disbursed_amt),
655: x_awd_notice_txt => l_c_igf_aw_fund_mast.awd_notice_txt,
656: x_attribute_category => l_c_igf_aw_fund_mast.attribute_category,
657: x_attribute1 => l_c_igf_aw_fund_mast.attribute1,
658: x_attribute2 => l_c_igf_aw_fund_mast.attribute2,
659: x_attribute3 => l_c_igf_aw_fund_mast.attribute3,
660: x_attribute4 => l_c_igf_aw_fund_mast.attribute4,

Line 657: x_attribute1 => l_c_igf_aw_fund_mast.attribute1,

653: x_committed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.committed_amt),
654: x_disbursed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.disbursed_amt),
655: x_awd_notice_txt => l_c_igf_aw_fund_mast.awd_notice_txt,
656: x_attribute_category => l_c_igf_aw_fund_mast.attribute_category,
657: x_attribute1 => l_c_igf_aw_fund_mast.attribute1,
658: x_attribute2 => l_c_igf_aw_fund_mast.attribute2,
659: x_attribute3 => l_c_igf_aw_fund_mast.attribute3,
660: x_attribute4 => l_c_igf_aw_fund_mast.attribute4,
661: x_attribute5 => l_c_igf_aw_fund_mast.attribute5,

Line 658: x_attribute2 => l_c_igf_aw_fund_mast.attribute2,

654: x_disbursed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.disbursed_amt),
655: x_awd_notice_txt => l_c_igf_aw_fund_mast.awd_notice_txt,
656: x_attribute_category => l_c_igf_aw_fund_mast.attribute_category,
657: x_attribute1 => l_c_igf_aw_fund_mast.attribute1,
658: x_attribute2 => l_c_igf_aw_fund_mast.attribute2,
659: x_attribute3 => l_c_igf_aw_fund_mast.attribute3,
660: x_attribute4 => l_c_igf_aw_fund_mast.attribute4,
661: x_attribute5 => l_c_igf_aw_fund_mast.attribute5,
662: x_attribute6 => l_c_igf_aw_fund_mast.attribute6,

Line 659: x_attribute3 => l_c_igf_aw_fund_mast.attribute3,

655: x_awd_notice_txt => l_c_igf_aw_fund_mast.awd_notice_txt,
656: x_attribute_category => l_c_igf_aw_fund_mast.attribute_category,
657: x_attribute1 => l_c_igf_aw_fund_mast.attribute1,
658: x_attribute2 => l_c_igf_aw_fund_mast.attribute2,
659: x_attribute3 => l_c_igf_aw_fund_mast.attribute3,
660: x_attribute4 => l_c_igf_aw_fund_mast.attribute4,
661: x_attribute5 => l_c_igf_aw_fund_mast.attribute5,
662: x_attribute6 => l_c_igf_aw_fund_mast.attribute6,
663: x_attribute7 => l_c_igf_aw_fund_mast.attribute7,

Line 660: x_attribute4 => l_c_igf_aw_fund_mast.attribute4,

656: x_attribute_category => l_c_igf_aw_fund_mast.attribute_category,
657: x_attribute1 => l_c_igf_aw_fund_mast.attribute1,
658: x_attribute2 => l_c_igf_aw_fund_mast.attribute2,
659: x_attribute3 => l_c_igf_aw_fund_mast.attribute3,
660: x_attribute4 => l_c_igf_aw_fund_mast.attribute4,
661: x_attribute5 => l_c_igf_aw_fund_mast.attribute5,
662: x_attribute6 => l_c_igf_aw_fund_mast.attribute6,
663: x_attribute7 => l_c_igf_aw_fund_mast.attribute7,
664: x_attribute8 => l_c_igf_aw_fund_mast.attribute8,

Line 661: x_attribute5 => l_c_igf_aw_fund_mast.attribute5,

657: x_attribute1 => l_c_igf_aw_fund_mast.attribute1,
658: x_attribute2 => l_c_igf_aw_fund_mast.attribute2,
659: x_attribute3 => l_c_igf_aw_fund_mast.attribute3,
660: x_attribute4 => l_c_igf_aw_fund_mast.attribute4,
661: x_attribute5 => l_c_igf_aw_fund_mast.attribute5,
662: x_attribute6 => l_c_igf_aw_fund_mast.attribute6,
663: x_attribute7 => l_c_igf_aw_fund_mast.attribute7,
664: x_attribute8 => l_c_igf_aw_fund_mast.attribute8,
665: x_attribute9 => l_c_igf_aw_fund_mast.attribute9,

Line 662: x_attribute6 => l_c_igf_aw_fund_mast.attribute6,

658: x_attribute2 => l_c_igf_aw_fund_mast.attribute2,
659: x_attribute3 => l_c_igf_aw_fund_mast.attribute3,
660: x_attribute4 => l_c_igf_aw_fund_mast.attribute4,
661: x_attribute5 => l_c_igf_aw_fund_mast.attribute5,
662: x_attribute6 => l_c_igf_aw_fund_mast.attribute6,
663: x_attribute7 => l_c_igf_aw_fund_mast.attribute7,
664: x_attribute8 => l_c_igf_aw_fund_mast.attribute8,
665: x_attribute9 => l_c_igf_aw_fund_mast.attribute9,
666: x_attribute10 => l_c_igf_aw_fund_mast.attribute10,

Line 663: x_attribute7 => l_c_igf_aw_fund_mast.attribute7,

659: x_attribute3 => l_c_igf_aw_fund_mast.attribute3,
660: x_attribute4 => l_c_igf_aw_fund_mast.attribute4,
661: x_attribute5 => l_c_igf_aw_fund_mast.attribute5,
662: x_attribute6 => l_c_igf_aw_fund_mast.attribute6,
663: x_attribute7 => l_c_igf_aw_fund_mast.attribute7,
664: x_attribute8 => l_c_igf_aw_fund_mast.attribute8,
665: x_attribute9 => l_c_igf_aw_fund_mast.attribute9,
666: x_attribute10 => l_c_igf_aw_fund_mast.attribute10,
667: x_attribute11 => l_c_igf_aw_fund_mast.attribute11,

Line 664: x_attribute8 => l_c_igf_aw_fund_mast.attribute8,

660: x_attribute4 => l_c_igf_aw_fund_mast.attribute4,
661: x_attribute5 => l_c_igf_aw_fund_mast.attribute5,
662: x_attribute6 => l_c_igf_aw_fund_mast.attribute6,
663: x_attribute7 => l_c_igf_aw_fund_mast.attribute7,
664: x_attribute8 => l_c_igf_aw_fund_mast.attribute8,
665: x_attribute9 => l_c_igf_aw_fund_mast.attribute9,
666: x_attribute10 => l_c_igf_aw_fund_mast.attribute10,
667: x_attribute11 => l_c_igf_aw_fund_mast.attribute11,
668: x_attribute12 => l_c_igf_aw_fund_mast.attribute12,

Line 665: x_attribute9 => l_c_igf_aw_fund_mast.attribute9,

661: x_attribute5 => l_c_igf_aw_fund_mast.attribute5,
662: x_attribute6 => l_c_igf_aw_fund_mast.attribute6,
663: x_attribute7 => l_c_igf_aw_fund_mast.attribute7,
664: x_attribute8 => l_c_igf_aw_fund_mast.attribute8,
665: x_attribute9 => l_c_igf_aw_fund_mast.attribute9,
666: x_attribute10 => l_c_igf_aw_fund_mast.attribute10,
667: x_attribute11 => l_c_igf_aw_fund_mast.attribute11,
668: x_attribute12 => l_c_igf_aw_fund_mast.attribute12,
669: x_attribute13 => l_c_igf_aw_fund_mast.attribute13,

Line 666: x_attribute10 => l_c_igf_aw_fund_mast.attribute10,

662: x_attribute6 => l_c_igf_aw_fund_mast.attribute6,
663: x_attribute7 => l_c_igf_aw_fund_mast.attribute7,
664: x_attribute8 => l_c_igf_aw_fund_mast.attribute8,
665: x_attribute9 => l_c_igf_aw_fund_mast.attribute9,
666: x_attribute10 => l_c_igf_aw_fund_mast.attribute10,
667: x_attribute11 => l_c_igf_aw_fund_mast.attribute11,
668: x_attribute12 => l_c_igf_aw_fund_mast.attribute12,
669: x_attribute13 => l_c_igf_aw_fund_mast.attribute13,
670: x_attribute14 => l_c_igf_aw_fund_mast.attribute14,

Line 667: x_attribute11 => l_c_igf_aw_fund_mast.attribute11,

663: x_attribute7 => l_c_igf_aw_fund_mast.attribute7,
664: x_attribute8 => l_c_igf_aw_fund_mast.attribute8,
665: x_attribute9 => l_c_igf_aw_fund_mast.attribute9,
666: x_attribute10 => l_c_igf_aw_fund_mast.attribute10,
667: x_attribute11 => l_c_igf_aw_fund_mast.attribute11,
668: x_attribute12 => l_c_igf_aw_fund_mast.attribute12,
669: x_attribute13 => l_c_igf_aw_fund_mast.attribute13,
670: x_attribute14 => l_c_igf_aw_fund_mast.attribute14,
671: x_attribute15 => l_c_igf_aw_fund_mast.attribute15,

Line 668: x_attribute12 => l_c_igf_aw_fund_mast.attribute12,

664: x_attribute8 => l_c_igf_aw_fund_mast.attribute8,
665: x_attribute9 => l_c_igf_aw_fund_mast.attribute9,
666: x_attribute10 => l_c_igf_aw_fund_mast.attribute10,
667: x_attribute11 => l_c_igf_aw_fund_mast.attribute11,
668: x_attribute12 => l_c_igf_aw_fund_mast.attribute12,
669: x_attribute13 => l_c_igf_aw_fund_mast.attribute13,
670: x_attribute14 => l_c_igf_aw_fund_mast.attribute14,
671: x_attribute15 => l_c_igf_aw_fund_mast.attribute15,
672: x_attribute16 => l_c_igf_aw_fund_mast.attribute16,

Line 669: x_attribute13 => l_c_igf_aw_fund_mast.attribute13,

665: x_attribute9 => l_c_igf_aw_fund_mast.attribute9,
666: x_attribute10 => l_c_igf_aw_fund_mast.attribute10,
667: x_attribute11 => l_c_igf_aw_fund_mast.attribute11,
668: x_attribute12 => l_c_igf_aw_fund_mast.attribute12,
669: x_attribute13 => l_c_igf_aw_fund_mast.attribute13,
670: x_attribute14 => l_c_igf_aw_fund_mast.attribute14,
671: x_attribute15 => l_c_igf_aw_fund_mast.attribute15,
672: x_attribute16 => l_c_igf_aw_fund_mast.attribute16,
673: x_attribute17 => l_c_igf_aw_fund_mast.attribute17,

Line 670: x_attribute14 => l_c_igf_aw_fund_mast.attribute14,

666: x_attribute10 => l_c_igf_aw_fund_mast.attribute10,
667: x_attribute11 => l_c_igf_aw_fund_mast.attribute11,
668: x_attribute12 => l_c_igf_aw_fund_mast.attribute12,
669: x_attribute13 => l_c_igf_aw_fund_mast.attribute13,
670: x_attribute14 => l_c_igf_aw_fund_mast.attribute14,
671: x_attribute15 => l_c_igf_aw_fund_mast.attribute15,
672: x_attribute16 => l_c_igf_aw_fund_mast.attribute16,
673: x_attribute17 => l_c_igf_aw_fund_mast.attribute17,
674: x_attribute18 => l_c_igf_aw_fund_mast.attribute18,

Line 671: x_attribute15 => l_c_igf_aw_fund_mast.attribute15,

667: x_attribute11 => l_c_igf_aw_fund_mast.attribute11,
668: x_attribute12 => l_c_igf_aw_fund_mast.attribute12,
669: x_attribute13 => l_c_igf_aw_fund_mast.attribute13,
670: x_attribute14 => l_c_igf_aw_fund_mast.attribute14,
671: x_attribute15 => l_c_igf_aw_fund_mast.attribute15,
672: x_attribute16 => l_c_igf_aw_fund_mast.attribute16,
673: x_attribute17 => l_c_igf_aw_fund_mast.attribute17,
674: x_attribute18 => l_c_igf_aw_fund_mast.attribute18,
675: x_attribute19 => l_c_igf_aw_fund_mast.attribute19,

Line 672: x_attribute16 => l_c_igf_aw_fund_mast.attribute16,

668: x_attribute12 => l_c_igf_aw_fund_mast.attribute12,
669: x_attribute13 => l_c_igf_aw_fund_mast.attribute13,
670: x_attribute14 => l_c_igf_aw_fund_mast.attribute14,
671: x_attribute15 => l_c_igf_aw_fund_mast.attribute15,
672: x_attribute16 => l_c_igf_aw_fund_mast.attribute16,
673: x_attribute17 => l_c_igf_aw_fund_mast.attribute17,
674: x_attribute18 => l_c_igf_aw_fund_mast.attribute18,
675: x_attribute19 => l_c_igf_aw_fund_mast.attribute19,
676: x_attribute20 => l_c_igf_aw_fund_mast.attribute20,

Line 673: x_attribute17 => l_c_igf_aw_fund_mast.attribute17,

669: x_attribute13 => l_c_igf_aw_fund_mast.attribute13,
670: x_attribute14 => l_c_igf_aw_fund_mast.attribute14,
671: x_attribute15 => l_c_igf_aw_fund_mast.attribute15,
672: x_attribute16 => l_c_igf_aw_fund_mast.attribute16,
673: x_attribute17 => l_c_igf_aw_fund_mast.attribute17,
674: x_attribute18 => l_c_igf_aw_fund_mast.attribute18,
675: x_attribute19 => l_c_igf_aw_fund_mast.attribute19,
676: x_attribute20 => l_c_igf_aw_fund_mast.attribute20,
677: x_disb_verf_da => l_c_igf_aw_fund_mast.disb_verf_da,

Line 674: x_attribute18 => l_c_igf_aw_fund_mast.attribute18,

670: x_attribute14 => l_c_igf_aw_fund_mast.attribute14,
671: x_attribute15 => l_c_igf_aw_fund_mast.attribute15,
672: x_attribute16 => l_c_igf_aw_fund_mast.attribute16,
673: x_attribute17 => l_c_igf_aw_fund_mast.attribute17,
674: x_attribute18 => l_c_igf_aw_fund_mast.attribute18,
675: x_attribute19 => l_c_igf_aw_fund_mast.attribute19,
676: x_attribute20 => l_c_igf_aw_fund_mast.attribute20,
677: x_disb_verf_da => l_c_igf_aw_fund_mast.disb_verf_da,
678: x_fund_exp_da => l_c_igf_aw_fund_mast.fund_exp_da,

Line 675: x_attribute19 => l_c_igf_aw_fund_mast.attribute19,

671: x_attribute15 => l_c_igf_aw_fund_mast.attribute15,
672: x_attribute16 => l_c_igf_aw_fund_mast.attribute16,
673: x_attribute17 => l_c_igf_aw_fund_mast.attribute17,
674: x_attribute18 => l_c_igf_aw_fund_mast.attribute18,
675: x_attribute19 => l_c_igf_aw_fund_mast.attribute19,
676: x_attribute20 => l_c_igf_aw_fund_mast.attribute20,
677: x_disb_verf_da => l_c_igf_aw_fund_mast.disb_verf_da,
678: x_fund_exp_da => l_c_igf_aw_fund_mast.fund_exp_da,
679: x_nslds_disb_da => l_c_igf_aw_fund_mast.nslds_disb_da,

Line 676: x_attribute20 => l_c_igf_aw_fund_mast.attribute20,

672: x_attribute16 => l_c_igf_aw_fund_mast.attribute16,
673: x_attribute17 => l_c_igf_aw_fund_mast.attribute17,
674: x_attribute18 => l_c_igf_aw_fund_mast.attribute18,
675: x_attribute19 => l_c_igf_aw_fund_mast.attribute19,
676: x_attribute20 => l_c_igf_aw_fund_mast.attribute20,
677: x_disb_verf_da => l_c_igf_aw_fund_mast.disb_verf_da,
678: x_fund_exp_da => l_c_igf_aw_fund_mast.fund_exp_da,
679: x_nslds_disb_da => l_c_igf_aw_fund_mast.nslds_disb_da,
680: x_disb_exp_da => l_c_igf_aw_fund_mast.disb_exp_da,

Line 677: x_disb_verf_da => l_c_igf_aw_fund_mast.disb_verf_da,

673: x_attribute17 => l_c_igf_aw_fund_mast.attribute17,
674: x_attribute18 => l_c_igf_aw_fund_mast.attribute18,
675: x_attribute19 => l_c_igf_aw_fund_mast.attribute19,
676: x_attribute20 => l_c_igf_aw_fund_mast.attribute20,
677: x_disb_verf_da => l_c_igf_aw_fund_mast.disb_verf_da,
678: x_fund_exp_da => l_c_igf_aw_fund_mast.fund_exp_da,
679: x_nslds_disb_da => l_c_igf_aw_fund_mast.nslds_disb_da,
680: x_disb_exp_da => l_c_igf_aw_fund_mast.disb_exp_da,
681: x_fund_recv_reqd => l_c_igf_aw_fund_mast.fund_recv_reqd,

Line 678: x_fund_exp_da => l_c_igf_aw_fund_mast.fund_exp_da,

674: x_attribute18 => l_c_igf_aw_fund_mast.attribute18,
675: x_attribute19 => l_c_igf_aw_fund_mast.attribute19,
676: x_attribute20 => l_c_igf_aw_fund_mast.attribute20,
677: x_disb_verf_da => l_c_igf_aw_fund_mast.disb_verf_da,
678: x_fund_exp_da => l_c_igf_aw_fund_mast.fund_exp_da,
679: x_nslds_disb_da => l_c_igf_aw_fund_mast.nslds_disb_da,
680: x_disb_exp_da => l_c_igf_aw_fund_mast.disb_exp_da,
681: x_fund_recv_reqd => l_c_igf_aw_fund_mast.fund_recv_reqd,
682: x_show_on_bill => l_c_igf_aw_fund_mast.show_on_bill,

Line 679: x_nslds_disb_da => l_c_igf_aw_fund_mast.nslds_disb_da,

675: x_attribute19 => l_c_igf_aw_fund_mast.attribute19,
676: x_attribute20 => l_c_igf_aw_fund_mast.attribute20,
677: x_disb_verf_da => l_c_igf_aw_fund_mast.disb_verf_da,
678: x_fund_exp_da => l_c_igf_aw_fund_mast.fund_exp_da,
679: x_nslds_disb_da => l_c_igf_aw_fund_mast.nslds_disb_da,
680: x_disb_exp_da => l_c_igf_aw_fund_mast.disb_exp_da,
681: x_fund_recv_reqd => l_c_igf_aw_fund_mast.fund_recv_reqd,
682: x_show_on_bill => l_c_igf_aw_fund_mast.show_on_bill,
683: x_bill_desc => l_c_igf_aw_fund_mast.bill_desc,

Line 680: x_disb_exp_da => l_c_igf_aw_fund_mast.disb_exp_da,

676: x_attribute20 => l_c_igf_aw_fund_mast.attribute20,
677: x_disb_verf_da => l_c_igf_aw_fund_mast.disb_verf_da,
678: x_fund_exp_da => l_c_igf_aw_fund_mast.fund_exp_da,
679: x_nslds_disb_da => l_c_igf_aw_fund_mast.nslds_disb_da,
680: x_disb_exp_da => l_c_igf_aw_fund_mast.disb_exp_da,
681: x_fund_recv_reqd => l_c_igf_aw_fund_mast.fund_recv_reqd,
682: x_show_on_bill => l_c_igf_aw_fund_mast.show_on_bill,
683: x_bill_desc => l_c_igf_aw_fund_mast.bill_desc,
684: x_credit_type_id => l_c_igf_aw_fund_mast.credit_type_id,

Line 681: x_fund_recv_reqd => l_c_igf_aw_fund_mast.fund_recv_reqd,

677: x_disb_verf_da => l_c_igf_aw_fund_mast.disb_verf_da,
678: x_fund_exp_da => l_c_igf_aw_fund_mast.fund_exp_da,
679: x_nslds_disb_da => l_c_igf_aw_fund_mast.nslds_disb_da,
680: x_disb_exp_da => l_c_igf_aw_fund_mast.disb_exp_da,
681: x_fund_recv_reqd => l_c_igf_aw_fund_mast.fund_recv_reqd,
682: x_show_on_bill => l_c_igf_aw_fund_mast.show_on_bill,
683: x_bill_desc => l_c_igf_aw_fund_mast.bill_desc,
684: x_credit_type_id => l_c_igf_aw_fund_mast.credit_type_id,
685: x_spnsr_ref_num => l_c_igf_aw_fund_mast.spnsr_ref_num,

Line 682: x_show_on_bill => l_c_igf_aw_fund_mast.show_on_bill,

678: x_fund_exp_da => l_c_igf_aw_fund_mast.fund_exp_da,
679: x_nslds_disb_da => l_c_igf_aw_fund_mast.nslds_disb_da,
680: x_disb_exp_da => l_c_igf_aw_fund_mast.disb_exp_da,
681: x_fund_recv_reqd => l_c_igf_aw_fund_mast.fund_recv_reqd,
682: x_show_on_bill => l_c_igf_aw_fund_mast.show_on_bill,
683: x_bill_desc => l_c_igf_aw_fund_mast.bill_desc,
684: x_credit_type_id => l_c_igf_aw_fund_mast.credit_type_id,
685: x_spnsr_ref_num => l_c_igf_aw_fund_mast.spnsr_ref_num,
686: x_threshold_perct => l_c_igf_aw_fund_mast.threshold_perct,

Line 683: x_bill_desc => l_c_igf_aw_fund_mast.bill_desc,

679: x_nslds_disb_da => l_c_igf_aw_fund_mast.nslds_disb_da,
680: x_disb_exp_da => l_c_igf_aw_fund_mast.disb_exp_da,
681: x_fund_recv_reqd => l_c_igf_aw_fund_mast.fund_recv_reqd,
682: x_show_on_bill => l_c_igf_aw_fund_mast.show_on_bill,
683: x_bill_desc => l_c_igf_aw_fund_mast.bill_desc,
684: x_credit_type_id => l_c_igf_aw_fund_mast.credit_type_id,
685: x_spnsr_ref_num => l_c_igf_aw_fund_mast.spnsr_ref_num,
686: x_threshold_perct => l_c_igf_aw_fund_mast.threshold_perct,
687: x_threshold_value => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.threshold_value),

Line 684: x_credit_type_id => l_c_igf_aw_fund_mast.credit_type_id,

680: x_disb_exp_da => l_c_igf_aw_fund_mast.disb_exp_da,
681: x_fund_recv_reqd => l_c_igf_aw_fund_mast.fund_recv_reqd,
682: x_show_on_bill => l_c_igf_aw_fund_mast.show_on_bill,
683: x_bill_desc => l_c_igf_aw_fund_mast.bill_desc,
684: x_credit_type_id => l_c_igf_aw_fund_mast.credit_type_id,
685: x_spnsr_ref_num => l_c_igf_aw_fund_mast.spnsr_ref_num,
686: x_threshold_perct => l_c_igf_aw_fund_mast.threshold_perct,
687: x_threshold_value => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.threshold_value),
688: x_party_id => l_c_igf_aw_fund_mast.party_id,

Line 685: x_spnsr_ref_num => l_c_igf_aw_fund_mast.spnsr_ref_num,

681: x_fund_recv_reqd => l_c_igf_aw_fund_mast.fund_recv_reqd,
682: x_show_on_bill => l_c_igf_aw_fund_mast.show_on_bill,
683: x_bill_desc => l_c_igf_aw_fund_mast.bill_desc,
684: x_credit_type_id => l_c_igf_aw_fund_mast.credit_type_id,
685: x_spnsr_ref_num => l_c_igf_aw_fund_mast.spnsr_ref_num,
686: x_threshold_perct => l_c_igf_aw_fund_mast.threshold_perct,
687: x_threshold_value => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.threshold_value),
688: x_party_id => l_c_igf_aw_fund_mast.party_id,
689: x_spnsr_fee_type => l_c_igf_aw_fund_mast.spnsr_fee_type,

Line 686: x_threshold_perct => l_c_igf_aw_fund_mast.threshold_perct,

682: x_show_on_bill => l_c_igf_aw_fund_mast.show_on_bill,
683: x_bill_desc => l_c_igf_aw_fund_mast.bill_desc,
684: x_credit_type_id => l_c_igf_aw_fund_mast.credit_type_id,
685: x_spnsr_ref_num => l_c_igf_aw_fund_mast.spnsr_ref_num,
686: x_threshold_perct => l_c_igf_aw_fund_mast.threshold_perct,
687: x_threshold_value => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.threshold_value),
688: x_party_id => l_c_igf_aw_fund_mast.party_id,
689: x_spnsr_fee_type => l_c_igf_aw_fund_mast.spnsr_fee_type,
690: x_min_credit_points => l_c_igf_aw_fund_mast.min_credit_points,

Line 687: x_threshold_value => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.threshold_value),

683: x_bill_desc => l_c_igf_aw_fund_mast.bill_desc,
684: x_credit_type_id => l_c_igf_aw_fund_mast.credit_type_id,
685: x_spnsr_ref_num => l_c_igf_aw_fund_mast.spnsr_ref_num,
686: x_threshold_perct => l_c_igf_aw_fund_mast.threshold_perct,
687: x_threshold_value => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.threshold_value),
688: x_party_id => l_c_igf_aw_fund_mast.party_id,
689: x_spnsr_fee_type => l_c_igf_aw_fund_mast.spnsr_fee_type,
690: x_min_credit_points => l_c_igf_aw_fund_mast.min_credit_points,
691: x_group_id => l_c_igf_aw_fund_mast.group_id,

Line 688: x_party_id => l_c_igf_aw_fund_mast.party_id,

684: x_credit_type_id => l_c_igf_aw_fund_mast.credit_type_id,
685: x_spnsr_ref_num => l_c_igf_aw_fund_mast.spnsr_ref_num,
686: x_threshold_perct => l_c_igf_aw_fund_mast.threshold_perct,
687: x_threshold_value => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.threshold_value),
688: x_party_id => l_c_igf_aw_fund_mast.party_id,
689: x_spnsr_fee_type => l_c_igf_aw_fund_mast.spnsr_fee_type,
690: x_min_credit_points => l_c_igf_aw_fund_mast.min_credit_points,
691: x_group_id => l_c_igf_aw_fund_mast.group_id,
692: x_spnsr_attribute_category => l_c_igf_aw_fund_mast.spnsr_attribute_category,

Line 689: x_spnsr_fee_type => l_c_igf_aw_fund_mast.spnsr_fee_type,

685: x_spnsr_ref_num => l_c_igf_aw_fund_mast.spnsr_ref_num,
686: x_threshold_perct => l_c_igf_aw_fund_mast.threshold_perct,
687: x_threshold_value => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.threshold_value),
688: x_party_id => l_c_igf_aw_fund_mast.party_id,
689: x_spnsr_fee_type => l_c_igf_aw_fund_mast.spnsr_fee_type,
690: x_min_credit_points => l_c_igf_aw_fund_mast.min_credit_points,
691: x_group_id => l_c_igf_aw_fund_mast.group_id,
692: x_spnsr_attribute_category => l_c_igf_aw_fund_mast.spnsr_attribute_category,
693: x_spnsr_attribute1 => l_c_igf_aw_fund_mast.spnsr_attribute1,

Line 690: x_min_credit_points => l_c_igf_aw_fund_mast.min_credit_points,

686: x_threshold_perct => l_c_igf_aw_fund_mast.threshold_perct,
687: x_threshold_value => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.threshold_value),
688: x_party_id => l_c_igf_aw_fund_mast.party_id,
689: x_spnsr_fee_type => l_c_igf_aw_fund_mast.spnsr_fee_type,
690: x_min_credit_points => l_c_igf_aw_fund_mast.min_credit_points,
691: x_group_id => l_c_igf_aw_fund_mast.group_id,
692: x_spnsr_attribute_category => l_c_igf_aw_fund_mast.spnsr_attribute_category,
693: x_spnsr_attribute1 => l_c_igf_aw_fund_mast.spnsr_attribute1,
694: x_spnsr_attribute2 => l_c_igf_aw_fund_mast.spnsr_attribute2,

Line 691: x_group_id => l_c_igf_aw_fund_mast.group_id,

687: x_threshold_value => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.threshold_value),
688: x_party_id => l_c_igf_aw_fund_mast.party_id,
689: x_spnsr_fee_type => l_c_igf_aw_fund_mast.spnsr_fee_type,
690: x_min_credit_points => l_c_igf_aw_fund_mast.min_credit_points,
691: x_group_id => l_c_igf_aw_fund_mast.group_id,
692: x_spnsr_attribute_category => l_c_igf_aw_fund_mast.spnsr_attribute_category,
693: x_spnsr_attribute1 => l_c_igf_aw_fund_mast.spnsr_attribute1,
694: x_spnsr_attribute2 => l_c_igf_aw_fund_mast.spnsr_attribute2,
695: x_spnsr_attribute3 => l_c_igf_aw_fund_mast.spnsr_attribute3,

Line 692: x_spnsr_attribute_category => l_c_igf_aw_fund_mast.spnsr_attribute_category,

688: x_party_id => l_c_igf_aw_fund_mast.party_id,
689: x_spnsr_fee_type => l_c_igf_aw_fund_mast.spnsr_fee_type,
690: x_min_credit_points => l_c_igf_aw_fund_mast.min_credit_points,
691: x_group_id => l_c_igf_aw_fund_mast.group_id,
692: x_spnsr_attribute_category => l_c_igf_aw_fund_mast.spnsr_attribute_category,
693: x_spnsr_attribute1 => l_c_igf_aw_fund_mast.spnsr_attribute1,
694: x_spnsr_attribute2 => l_c_igf_aw_fund_mast.spnsr_attribute2,
695: x_spnsr_attribute3 => l_c_igf_aw_fund_mast.spnsr_attribute3,
696: x_spnsr_attribute4 => l_c_igf_aw_fund_mast.spnsr_attribute4,

Line 693: x_spnsr_attribute1 => l_c_igf_aw_fund_mast.spnsr_attribute1,

689: x_spnsr_fee_type => l_c_igf_aw_fund_mast.spnsr_fee_type,
690: x_min_credit_points => l_c_igf_aw_fund_mast.min_credit_points,
691: x_group_id => l_c_igf_aw_fund_mast.group_id,
692: x_spnsr_attribute_category => l_c_igf_aw_fund_mast.spnsr_attribute_category,
693: x_spnsr_attribute1 => l_c_igf_aw_fund_mast.spnsr_attribute1,
694: x_spnsr_attribute2 => l_c_igf_aw_fund_mast.spnsr_attribute2,
695: x_spnsr_attribute3 => l_c_igf_aw_fund_mast.spnsr_attribute3,
696: x_spnsr_attribute4 => l_c_igf_aw_fund_mast.spnsr_attribute4,
697: x_spnsr_attribute5 => l_c_igf_aw_fund_mast.spnsr_attribute5,

Line 694: x_spnsr_attribute2 => l_c_igf_aw_fund_mast.spnsr_attribute2,

690: x_min_credit_points => l_c_igf_aw_fund_mast.min_credit_points,
691: x_group_id => l_c_igf_aw_fund_mast.group_id,
692: x_spnsr_attribute_category => l_c_igf_aw_fund_mast.spnsr_attribute_category,
693: x_spnsr_attribute1 => l_c_igf_aw_fund_mast.spnsr_attribute1,
694: x_spnsr_attribute2 => l_c_igf_aw_fund_mast.spnsr_attribute2,
695: x_spnsr_attribute3 => l_c_igf_aw_fund_mast.spnsr_attribute3,
696: x_spnsr_attribute4 => l_c_igf_aw_fund_mast.spnsr_attribute4,
697: x_spnsr_attribute5 => l_c_igf_aw_fund_mast.spnsr_attribute5,
698: x_spnsr_attribute6 => l_c_igf_aw_fund_mast.spnsr_attribute6,

Line 695: x_spnsr_attribute3 => l_c_igf_aw_fund_mast.spnsr_attribute3,

691: x_group_id => l_c_igf_aw_fund_mast.group_id,
692: x_spnsr_attribute_category => l_c_igf_aw_fund_mast.spnsr_attribute_category,
693: x_spnsr_attribute1 => l_c_igf_aw_fund_mast.spnsr_attribute1,
694: x_spnsr_attribute2 => l_c_igf_aw_fund_mast.spnsr_attribute2,
695: x_spnsr_attribute3 => l_c_igf_aw_fund_mast.spnsr_attribute3,
696: x_spnsr_attribute4 => l_c_igf_aw_fund_mast.spnsr_attribute4,
697: x_spnsr_attribute5 => l_c_igf_aw_fund_mast.spnsr_attribute5,
698: x_spnsr_attribute6 => l_c_igf_aw_fund_mast.spnsr_attribute6,
699: x_spnsr_attribute7 => l_c_igf_aw_fund_mast.spnsr_attribute7,

Line 696: x_spnsr_attribute4 => l_c_igf_aw_fund_mast.spnsr_attribute4,

692: x_spnsr_attribute_category => l_c_igf_aw_fund_mast.spnsr_attribute_category,
693: x_spnsr_attribute1 => l_c_igf_aw_fund_mast.spnsr_attribute1,
694: x_spnsr_attribute2 => l_c_igf_aw_fund_mast.spnsr_attribute2,
695: x_spnsr_attribute3 => l_c_igf_aw_fund_mast.spnsr_attribute3,
696: x_spnsr_attribute4 => l_c_igf_aw_fund_mast.spnsr_attribute4,
697: x_spnsr_attribute5 => l_c_igf_aw_fund_mast.spnsr_attribute5,
698: x_spnsr_attribute6 => l_c_igf_aw_fund_mast.spnsr_attribute6,
699: x_spnsr_attribute7 => l_c_igf_aw_fund_mast.spnsr_attribute7,
700: x_spnsr_attribute8 => l_c_igf_aw_fund_mast.spnsr_attribute8,

Line 697: x_spnsr_attribute5 => l_c_igf_aw_fund_mast.spnsr_attribute5,

693: x_spnsr_attribute1 => l_c_igf_aw_fund_mast.spnsr_attribute1,
694: x_spnsr_attribute2 => l_c_igf_aw_fund_mast.spnsr_attribute2,
695: x_spnsr_attribute3 => l_c_igf_aw_fund_mast.spnsr_attribute3,
696: x_spnsr_attribute4 => l_c_igf_aw_fund_mast.spnsr_attribute4,
697: x_spnsr_attribute5 => l_c_igf_aw_fund_mast.spnsr_attribute5,
698: x_spnsr_attribute6 => l_c_igf_aw_fund_mast.spnsr_attribute6,
699: x_spnsr_attribute7 => l_c_igf_aw_fund_mast.spnsr_attribute7,
700: x_spnsr_attribute8 => l_c_igf_aw_fund_mast.spnsr_attribute8,
701: x_spnsr_attribute9 => l_c_igf_aw_fund_mast.spnsr_attribute9,

Line 698: x_spnsr_attribute6 => l_c_igf_aw_fund_mast.spnsr_attribute6,

694: x_spnsr_attribute2 => l_c_igf_aw_fund_mast.spnsr_attribute2,
695: x_spnsr_attribute3 => l_c_igf_aw_fund_mast.spnsr_attribute3,
696: x_spnsr_attribute4 => l_c_igf_aw_fund_mast.spnsr_attribute4,
697: x_spnsr_attribute5 => l_c_igf_aw_fund_mast.spnsr_attribute5,
698: x_spnsr_attribute6 => l_c_igf_aw_fund_mast.spnsr_attribute6,
699: x_spnsr_attribute7 => l_c_igf_aw_fund_mast.spnsr_attribute7,
700: x_spnsr_attribute8 => l_c_igf_aw_fund_mast.spnsr_attribute8,
701: x_spnsr_attribute9 => l_c_igf_aw_fund_mast.spnsr_attribute9,
702: x_spnsr_attribute10 => l_c_igf_aw_fund_mast.spnsr_attribute10,

Line 699: x_spnsr_attribute7 => l_c_igf_aw_fund_mast.spnsr_attribute7,

695: x_spnsr_attribute3 => l_c_igf_aw_fund_mast.spnsr_attribute3,
696: x_spnsr_attribute4 => l_c_igf_aw_fund_mast.spnsr_attribute4,
697: x_spnsr_attribute5 => l_c_igf_aw_fund_mast.spnsr_attribute5,
698: x_spnsr_attribute6 => l_c_igf_aw_fund_mast.spnsr_attribute6,
699: x_spnsr_attribute7 => l_c_igf_aw_fund_mast.spnsr_attribute7,
700: x_spnsr_attribute8 => l_c_igf_aw_fund_mast.spnsr_attribute8,
701: x_spnsr_attribute9 => l_c_igf_aw_fund_mast.spnsr_attribute9,
702: x_spnsr_attribute10 => l_c_igf_aw_fund_mast.spnsr_attribute10,
703: x_spnsr_attribute11 => l_c_igf_aw_fund_mast.spnsr_attribute11,

Line 700: x_spnsr_attribute8 => l_c_igf_aw_fund_mast.spnsr_attribute8,

696: x_spnsr_attribute4 => l_c_igf_aw_fund_mast.spnsr_attribute4,
697: x_spnsr_attribute5 => l_c_igf_aw_fund_mast.spnsr_attribute5,
698: x_spnsr_attribute6 => l_c_igf_aw_fund_mast.spnsr_attribute6,
699: x_spnsr_attribute7 => l_c_igf_aw_fund_mast.spnsr_attribute7,
700: x_spnsr_attribute8 => l_c_igf_aw_fund_mast.spnsr_attribute8,
701: x_spnsr_attribute9 => l_c_igf_aw_fund_mast.spnsr_attribute9,
702: x_spnsr_attribute10 => l_c_igf_aw_fund_mast.spnsr_attribute10,
703: x_spnsr_attribute11 => l_c_igf_aw_fund_mast.spnsr_attribute11,
704: x_spnsr_attribute12 => l_c_igf_aw_fund_mast.spnsr_attribute12,

Line 701: x_spnsr_attribute9 => l_c_igf_aw_fund_mast.spnsr_attribute9,

697: x_spnsr_attribute5 => l_c_igf_aw_fund_mast.spnsr_attribute5,
698: x_spnsr_attribute6 => l_c_igf_aw_fund_mast.spnsr_attribute6,
699: x_spnsr_attribute7 => l_c_igf_aw_fund_mast.spnsr_attribute7,
700: x_spnsr_attribute8 => l_c_igf_aw_fund_mast.spnsr_attribute8,
701: x_spnsr_attribute9 => l_c_igf_aw_fund_mast.spnsr_attribute9,
702: x_spnsr_attribute10 => l_c_igf_aw_fund_mast.spnsr_attribute10,
703: x_spnsr_attribute11 => l_c_igf_aw_fund_mast.spnsr_attribute11,
704: x_spnsr_attribute12 => l_c_igf_aw_fund_mast.spnsr_attribute12,
705: x_spnsr_attribute13 => l_c_igf_aw_fund_mast.spnsr_attribute13,

Line 702: x_spnsr_attribute10 => l_c_igf_aw_fund_mast.spnsr_attribute10,

698: x_spnsr_attribute6 => l_c_igf_aw_fund_mast.spnsr_attribute6,
699: x_spnsr_attribute7 => l_c_igf_aw_fund_mast.spnsr_attribute7,
700: x_spnsr_attribute8 => l_c_igf_aw_fund_mast.spnsr_attribute8,
701: x_spnsr_attribute9 => l_c_igf_aw_fund_mast.spnsr_attribute9,
702: x_spnsr_attribute10 => l_c_igf_aw_fund_mast.spnsr_attribute10,
703: x_spnsr_attribute11 => l_c_igf_aw_fund_mast.spnsr_attribute11,
704: x_spnsr_attribute12 => l_c_igf_aw_fund_mast.spnsr_attribute12,
705: x_spnsr_attribute13 => l_c_igf_aw_fund_mast.spnsr_attribute13,
706: x_spnsr_attribute14 => l_c_igf_aw_fund_mast.spnsr_attribute14,

Line 703: x_spnsr_attribute11 => l_c_igf_aw_fund_mast.spnsr_attribute11,

699: x_spnsr_attribute7 => l_c_igf_aw_fund_mast.spnsr_attribute7,
700: x_spnsr_attribute8 => l_c_igf_aw_fund_mast.spnsr_attribute8,
701: x_spnsr_attribute9 => l_c_igf_aw_fund_mast.spnsr_attribute9,
702: x_spnsr_attribute10 => l_c_igf_aw_fund_mast.spnsr_attribute10,
703: x_spnsr_attribute11 => l_c_igf_aw_fund_mast.spnsr_attribute11,
704: x_spnsr_attribute12 => l_c_igf_aw_fund_mast.spnsr_attribute12,
705: x_spnsr_attribute13 => l_c_igf_aw_fund_mast.spnsr_attribute13,
706: x_spnsr_attribute14 => l_c_igf_aw_fund_mast.spnsr_attribute14,
707: x_spnsr_attribute15 => l_c_igf_aw_fund_mast.spnsr_attribute15,

Line 704: x_spnsr_attribute12 => l_c_igf_aw_fund_mast.spnsr_attribute12,

700: x_spnsr_attribute8 => l_c_igf_aw_fund_mast.spnsr_attribute8,
701: x_spnsr_attribute9 => l_c_igf_aw_fund_mast.spnsr_attribute9,
702: x_spnsr_attribute10 => l_c_igf_aw_fund_mast.spnsr_attribute10,
703: x_spnsr_attribute11 => l_c_igf_aw_fund_mast.spnsr_attribute11,
704: x_spnsr_attribute12 => l_c_igf_aw_fund_mast.spnsr_attribute12,
705: x_spnsr_attribute13 => l_c_igf_aw_fund_mast.spnsr_attribute13,
706: x_spnsr_attribute14 => l_c_igf_aw_fund_mast.spnsr_attribute14,
707: x_spnsr_attribute15 => l_c_igf_aw_fund_mast.spnsr_attribute15,
708: x_spnsr_attribute16 => l_c_igf_aw_fund_mast.spnsr_attribute16,

Line 705: x_spnsr_attribute13 => l_c_igf_aw_fund_mast.spnsr_attribute13,

701: x_spnsr_attribute9 => l_c_igf_aw_fund_mast.spnsr_attribute9,
702: x_spnsr_attribute10 => l_c_igf_aw_fund_mast.spnsr_attribute10,
703: x_spnsr_attribute11 => l_c_igf_aw_fund_mast.spnsr_attribute11,
704: x_spnsr_attribute12 => l_c_igf_aw_fund_mast.spnsr_attribute12,
705: x_spnsr_attribute13 => l_c_igf_aw_fund_mast.spnsr_attribute13,
706: x_spnsr_attribute14 => l_c_igf_aw_fund_mast.spnsr_attribute14,
707: x_spnsr_attribute15 => l_c_igf_aw_fund_mast.spnsr_attribute15,
708: x_spnsr_attribute16 => l_c_igf_aw_fund_mast.spnsr_attribute16,
709: x_spnsr_attribute17 => l_c_igf_aw_fund_mast.spnsr_attribute17,

Line 706: x_spnsr_attribute14 => l_c_igf_aw_fund_mast.spnsr_attribute14,

702: x_spnsr_attribute10 => l_c_igf_aw_fund_mast.spnsr_attribute10,
703: x_spnsr_attribute11 => l_c_igf_aw_fund_mast.spnsr_attribute11,
704: x_spnsr_attribute12 => l_c_igf_aw_fund_mast.spnsr_attribute12,
705: x_spnsr_attribute13 => l_c_igf_aw_fund_mast.spnsr_attribute13,
706: x_spnsr_attribute14 => l_c_igf_aw_fund_mast.spnsr_attribute14,
707: x_spnsr_attribute15 => l_c_igf_aw_fund_mast.spnsr_attribute15,
708: x_spnsr_attribute16 => l_c_igf_aw_fund_mast.spnsr_attribute16,
709: x_spnsr_attribute17 => l_c_igf_aw_fund_mast.spnsr_attribute17,
710: x_spnsr_attribute18 => l_c_igf_aw_fund_mast.spnsr_attribute18,

Line 707: x_spnsr_attribute15 => l_c_igf_aw_fund_mast.spnsr_attribute15,

703: x_spnsr_attribute11 => l_c_igf_aw_fund_mast.spnsr_attribute11,
704: x_spnsr_attribute12 => l_c_igf_aw_fund_mast.spnsr_attribute12,
705: x_spnsr_attribute13 => l_c_igf_aw_fund_mast.spnsr_attribute13,
706: x_spnsr_attribute14 => l_c_igf_aw_fund_mast.spnsr_attribute14,
707: x_spnsr_attribute15 => l_c_igf_aw_fund_mast.spnsr_attribute15,
708: x_spnsr_attribute16 => l_c_igf_aw_fund_mast.spnsr_attribute16,
709: x_spnsr_attribute17 => l_c_igf_aw_fund_mast.spnsr_attribute17,
710: x_spnsr_attribute18 => l_c_igf_aw_fund_mast.spnsr_attribute18,
711: x_spnsr_attribute19 => l_c_igf_aw_fund_mast.spnsr_attribute19,

Line 708: x_spnsr_attribute16 => l_c_igf_aw_fund_mast.spnsr_attribute16,

704: x_spnsr_attribute12 => l_c_igf_aw_fund_mast.spnsr_attribute12,
705: x_spnsr_attribute13 => l_c_igf_aw_fund_mast.spnsr_attribute13,
706: x_spnsr_attribute14 => l_c_igf_aw_fund_mast.spnsr_attribute14,
707: x_spnsr_attribute15 => l_c_igf_aw_fund_mast.spnsr_attribute15,
708: x_spnsr_attribute16 => l_c_igf_aw_fund_mast.spnsr_attribute16,
709: x_spnsr_attribute17 => l_c_igf_aw_fund_mast.spnsr_attribute17,
710: x_spnsr_attribute18 => l_c_igf_aw_fund_mast.spnsr_attribute18,
711: x_spnsr_attribute19 => l_c_igf_aw_fund_mast.spnsr_attribute19,
712: x_spnsr_attribute20 => l_c_igf_aw_fund_mast.spnsr_attribute20,

Line 709: x_spnsr_attribute17 => l_c_igf_aw_fund_mast.spnsr_attribute17,

705: x_spnsr_attribute13 => l_c_igf_aw_fund_mast.spnsr_attribute13,
706: x_spnsr_attribute14 => l_c_igf_aw_fund_mast.spnsr_attribute14,
707: x_spnsr_attribute15 => l_c_igf_aw_fund_mast.spnsr_attribute15,
708: x_spnsr_attribute16 => l_c_igf_aw_fund_mast.spnsr_attribute16,
709: x_spnsr_attribute17 => l_c_igf_aw_fund_mast.spnsr_attribute17,
710: x_spnsr_attribute18 => l_c_igf_aw_fund_mast.spnsr_attribute18,
711: x_spnsr_attribute19 => l_c_igf_aw_fund_mast.spnsr_attribute19,
712: x_spnsr_attribute20 => l_c_igf_aw_fund_mast.spnsr_attribute20,
713: x_ver_app_stat_override => l_c_igf_aw_fund_mast.ver_app_stat_override ,

Line 710: x_spnsr_attribute18 => l_c_igf_aw_fund_mast.spnsr_attribute18,

706: x_spnsr_attribute14 => l_c_igf_aw_fund_mast.spnsr_attribute14,
707: x_spnsr_attribute15 => l_c_igf_aw_fund_mast.spnsr_attribute15,
708: x_spnsr_attribute16 => l_c_igf_aw_fund_mast.spnsr_attribute16,
709: x_spnsr_attribute17 => l_c_igf_aw_fund_mast.spnsr_attribute17,
710: x_spnsr_attribute18 => l_c_igf_aw_fund_mast.spnsr_attribute18,
711: x_spnsr_attribute19 => l_c_igf_aw_fund_mast.spnsr_attribute19,
712: x_spnsr_attribute20 => l_c_igf_aw_fund_mast.spnsr_attribute20,
713: x_ver_app_stat_override => l_c_igf_aw_fund_mast.ver_app_stat_override ,
714: x_gift_aid => l_c_igf_aw_fund_mast.gift_aid,

Line 711: x_spnsr_attribute19 => l_c_igf_aw_fund_mast.spnsr_attribute19,

707: x_spnsr_attribute15 => l_c_igf_aw_fund_mast.spnsr_attribute15,
708: x_spnsr_attribute16 => l_c_igf_aw_fund_mast.spnsr_attribute16,
709: x_spnsr_attribute17 => l_c_igf_aw_fund_mast.spnsr_attribute17,
710: x_spnsr_attribute18 => l_c_igf_aw_fund_mast.spnsr_attribute18,
711: x_spnsr_attribute19 => l_c_igf_aw_fund_mast.spnsr_attribute19,
712: x_spnsr_attribute20 => l_c_igf_aw_fund_mast.spnsr_attribute20,
713: x_ver_app_stat_override => l_c_igf_aw_fund_mast.ver_app_stat_override ,
714: x_gift_aid => l_c_igf_aw_fund_mast.gift_aid,
715: x_send_without_doc => l_c_igf_aw_fund_mast.send_without_doc, -- Bug # 2758812. Added send_without_doc column.

Line 712: x_spnsr_attribute20 => l_c_igf_aw_fund_mast.spnsr_attribute20,

708: x_spnsr_attribute16 => l_c_igf_aw_fund_mast.spnsr_attribute16,
709: x_spnsr_attribute17 => l_c_igf_aw_fund_mast.spnsr_attribute17,
710: x_spnsr_attribute18 => l_c_igf_aw_fund_mast.spnsr_attribute18,
711: x_spnsr_attribute19 => l_c_igf_aw_fund_mast.spnsr_attribute19,
712: x_spnsr_attribute20 => l_c_igf_aw_fund_mast.spnsr_attribute20,
713: x_ver_app_stat_override => l_c_igf_aw_fund_mast.ver_app_stat_override ,
714: x_gift_aid => l_c_igf_aw_fund_mast.gift_aid,
715: x_send_without_doc => l_c_igf_aw_fund_mast.send_without_doc, -- Bug # 2758812. Added send_without_doc column.
716: x_re_pkg_verif_flag => l_c_igf_aw_fund_mast.re_pkg_verif_flag,

Line 713: x_ver_app_stat_override => l_c_igf_aw_fund_mast.ver_app_stat_override ,

709: x_spnsr_attribute17 => l_c_igf_aw_fund_mast.spnsr_attribute17,
710: x_spnsr_attribute18 => l_c_igf_aw_fund_mast.spnsr_attribute18,
711: x_spnsr_attribute19 => l_c_igf_aw_fund_mast.spnsr_attribute19,
712: x_spnsr_attribute20 => l_c_igf_aw_fund_mast.spnsr_attribute20,
713: x_ver_app_stat_override => l_c_igf_aw_fund_mast.ver_app_stat_override ,
714: x_gift_aid => l_c_igf_aw_fund_mast.gift_aid,
715: x_send_without_doc => l_c_igf_aw_fund_mast.send_without_doc, -- Bug # 2758812. Added send_without_doc column.
716: x_re_pkg_verif_flag => l_c_igf_aw_fund_mast.re_pkg_verif_flag,
717: x_donot_repkg_if_code => l_c_igf_aw_fund_mast.donot_repkg_if_code,

Line 714: x_gift_aid => l_c_igf_aw_fund_mast.gift_aid,

710: x_spnsr_attribute18 => l_c_igf_aw_fund_mast.spnsr_attribute18,
711: x_spnsr_attribute19 => l_c_igf_aw_fund_mast.spnsr_attribute19,
712: x_spnsr_attribute20 => l_c_igf_aw_fund_mast.spnsr_attribute20,
713: x_ver_app_stat_override => l_c_igf_aw_fund_mast.ver_app_stat_override ,
714: x_gift_aid => l_c_igf_aw_fund_mast.gift_aid,
715: x_send_without_doc => l_c_igf_aw_fund_mast.send_without_doc, -- Bug # 2758812. Added send_without_doc column.
716: x_re_pkg_verif_flag => l_c_igf_aw_fund_mast.re_pkg_verif_flag,
717: x_donot_repkg_if_code => l_c_igf_aw_fund_mast.donot_repkg_if_code,
718: x_lock_award_flag => l_c_igf_aw_fund_mast.lock_award_flag,

Line 715: x_send_without_doc => l_c_igf_aw_fund_mast.send_without_doc, -- Bug # 2758812. Added send_without_doc column.

711: x_spnsr_attribute19 => l_c_igf_aw_fund_mast.spnsr_attribute19,
712: x_spnsr_attribute20 => l_c_igf_aw_fund_mast.spnsr_attribute20,
713: x_ver_app_stat_override => l_c_igf_aw_fund_mast.ver_app_stat_override ,
714: x_gift_aid => l_c_igf_aw_fund_mast.gift_aid,
715: x_send_without_doc => l_c_igf_aw_fund_mast.send_without_doc, -- Bug # 2758812. Added send_without_doc column.
716: x_re_pkg_verif_flag => l_c_igf_aw_fund_mast.re_pkg_verif_flag,
717: x_donot_repkg_if_code => l_c_igf_aw_fund_mast.donot_repkg_if_code,
718: x_lock_award_flag => l_c_igf_aw_fund_mast.lock_award_flag,
719: x_disb_rounding_code => l_c_igf_aw_fund_mast.disb_rounding_code,

Line 716: x_re_pkg_verif_flag => l_c_igf_aw_fund_mast.re_pkg_verif_flag,

712: x_spnsr_attribute20 => l_c_igf_aw_fund_mast.spnsr_attribute20,
713: x_ver_app_stat_override => l_c_igf_aw_fund_mast.ver_app_stat_override ,
714: x_gift_aid => l_c_igf_aw_fund_mast.gift_aid,
715: x_send_without_doc => l_c_igf_aw_fund_mast.send_without_doc, -- Bug # 2758812. Added send_without_doc column.
716: x_re_pkg_verif_flag => l_c_igf_aw_fund_mast.re_pkg_verif_flag,
717: x_donot_repkg_if_code => l_c_igf_aw_fund_mast.donot_repkg_if_code,
718: x_lock_award_flag => l_c_igf_aw_fund_mast.lock_award_flag,
719: x_disb_rounding_code => l_c_igf_aw_fund_mast.disb_rounding_code,
720: x_view_only_flag => l_c_igf_aw_fund_mast.view_only_flag,

Line 717: x_donot_repkg_if_code => l_c_igf_aw_fund_mast.donot_repkg_if_code,

713: x_ver_app_stat_override => l_c_igf_aw_fund_mast.ver_app_stat_override ,
714: x_gift_aid => l_c_igf_aw_fund_mast.gift_aid,
715: x_send_without_doc => l_c_igf_aw_fund_mast.send_without_doc, -- Bug # 2758812. Added send_without_doc column.
716: x_re_pkg_verif_flag => l_c_igf_aw_fund_mast.re_pkg_verif_flag,
717: x_donot_repkg_if_code => l_c_igf_aw_fund_mast.donot_repkg_if_code,
718: x_lock_award_flag => l_c_igf_aw_fund_mast.lock_award_flag,
719: x_disb_rounding_code => l_c_igf_aw_fund_mast.disb_rounding_code,
720: x_view_only_flag => l_c_igf_aw_fund_mast.view_only_flag,
721: x_accept_less_amt_flag => l_c_igf_aw_fund_mast.accept_less_amt_flag,

Line 718: x_lock_award_flag => l_c_igf_aw_fund_mast.lock_award_flag,

714: x_gift_aid => l_c_igf_aw_fund_mast.gift_aid,
715: x_send_without_doc => l_c_igf_aw_fund_mast.send_without_doc, -- Bug # 2758812. Added send_without_doc column.
716: x_re_pkg_verif_flag => l_c_igf_aw_fund_mast.re_pkg_verif_flag,
717: x_donot_repkg_if_code => l_c_igf_aw_fund_mast.donot_repkg_if_code,
718: x_lock_award_flag => l_c_igf_aw_fund_mast.lock_award_flag,
719: x_disb_rounding_code => l_c_igf_aw_fund_mast.disb_rounding_code,
720: x_view_only_flag => l_c_igf_aw_fund_mast.view_only_flag,
721: x_accept_less_amt_flag => l_c_igf_aw_fund_mast.accept_less_amt_flag,
722: x_allow_inc_post_accept_flag => l_c_igf_aw_fund_mast.allow_inc_post_accept_flag,

Line 719: x_disb_rounding_code => l_c_igf_aw_fund_mast.disb_rounding_code,

715: x_send_without_doc => l_c_igf_aw_fund_mast.send_without_doc, -- Bug # 2758812. Added send_without_doc column.
716: x_re_pkg_verif_flag => l_c_igf_aw_fund_mast.re_pkg_verif_flag,
717: x_donot_repkg_if_code => l_c_igf_aw_fund_mast.donot_repkg_if_code,
718: x_lock_award_flag => l_c_igf_aw_fund_mast.lock_award_flag,
719: x_disb_rounding_code => l_c_igf_aw_fund_mast.disb_rounding_code,
720: x_view_only_flag => l_c_igf_aw_fund_mast.view_only_flag,
721: x_accept_less_amt_flag => l_c_igf_aw_fund_mast.accept_less_amt_flag,
722: x_allow_inc_post_accept_flag => l_c_igf_aw_fund_mast.allow_inc_post_accept_flag,
723: x_min_increase_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_increase_amt),

Line 720: x_view_only_flag => l_c_igf_aw_fund_mast.view_only_flag,

716: x_re_pkg_verif_flag => l_c_igf_aw_fund_mast.re_pkg_verif_flag,
717: x_donot_repkg_if_code => l_c_igf_aw_fund_mast.donot_repkg_if_code,
718: x_lock_award_flag => l_c_igf_aw_fund_mast.lock_award_flag,
719: x_disb_rounding_code => l_c_igf_aw_fund_mast.disb_rounding_code,
720: x_view_only_flag => l_c_igf_aw_fund_mast.view_only_flag,
721: x_accept_less_amt_flag => l_c_igf_aw_fund_mast.accept_less_amt_flag,
722: x_allow_inc_post_accept_flag => l_c_igf_aw_fund_mast.allow_inc_post_accept_flag,
723: x_min_increase_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_increase_amt),
724: x_allow_dec_post_accept_flag => l_c_igf_aw_fund_mast.allow_dec_post_accept_flag,

Line 721: x_accept_less_amt_flag => l_c_igf_aw_fund_mast.accept_less_amt_flag,

717: x_donot_repkg_if_code => l_c_igf_aw_fund_mast.donot_repkg_if_code,
718: x_lock_award_flag => l_c_igf_aw_fund_mast.lock_award_flag,
719: x_disb_rounding_code => l_c_igf_aw_fund_mast.disb_rounding_code,
720: x_view_only_flag => l_c_igf_aw_fund_mast.view_only_flag,
721: x_accept_less_amt_flag => l_c_igf_aw_fund_mast.accept_less_amt_flag,
722: x_allow_inc_post_accept_flag => l_c_igf_aw_fund_mast.allow_inc_post_accept_flag,
723: x_min_increase_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_increase_amt),
724: x_allow_dec_post_accept_flag => l_c_igf_aw_fund_mast.allow_dec_post_accept_flag,
725: x_min_decrease_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_decrease_amt),

Line 722: x_allow_inc_post_accept_flag => l_c_igf_aw_fund_mast.allow_inc_post_accept_flag,

718: x_lock_award_flag => l_c_igf_aw_fund_mast.lock_award_flag,
719: x_disb_rounding_code => l_c_igf_aw_fund_mast.disb_rounding_code,
720: x_view_only_flag => l_c_igf_aw_fund_mast.view_only_flag,
721: x_accept_less_amt_flag => l_c_igf_aw_fund_mast.accept_less_amt_flag,
722: x_allow_inc_post_accept_flag => l_c_igf_aw_fund_mast.allow_inc_post_accept_flag,
723: x_min_increase_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_increase_amt),
724: x_allow_dec_post_accept_flag => l_c_igf_aw_fund_mast.allow_dec_post_accept_flag,
725: x_min_decrease_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_decrease_amt),
726: x_allow_decln_post_accept_flag => l_c_igf_aw_fund_mast.allow_decln_post_accept_flag,

Line 723: x_min_increase_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_increase_amt),

719: x_disb_rounding_code => l_c_igf_aw_fund_mast.disb_rounding_code,
720: x_view_only_flag => l_c_igf_aw_fund_mast.view_only_flag,
721: x_accept_less_amt_flag => l_c_igf_aw_fund_mast.accept_less_amt_flag,
722: x_allow_inc_post_accept_flag => l_c_igf_aw_fund_mast.allow_inc_post_accept_flag,
723: x_min_increase_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_increase_amt),
724: x_allow_dec_post_accept_flag => l_c_igf_aw_fund_mast.allow_dec_post_accept_flag,
725: x_min_decrease_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_decrease_amt),
726: x_allow_decln_post_accept_flag => l_c_igf_aw_fund_mast.allow_decln_post_accept_flag,
727: x_status_after_decline => l_c_igf_aw_fund_mast.status_after_decline,

Line 724: x_allow_dec_post_accept_flag => l_c_igf_aw_fund_mast.allow_dec_post_accept_flag,

720: x_view_only_flag => l_c_igf_aw_fund_mast.view_only_flag,
721: x_accept_less_amt_flag => l_c_igf_aw_fund_mast.accept_less_amt_flag,
722: x_allow_inc_post_accept_flag => l_c_igf_aw_fund_mast.allow_inc_post_accept_flag,
723: x_min_increase_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_increase_amt),
724: x_allow_dec_post_accept_flag => l_c_igf_aw_fund_mast.allow_dec_post_accept_flag,
725: x_min_decrease_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_decrease_amt),
726: x_allow_decln_post_accept_flag => l_c_igf_aw_fund_mast.allow_decln_post_accept_flag,
727: x_status_after_decline => l_c_igf_aw_fund_mast.status_after_decline,
728: x_fund_information_txt => l_c_igf_aw_fund_mast.fund_information_txt

Line 725: x_min_decrease_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_decrease_amt),

721: x_accept_less_amt_flag => l_c_igf_aw_fund_mast.accept_less_amt_flag,
722: x_allow_inc_post_accept_flag => l_c_igf_aw_fund_mast.allow_inc_post_accept_flag,
723: x_min_increase_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_increase_amt),
724: x_allow_dec_post_accept_flag => l_c_igf_aw_fund_mast.allow_dec_post_accept_flag,
725: x_min_decrease_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_decrease_amt),
726: x_allow_decln_post_accept_flag => l_c_igf_aw_fund_mast.allow_decln_post_accept_flag,
727: x_status_after_decline => l_c_igf_aw_fund_mast.status_after_decline,
728: x_fund_information_txt => l_c_igf_aw_fund_mast.fund_information_txt
729: );

Line 726: x_allow_decln_post_accept_flag => l_c_igf_aw_fund_mast.allow_decln_post_accept_flag,

722: x_allow_inc_post_accept_flag => l_c_igf_aw_fund_mast.allow_inc_post_accept_flag,
723: x_min_increase_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_increase_amt),
724: x_allow_dec_post_accept_flag => l_c_igf_aw_fund_mast.allow_dec_post_accept_flag,
725: x_min_decrease_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_decrease_amt),
726: x_allow_decln_post_accept_flag => l_c_igf_aw_fund_mast.allow_decln_post_accept_flag,
727: x_status_after_decline => l_c_igf_aw_fund_mast.status_after_decline,
728: x_fund_information_txt => l_c_igf_aw_fund_mast.fund_information_txt
729: );
730:

Line 727: x_status_after_decline => l_c_igf_aw_fund_mast.status_after_decline,

723: x_min_increase_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_increase_amt),
724: x_allow_dec_post_accept_flag => l_c_igf_aw_fund_mast.allow_dec_post_accept_flag,
725: x_min_decrease_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_decrease_amt),
726: x_allow_decln_post_accept_flag => l_c_igf_aw_fund_mast.allow_decln_post_accept_flag,
727: x_status_after_decline => l_c_igf_aw_fund_mast.status_after_decline,
728: x_fund_information_txt => l_c_igf_aw_fund_mast.fund_information_txt
729: );
730:
731: EXCEPTION

Line 728: x_fund_information_txt => l_c_igf_aw_fund_mast.fund_information_txt

724: x_allow_dec_post_accept_flag => l_c_igf_aw_fund_mast.allow_dec_post_accept_flag,
725: x_min_decrease_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_decrease_amt),
726: x_allow_decln_post_accept_flag => l_c_igf_aw_fund_mast.allow_decln_post_accept_flag,
727: x_status_after_decline => l_c_igf_aw_fund_mast.status_after_decline,
728: x_fund_information_txt => l_c_igf_aw_fund_mast.fund_information_txt
729: );
730:
731: EXCEPTION
732: WHEN OTHERS THEN

Line 750: FOR l_c_igf_aw_fund_tp IN c_igf_aw_fund_tp(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)

746: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','START_DT'),22) ||
747: lookup_desc('IGF_AW_LOOKUPS_MSG','END_DT');
748: fnd_file.put_line(fnd_file.log,l_msg_str_0);
749: fnd_file.put_line(fnd_file.log,' ');
750: FOR l_c_igf_aw_fund_tp IN c_igf_aw_fund_tp(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)
751: LOOP
752: -- Check if succeeding terms are present for the current term passed as
753: -- parameter to the process
754: OPEN c_igf_aw_cal_rel(cp_cal_type => l_c_igf_aw_fund_tp.tp_cal_type,

Line 813: FOR l_c_igf_sp_fc IN c_igf_sp_fc(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)

809: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
810: fnd_file.put_line(fnd_file.log,l_msg_str_0);
811: fnd_file.put_line(fnd_file.log,' ');
812: -- rolling over pays only fee class details
813: FOR l_c_igf_sp_fc IN c_igf_sp_fc(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)
814: LOOP
815: -- log relevant details
816: l_msg_str_1 := RPAD(l_c_igf_sp_fc.fee_class,32) ||
817: NVL(RPAD(TO_CHAR(l_c_igf_sp_fc.fee_percent),10),' ' )||

Line 937: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE

933:
934: -- procedure which rollover over the sponsor student relation
935: PROCEDURE sponsor_student_rollover ( p_sc_cal_type IN igs_ca_inst_all.cal_type%TYPE,
936: p_sc_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
937: p_fund IN igf_aw_fund_mast_all.fund_id%TYPE
938: ) IS
939: ------------------------------------------------------------------
940: --Created by : Sanil Madathil, Oracle IDC
941: --Date created: 24 Jan 2001

Line 960: --vvutukur 07-Mar-2003 Bug#2822725. Removed parameters p_cal_type,p_sequence_number and from the cursor c_igf_aw_fund_mast usage also.

956: -- will be logged when user tries to rollover Sponsor-student relation and the
957: -- associated term calendar mapping does not exist for the destination award year.
958: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_sp_stdnt_rel, igf_sp_std_fc,
959: -- igf_sp_std_prg, igf_sp_std_unit are now rounded off to currency precision
960: --vvutukur 07-Mar-2003 Bug#2822725. Removed parameters p_cal_type,p_sequence_number and from the cursor c_igf_aw_fund_mast usage also.
961: ------------------------------------------------------------------
962: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter
963: CURSOR c_fund_mast(cp_fund_code igf_aw_fund_mast.fund_code%TYPE,
964: cp_cal_type igs_ca_inst.cal_type%TYPE,

Line 962: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter

958: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_sp_stdnt_rel, igf_sp_std_fc,
959: -- igf_sp_std_prg, igf_sp_std_unit are now rounded off to currency precision
960: --vvutukur 07-Mar-2003 Bug#2822725. Removed parameters p_cal_type,p_sequence_number and from the cursor c_igf_aw_fund_mast usage also.
961: ------------------------------------------------------------------
962: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter
963: CURSOR c_fund_mast(cp_fund_code igf_aw_fund_mast.fund_code%TYPE,
964: cp_cal_type igs_ca_inst.cal_type%TYPE,
965: cp_sequence_number igs_ca_inst.sequence_number%TYPE
966: ) IS

Line 963: CURSOR c_fund_mast(cp_fund_code igf_aw_fund_mast.fund_code%TYPE,

959: -- igf_sp_std_prg, igf_sp_std_unit are now rounded off to currency precision
960: --vvutukur 07-Mar-2003 Bug#2822725. Removed parameters p_cal_type,p_sequence_number and from the cursor c_igf_aw_fund_mast usage also.
961: ------------------------------------------------------------------
962: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter
963: CURSOR c_fund_mast(cp_fund_code igf_aw_fund_mast.fund_code%TYPE,
964: cp_cal_type igs_ca_inst.cal_type%TYPE,
965: cp_sequence_number igs_ca_inst.sequence_number%TYPE
966: ) IS
967: SELECT fmast.*

Line 968: FROM igf_aw_fund_mast fmast ,

964: cp_cal_type igs_ca_inst.cal_type%TYPE,
965: cp_sequence_number igs_ca_inst.sequence_number%TYPE
966: ) IS
967: SELECT fmast.*
968: FROM igf_aw_fund_mast fmast ,
969: igf_aw_fund_cat fcat
970: WHERE fmast.fund_code = fcat.fund_code
971: AND fmast.fund_code = cp_fund_code
972: AND fmast.ci_cal_type = cp_cal_type

Line 980: CURSOR c_igf_aw_fund_tp( cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS

976:
977: -- cursor variable for c_fund_mast
978: l_c_fund_mast c_fund_mast%ROWTYPE;
979:
980: CURSOR c_igf_aw_fund_tp( cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
981: SELECT *
982: FROM igf_aw_fund_tp_v ftp
983: WHERE ftp.fund_id = cp_fund_id;
984:

Line 987: CURSOR c_igf_sp_stdnt_rel(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS

983: WHERE ftp.fund_id = cp_fund_id;
984:
985: l_c_igf_aw_fund_tp c_igf_aw_fund_tp%ROWTYPE;
986:
987: CURSOR c_igf_sp_stdnt_rel(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
988: SELECT *
989: FROM igf_sp_stdnt_rel_v
990: WHERE fund_id = cp_fund_id ;
991:

Line 1034: l_fund_id igf_aw_fund_mast.fund_id%TYPE;

1030: l_message_name VARCHAR2(30) := NULL;
1031: l_err_exception EXCEPTION;
1032: l_stud_exception EXCEPTION;
1033: l_rowid VARCHAR2(25);
1034: l_fund_id igf_aw_fund_mast.fund_id%TYPE;
1035: l_spnsr_stdnt_id igf_sp_stdnt_rel_all.spnsr_stdnt_id%TYPE;
1036: l_fee_cls_id igf_sp_fc_all.fee_cls_id%TYPE;
1037: l_fee_cls_prg_id igf_sp_prg_all.fee_cls_prg_id%TYPE;
1038: l_fee_cls_unit_id igf_sp_unit_all.fee_cls_unit_id%TYPE;

Line 1044: -- cursor variable for c_igf_aw_fund_mast

1040: l_base_id igf_ap_fa_base_rec.base_id%TYPE;
1041: l_ans BOOLEAN := TRUE;
1042: -- cursor variable for c_igf_aw_cal_rel
1043: l_c_igf_aw_cal_rel c_igf_aw_cal_rel%ROWTYPE;
1044: -- cursor variable for c_igf_aw_fund_mast
1045: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
1046: BEGIN
1047:
1048: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);

Line 1045: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;

1041: l_ans BOOLEAN := TRUE;
1042: -- cursor variable for c_igf_aw_cal_rel
1043: l_c_igf_aw_cal_rel c_igf_aw_cal_rel%ROWTYPE;
1044: -- cursor variable for c_igf_aw_fund_mast
1045: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
1046: BEGIN
1047:
1048: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
1049: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;

Line 1048: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);

1044: -- cursor variable for c_igf_aw_fund_mast
1045: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
1046: BEGIN
1047:
1048: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
1049: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
1050: CLOSE c_igf_aw_fund_mast;
1051: BEGIN
1052: -- declare a save point

Line 1049: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;

1045: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
1046: BEGIN
1047:
1048: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
1049: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
1050: CLOSE c_igf_aw_fund_mast;
1051: BEGIN
1052: -- declare a save point
1053: SAVEPOINT sp_student;

Line 1050: CLOSE c_igf_aw_fund_mast;

1046: BEGIN
1047:
1048: OPEN c_igf_aw_fund_mast(cp_fund_id => p_fund);
1049: FETCH c_igf_aw_fund_mast INTO l_c_igf_aw_fund_mast;
1050: CLOSE c_igf_aw_fund_mast;
1051: BEGIN
1052: -- declare a save point
1053: SAVEPOINT sp_student;
1054:

Line 1056: OPEN c_fund_mast (cp_fund_code => l_c_igf_aw_fund_mast.fund_code,

1052: -- declare a save point
1053: SAVEPOINT sp_student;
1054:
1055: -- get the fund id of the succeeding award year for the fund passed to the process
1056: OPEN c_fund_mast (cp_fund_code => l_c_igf_aw_fund_mast.fund_code,
1057: cp_cal_type => p_sc_cal_type,
1058: cp_sequence_number => p_sc_seq_num);
1059: FETCH c_fund_mast INTO l_c_fund_mast;
1060: IF c_fund_mast%NOTFOUND THEN

Line 1077: l_msg_str_1 := RPAD(l_c_igf_aw_fund_mast.fund_code,32)||

1073: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','FUND_CODE'),32) ||
1074: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_YEAR'),19) ;
1075: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1076: fnd_file.put_line(fnd_file.log,' ');
1077: l_msg_str_1 := RPAD(l_c_igf_aw_fund_mast.fund_code,32)||
1078: RPAD((p_sc_cal_type||' '||p_sc_seq_num),19);
1079: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1080: fnd_file.put_line(fnd_file.log,' ');
1081: OPEN c_igf_aw_fund_tp(l_c_fund_mast.fund_id);

Line 1109: FOR l_c_igf_sp_stdnt_rel IN c_igf_sp_stdnt_rel(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)

1105: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1106: fnd_file.put_line(fnd_file.log,' ');
1107:
1108: -- rolling over sponsor student relation for fund and term calendar for the succeeding award year
1109: FOR l_c_igf_sp_stdnt_rel IN c_igf_sp_stdnt_rel(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)
1110: LOOP
1111: BEGIN
1112: -- declare a save point
1113: SAVEPOINT sp_spnsr_student;