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.

[Home] [Help]

APPS.IGF_SP_AWARD dependencies on IGF_AW_AWD_DISB

Line 27: -- Changed the TBH calls of the packages: igf_aw_awd_disb_pkg and igf_db_awd_disb_dtl_pkg

23: --akomurav 06-jun-2006 Bug 5276122 - Made the changes required(TBH Impact) for adding 2 new columns in IGF_DB_AWD_DISB_DTL_ALL table
24: --pathipat 18-May-2006 Bug 5194095 - Modified create_award_disb, loop_thru_spnsr_dtl_pvt and recal_dis_gross_amt
25: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Modified create_disb_dtl, create_aw_award, loop_thru_spnsr_dtl_pvt
26: --ayedubat 13-OCT-04 FA 149 COD-XML Standards build bug # 3416863
27: -- Changed the TBH calls of the packages: igf_aw_awd_disb_pkg and igf_db_awd_disb_dtl_pkg
28: --veramach July 2004 FA 151 HR Integration(bug #3709292)
29: -- Impact of obsoleting columns from fund manager
30: -- bkkumar 04-DEC-2003 Bug 3252382 FA 131 . TBH impact for the igf_aw_awd_disb_all
31: -- Added two columns ATTENDANCE_TYPE_CODE,BASE_ATTENDANCE_TYPE_CODE

Line 30: -- bkkumar 04-DEC-2003 Bug 3252382 FA 131 . TBH impact for the igf_aw_awd_disb_all

26: --ayedubat 13-OCT-04 FA 149 COD-XML Standards build bug # 3416863
27: -- Changed the TBH calls of the packages: igf_aw_awd_disb_pkg and igf_db_awd_disb_dtl_pkg
28: --veramach July 2004 FA 151 HR Integration(bug #3709292)
29: -- Impact of obsoleting columns from fund manager
30: -- bkkumar 04-DEC-2003 Bug 3252382 FA 131 . TBH impact for the igf_aw_awd_disb_all
31: -- Added two columns ATTENDANCE_TYPE_CODE,BASE_ATTENDANCE_TYPE_CODE
32: -- TBH impact of the igf_aw_award Added columns LOCK_AWARD_FLAG,
33: -- APP_TRANS_NUM_TXT
34: --vvutukur 20-Jul-2003 Enh#3038511.FICR106 Build. Modified procedure create_award_disb.

Line 349: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)

345: RETURN TRUE;
346: END check_eligibility;
347:
348: PROCEDURE create_disb_dtl(p_award_id igf_aw_award_all.award_id%TYPE,
349: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
350: AS
351: -------------------------------------------------------------------------------------
352: --Created by : smanglm ( Oracle IDC)
353: --Date created: 2002/01/11

Line 369: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE)

365: --vvutukur 26-Feb-2003 Enh#2758823.FA117 Build. Assigned value 'D' to disb_dtl_rec.disb_activity, instead of NULL.
366: -------------------------------------------------------------------------------------
367:
368: CURSOR cur_chk_adj( cp_award_id igf_aw_award_all.award_id%TYPE,
369: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
370: IS
371: SELECT NVL(disb_seq_num,0) disb_seq_num
372: FROM igf_db_awd_disb_dtl
373: WHERE award_id = cp_award_id AND

Line 378: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE)

374: disb_num = cp_disb_num;
375: chk_adj_rec cur_chk_adj%ROWTYPE;
376:
377: CURSOR cur_get_adisb( cp_award_id igf_aw_award_all.award_id%TYPE,
378: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
379: IS
380: SELECT *
381: FROM igf_aw_awd_disb
382: WHERE award_id = cp_award_id AND

Line 381: FROM igf_aw_awd_disb

377: CURSOR cur_get_adisb( cp_award_id igf_aw_award_all.award_id%TYPE,
378: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
379: IS
380: SELECT *
381: FROM igf_aw_awd_disb
382: WHERE award_id = cp_award_id AND
383: disb_num = cp_disb_num;
384: get_adisb_rec cur_get_adisb%ROWTYPE;
385:

Line 950: FROM igf_aw_awd_disb

946: -- cursor to get max of disb num
947: CURSOR c_disb_num (cp_award_id igf_aw_award.award_id%TYPE)
948: IS
949: SELECT NVL(max(disb_num),0) + 1
950: FROM igf_aw_awd_disb
951: WHERE award_id = cp_award_id;
952: l_disb_num igf_aw_awd_disb.disb_num%TYPE;
953: BEGIN
954: OPEN c_disb_num (p_award_id);

Line 952: l_disb_num igf_aw_awd_disb.disb_num%TYPE;

948: IS
949: SELECT NVL(max(disb_num),0) + 1
950: FROM igf_aw_awd_disb
951: WHERE award_id = cp_award_id;
952: l_disb_num igf_aw_awd_disb.disb_num%TYPE;
953: BEGIN
954: OPEN c_disb_num (p_award_id);
955: FETCH c_disb_num INTO l_disb_num;
956: CLOSE c_disb_num;

Line 966: p_award_type igf_aw_awd_disb.trans_type%TYPE,

962: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
963: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE,
964: p_fee_type igf_aw_fund_mast.fee_type%TYPE,
965: p_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,
966: p_award_type igf_aw_awd_disb.trans_type%TYPE,
967: p_person_id igs_pe_person.person_id%TYPE,
968: p_chk_elig VARCHAR2)
969: AS
970: ------------------------------------------------------------------------------------

Line 986: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_aw_awd_disb, igf_aw_award

982: -- Logging the message 'New Award is created for the person with the following details.'
983: -- only once before actual creation of Disbursement in the loop of fetched FC records.
984: --pathipat 18-May-2006 Bug 5194095 - Added call to recal_dis_gross_amt when Total Sponsor Amount has been
985: -- specified at Student Relation level.
986: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_aw_awd_disb, igf_aw_award
987: -- are now rounded off to currency precision
988: --vchappid 22-Jun-2003 Bug 2881654, Log file format is revamped
989: --smadathi 31-Jun-2002 Bug 2387604. New Message IGF_SP_NO_DISB_DTL has been registered
990: -- for logging. This message is logged for informing the user

Line 1017: l_disb_gross_amt igf_aw_awd_disb.disb_gross_amt%TYPE;

1013: WHERE spnsr_stdnt_id = cp_spnsr_stdnt_id;
1014:
1015: l_include_as_plncrd igf_aw_fund_mast.show_on_bill%TYPE;
1016:
1017: l_disb_gross_amt igf_aw_awd_disb.disb_gross_amt%TYPE;
1018: l_chk_elig VARCHAR2(1);
1019: l_award_id igf_aw_award.award_id%TYPE;
1020: l_disb_num igf_aw_awd_disb.disb_num%TYPE;
1021: l_n_cnt NUMBER := 0;

Line 1020: l_disb_num igf_aw_awd_disb.disb_num%TYPE;

1016:
1017: l_disb_gross_amt igf_aw_awd_disb.disb_gross_amt%TYPE;
1018: l_chk_elig VARCHAR2(1);
1019: l_award_id igf_aw_award.award_id%TYPE;
1020: l_disb_num igf_aw_awd_disb.disb_num%TYPE;
1021: l_n_cnt NUMBER := 0;
1022:
1023: l_n_tot_spns_amt igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
1024:

Line 1112: igf_aw_awd_disb_pkg.insert_row(

1108: ELSE
1109: g_b_msg_logged := TRUE;
1110: l_n_cnt := NVL(l_n_cnt,0) + 1;
1111: g_rowid := NULL;
1112: igf_aw_awd_disb_pkg.insert_row(
1113: x_rowid => g_rowid ,
1114: x_award_id => l_award_id ,
1115: x_disb_num => l_disb_num ,
1116: x_tp_cal_type => NULL ,

Line 1202: -- create record in igf_aw_award and igf_aw_awd_disb with the same amount

1198: l_n_tot_spns_amt := recal_dis_gross_amt(p_spnsr_stdnt_id => rec_stdnt_rel.spnsr_stdnt_id,
1199: p_fee_cls_id => NULL,
1200: p_chk_elig => p_chk_elig);
1201:
1202: -- create record in igf_aw_award and igf_aw_awd_disb with the same amount
1203: g_rowid := NULL;
1204: l_award_id := NULL;
1205:
1206: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

Line 1263: igf_aw_awd_disb_pkg.insert_row(

1259: log_parameters(g_v_award_id,l_award_id);
1260:
1261: l_disb_num := get_disb_num (l_award_id);
1262: g_rowid := NULL;
1263: igf_aw_awd_disb_pkg.insert_row(
1264: x_rowid => g_rowid ,
1265: x_award_id => l_award_id ,
1266: x_disb_num => l_disb_num ,
1267: x_tp_cal_type => NULL ,

Line 1355: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_aw_awd_disb

1351: --Change History:
1352: --Who When What
1353: --pathipat 18-May-2006 Bug 5194095 - Added calls to recal_dis_gross_amt to fetch the
1354: -- total sponsor amount.
1355: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_aw_awd_disb
1356: -- are now rounded off to currency precision
1357: --vchappid 22-Jun-2003 Bug 2881654, Log file format is revamped
1358: --smadathi 17-Jun-2002 Bug 2387572. Logging of IGF_SP_NO_AWARD added. The token
1359: -- amount for message IGF_SP_UPDATE_AWARD modified to handle the

Line 1380: FROM igf_aw_awd_disb disb

1376: FROM igf_aw_award awd
1377: WHERE base_id = cp_base_id
1378: AND fund_id = cp_fund_id
1379: AND EXISTS (SELECT '1'
1380: FROM igf_aw_awd_disb disb
1381: WHERE disb.award_id = awd.award_id
1382: AND disb.ld_cal_type = cp_ld_cal_type
1383: AND disb.ld_sequence_number = cp_ld_sequence_number);
1384:

Line 1388: l_disb_gross_amt igf_aw_awd_disb.disb_gross_amt%TYPE;

1384:
1385: l_manual_update igf_aw_award.manual_update%TYPE;
1386: l_award_id igf_aw_award.award_id%TYPE;
1387: l_rec_count NUMBER :=0;
1388: l_disb_gross_amt igf_aw_awd_disb.disb_gross_amt%TYPE;
1389:
1390: -- cursor to fetch records from igf_aw_awd_disb which have trans_type as P
1391: CURSOR c_aw_awd_disb(cp_award_id igf_aw_award.award_id%TYPE,
1392: cp_v_fee_class igf_aw_awd_disb.fee_class%TYPE,

Line 1390: -- cursor to fetch records from igf_aw_awd_disb which have trans_type as P

1386: l_award_id igf_aw_award.award_id%TYPE;
1387: l_rec_count NUMBER :=0;
1388: l_disb_gross_amt igf_aw_awd_disb.disb_gross_amt%TYPE;
1389:
1390: -- cursor to fetch records from igf_aw_awd_disb which have trans_type as P
1391: CURSOR c_aw_awd_disb(cp_award_id igf_aw_award.award_id%TYPE,
1392: cp_v_fee_class igf_aw_awd_disb.fee_class%TYPE,
1393: cp_trans_type igf_aw_awd_disb.trans_type%TYPE
1394: )

Line 1392: cp_v_fee_class igf_aw_awd_disb.fee_class%TYPE,

1388: l_disb_gross_amt igf_aw_awd_disb.disb_gross_amt%TYPE;
1389:
1390: -- cursor to fetch records from igf_aw_awd_disb which have trans_type as P
1391: CURSOR c_aw_awd_disb(cp_award_id igf_aw_award.award_id%TYPE,
1392: cp_v_fee_class igf_aw_awd_disb.fee_class%TYPE,
1393: cp_trans_type igf_aw_awd_disb.trans_type%TYPE
1394: )
1395: IS
1396: SELECT *

Line 1393: cp_trans_type igf_aw_awd_disb.trans_type%TYPE

1389:
1390: -- cursor to fetch records from igf_aw_awd_disb which have trans_type as P
1391: CURSOR c_aw_awd_disb(cp_award_id igf_aw_award.award_id%TYPE,
1392: cp_v_fee_class igf_aw_awd_disb.fee_class%TYPE,
1393: cp_trans_type igf_aw_awd_disb.trans_type%TYPE
1394: )
1395: IS
1396: SELECT *
1397: FROM igf_aw_awd_disb

Line 1397: FROM igf_aw_awd_disb

1393: cp_trans_type igf_aw_awd_disb.trans_type%TYPE
1394: )
1395: IS
1396: SELECT *
1397: FROM igf_aw_awd_disb
1398: WHERE award_id = cp_award_id
1399: AND (
1400: (fee_class = cp_v_fee_class AND cp_v_fee_class IS NOT NULL AND fee_class IS NOT NULL)
1401: OR

Line 1421: l_v_award_type igf_aw_awd_disb.trans_type%TYPE;

1417: rec_c_igf_sp_std_fc c_igf_sp_std_fc%ROWTYPE;
1418: l_n_before_awd_amt igf_aw_award.accepted_amt%TYPE :=0;
1419:
1420: l_include_as_plncrd igf_aw_fund_mast.show_on_bill%TYPE;
1421: l_v_award_type igf_aw_awd_disb.trans_type%TYPE;
1422: l_n_disb_num igf_aw_awd_disb.disb_num%TYPE;
1423:
1424: l_v_upd_msg_text fnd_new_messages.message_text%TYPE;
1425:

Line 1422: l_n_disb_num igf_aw_awd_disb.disb_num%TYPE;

1418: l_n_before_awd_amt igf_aw_award.accepted_amt%TYPE :=0;
1419:
1420: l_include_as_plncrd igf_aw_fund_mast.show_on_bill%TYPE;
1421: l_v_award_type igf_aw_awd_disb.trans_type%TYPE;
1422: l_n_disb_num igf_aw_awd_disb.disb_num%TYPE;
1423:
1424: l_v_upd_msg_text fnd_new_messages.message_text%TYPE;
1425:
1426: TYPE l_msg_tab IS TABLE OF fnd_new_messages.message_text%TYPE INDEX BY BINARY_INTEGER;

Line 1456: -- fetch record from igf_aw_awd_disb based on award id obtained and update only if

1452: FETCH c_manual_update INTO l_manual_update,l_award_id;
1453: EXIT WHEN c_manual_update%NOTFOUND;
1454: l_rec_count := c_manual_update%ROWCOUNT;
1455: IF l_manual_update = 'Y' AND p_award_type = 'A' THEN
1456: -- fetch record from igf_aw_awd_disb based on award id obtained and update only if
1457: -- the award type is A
1458: g_b_msg_logged := FALSE;
1459: FOR rec_aw_awd_disb IN c_aw_awd_disb (l_award_id,NULL,'P')
1460: LOOP

Line 1469: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id ,

1465:
1466: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1467: fnd_file.put_line(fnd_file.log,fnd_message.get);
1468: -- make trans type P to A
1469: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id ,
1470: x_award_id => rec_aw_awd_disb.award_id ,
1471: x_disb_num => rec_aw_awd_disb.disb_num ,
1472: x_tp_cal_type => rec_aw_awd_disb.tp_cal_type ,
1473: x_tp_sequence_number => rec_aw_awd_disb.tp_sequence_number ,

Line 1552: -- fetch record from igf_aw_awd_disb based on award id obtained and update only if

1548:
1549: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1550: l_n_tot_spns_amt := igs_fi_gen_gl.get_formatted_amount(l_n_tot_spns_amt);
1551:
1552: -- fetch record from igf_aw_awd_disb based on award id obtained and update only if
1553: -- the award type is A
1554: FOR rec_aw_awd_disb IN c_aw_awd_disb (l_award_id,NULL,'P')
1555: LOOP
1556: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');

Line 1559: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id ,

1555: LOOP
1556: fnd_message.set_name('IGF','IGF_SP_PLN_AWD_CNV_ACT_AWD');
1557: fnd_file.put_line(fnd_file.log,fnd_message.get);
1558: -- make trans type P to A
1559: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id ,
1560: x_award_id => rec_aw_awd_disb.award_id ,
1561: x_disb_num => rec_aw_awd_disb.disb_num ,
1562: x_tp_cal_type => rec_aw_awd_disb.tp_cal_type ,
1563: x_tp_sequence_number => rec_aw_awd_disb.tp_sequence_number ,

Line 1637: -- fetch record from igf_aw_awd_disb based on award id obtained

1633: OPEN c_igf_sp_std_fc(p_spnsr_stdnt_id);
1634: LOOP
1635: FETCH c_igf_sp_std_fc INTO rec_c_igf_sp_std_fc;
1636: EXIT WHEN c_igf_sp_std_fc%NOTFOUND;
1637: -- fetch record from igf_aw_awd_disb based on award id obtained
1638: OPEN c_aw_awd_disb(l_award_id,rec_c_igf_sp_std_fc.fee_class,NULL);
1639: FETCH c_aw_awd_disb INTO rec_aw_awd_disb;
1640: IF c_aw_awd_disb%FOUND THEN
1641: IF NOT (rec_aw_awd_disb.trans_type = 'A' AND p_award_type = 'P') THEN

Line 1682: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id,

1678: l_v_msg(i) := g_v_ext_disb_amount||' : '|| rec_aw_awd_disb.disb_net_amt;
1679: i := i+1;
1680: l_v_msg(i) := g_v_upd_disb_amount||' : '|| l_disb_gross_amt;
1681:
1682: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id,
1683: x_award_id => rec_aw_awd_disb.award_id ,
1684: x_disb_num => rec_aw_awd_disb.disb_num ,
1685: x_tp_cal_type => rec_aw_awd_disb.tp_cal_type ,
1686: x_tp_sequence_number => rec_aw_awd_disb.tp_sequence_number ,

Line 1748: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id,

1744: l_v_msg(i) := g_v_disb_amount||' : '|| rec_aw_awd_disb.disb_net_amt;
1745:
1746: -- when the process is invoked in the Actual Mode then when there is no change in the disbursement amount
1747: -- then the Planned Disbursement records needs to be updated to Actual
1748: igf_aw_awd_disb_pkg.update_row (x_rowid => rec_aw_awd_disb.row_id,
1749: x_award_id => rec_aw_awd_disb.award_id ,
1750: x_disb_num => rec_aw_awd_disb.disb_num ,
1751: x_tp_cal_type => rec_aw_awd_disb.tp_cal_type ,
1752: x_tp_sequence_number => rec_aw_awd_disb.tp_sequence_number ,

Line 1846: igf_aw_awd_disb_pkg.insert_row(x_rowid => g_rowid,

1842: fnd_message.set_name('IGF','IGF_SP_UPDATE_AWARD');
1843: l_v_upd_msg_text := fnd_message.get;
1844:
1845:
1846: igf_aw_awd_disb_pkg.insert_row(x_rowid => g_rowid,
1847: x_award_id => l_award_id,
1848: x_disb_num => l_n_disb_num,
1849: x_tp_cal_type => NULL,
1850: x_tp_sequence_number => NULL,

Line 2158: p_award_type IN igf_aw_awd_disb.trans_type%TYPE,

2154: p_term_calendar IN VARCHAR2,
2155: p_person_id IN igs_pe_person.person_id%TYPE,
2156: p_person_group_id IN igs_pe_prsid_grp_mem.group_id%TYPE,
2157: p_fund_id IN igf_sp_stdnt_rel.fund_id%TYPE,
2158: p_award_type IN igf_aw_awd_disb.trans_type%TYPE,
2159: p_test_mode IN VARCHAR2,
2160: p_org_id IN NUMBER)
2161: AS
2162: ------------------------------------------------------------------------------------