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_AWARD dependencies on IGF_AW_AWARD

Line 32: -- TBH impact of the igf_aw_award Added columns LOCK_AWARD_FLAG,

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.
35: --vchappid 22-Jun-2003 Bug 2881654, Log file format is revamped, Dynamic Person Group feature is introduced,
36: -- Sponsor Code parameter is made optional

Line 37: --bkkumar #2858504 04-jun-2003 Added legacy_record_flag and award_number_txt in the table handler calls for igf_aw_award_pkg.insert_row

33: -- APP_TRANS_NUM_TXT
34: --vvutukur 20-Jul-2003 Enh#3038511.FICR106 Build. Modified procedure create_award_disb.
35: --vchappid 22-Jun-2003 Bug 2881654, Log file format is revamped, Dynamic Person Group feature is introduced,
36: -- Sponsor Code parameter is made optional
37: --bkkumar #2858504 04-jun-2003 Added legacy_record_flag and award_number_txt in the table handler calls for igf_aw_award_pkg.insert_row
38: --pathipat 25-Apr-2003 Enh 2831569 - Commercial Receivables build
39: -- Modified create_award_disb() - added call to chk_manage_account()
40: --vvutukur 26-feb-2003 Enh#2758823.FA117 Build. Modified the procedure create_disb_dtl.
41: --smadathi 30-Jan-2002 Bug 2620302. Function et_person_number ,procedure create_award_disb modified.

Line 42: --adhawan #2613546 28-oct-2002 Added alt_pell_schedule in the table handler calls for igf_aw_award_pkg.insert_row

38: --pathipat 25-Apr-2003 Enh 2831569 - Commercial Receivables build
39: -- Modified create_award_disb() - added call to chk_manage_account()
40: --vvutukur 26-feb-2003 Enh#2758823.FA117 Build. Modified the procedure create_disb_dtl.
41: --smadathi 30-Jan-2002 Bug 2620302. Function et_person_number ,procedure create_award_disb modified.
42: --adhawan #2613546 28-oct-2002 Added alt_pell_schedule in the table handler calls for igf_aw_award_pkg.insert_row
43:
44: -- adhawan #2613546 27-oct-2002 gscc fix for Default
45: --smadathi 02-jul-2002 Bug 2427996. Modified create_award_disb procedure.
46: --smadathi 31-Jun-2002 Bug 2387604. Modified create_aw_award procedure, loop_thru_spnsr_dtl Procedure.

Line 198: CURSOR c_award_amount(cp_n_award_id igf_aw_award.award_id%TYPE)

194: Change History :
195: Who When What
196: (reverse chronological order - newest change first)
197: ----------------------------------------------------------------------------*/
198: CURSOR c_award_amount(cp_n_award_id igf_aw_award.award_id%TYPE)
199: IS
200: SELECT accepted_amt
201: FROM igf_aw_award
202: WHERE award_id = cp_n_award_id;

Line 201: FROM igf_aw_award

197: ----------------------------------------------------------------------------*/
198: CURSOR c_award_amount(cp_n_award_id igf_aw_award.award_id%TYPE)
199: IS
200: SELECT accepted_amt
201: FROM igf_aw_award
202: WHERE award_id = cp_n_award_id;
203: l_n_award_amount igf_aw_award.accepted_amt%TYPE;
204: BEGIN
205: OPEN c_award_amount(p_n_award_id);

Line 203: l_n_award_amount igf_aw_award.accepted_amt%TYPE;

199: IS
200: SELECT accepted_amt
201: FROM igf_aw_award
202: WHERE award_id = cp_n_award_id;
203: l_n_award_amount igf_aw_award.accepted_amt%TYPE;
204: BEGIN
205: OPEN c_award_amount(p_n_award_id);
206: FETCH c_award_amount INTO l_n_award_amount;
207: CLOSE c_award_amount;

Line 348: PROCEDURE create_disb_dtl(p_award_id igf_aw_award_all.award_id%TYPE,

344: END IF;
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)

Line 368: CURSOR cur_chk_adj( cp_award_id igf_aw_award_all.award_id%TYPE,

364: -- are now rounded off to currency precision
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

Line 377: CURSOR cur_get_adisb( cp_award_id igf_aw_award_all.award_id%TYPE,

373: WHERE award_id = cp_award_id AND
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

Line 931: FUNCTION get_disb_num (p_award_id igf_aw_award.award_id%TYPE)

927: END IF;
928: RAISE;
929: END recal_dis_gross_amt;
930:
931: FUNCTION get_disb_num (p_award_id igf_aw_award.award_id%TYPE)
932: RETURN NUMBER
933: AS
934: ------------------------------------------------------------------------------------
935: --Created by : smanglm ( Oracle IDC)

Line 947: CURSOR c_disb_num (cp_award_id igf_aw_award.award_id%TYPE)

943: --Change History:
944: --Who When What
945: -------------------------------------------------------------------------------------
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;

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 1019: l_award_id igf_aw_award.award_id%TYPE;

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;
1022:
1023: l_n_tot_spns_amt igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;

Line 1038: igf_aw_award_pkg.insert_row(x_rowid => g_rowid ,

1034: IF rec_stdnt_rel.tot_spnsr_amount IS NULL THEN
1035: -- look at FC level
1036: g_rowid := NULL;
1037: l_award_id := NULL;
1038: igf_aw_award_pkg.insert_row(x_rowid => g_rowid ,
1039: x_award_id => l_award_id ,
1040: x_fund_id => rec_stdnt_rel.fund_id,
1041: x_base_id => rec_stdnt_rel.base_id,
1042: x_offered_amt => 0 ,

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 1209: igf_aw_award_pkg.insert_row(

1205:
1206: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1207: l_n_tot_spns_amt := igs_fi_gen_gl.get_formatted_amount(l_n_tot_spns_amt);
1208:
1209: igf_aw_award_pkg.insert_row(
1210: x_rowid => g_rowid ,
1211: x_award_id => l_award_id ,
1212: x_fund_id => rec_stdnt_rel.fund_id,
1213: x_base_id => rec_stdnt_rel.base_id,

Line 1376: FROM igf_aw_award awd

1372: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1373: )
1374: IS
1375: SELECT NVL(manual_update,'N'), award_id
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

Line 1385: l_manual_update igf_aw_award.manual_update%TYPE;

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

Line 1386: l_award_id igf_aw_award.award_id%TYPE;

1382: AND disb.ld_cal_type = cp_ld_cal_type
1383: AND disb.ld_sequence_number = cp_ld_sequence_number);
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

Line 1391: CURSOR c_aw_awd_disb(cp_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: )
1395: IS

Line 1418: l_n_before_awd_amt igf_aw_award.accepted_amt%TYPE :=0;

1414: SELECT *
1415: FROM igf_sp_std_fc
1416: WHERE spnsr_stdnt_id = cp_spnsr_stdnt_id;
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;

Line 1963: -- if no record exist in igf_aw_award for rec_sp_std_dtls.base_id, rec_sp_std_dtls.fund_id

1959: END IF;-- check for manual update
1960: END LOOP;
1961: CLOSE c_manual_update;
1962:
1963: -- if no record exist in igf_aw_award for rec_sp_std_dtls.base_id, rec_sp_std_dtls.fund_id
1964: -- create the record in igf_aw_award
1965: IF l_rec_count = 0 and p_award_type = 'A' THEN
1966: IF NOT check_eligibility (p_person_id,
1967: p_min_attendance_type,

Line 1964: -- create the record in igf_aw_award

1960: END LOOP;
1961: CLOSE c_manual_update;
1962:
1963: -- if no record exist in igf_aw_award for rec_sp_std_dtls.base_id, rec_sp_std_dtls.fund_id
1964: -- create the record in igf_aw_award
1965: IF l_rec_count = 0 and p_award_type = 'A' THEN
1966: IF NOT check_eligibility (p_person_id,
1967: p_min_attendance_type,
1968: p_min_credit_points,