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_SP_STDNT_REL

Line 297: FUNCTION check_eligibility ( p_person_id igf_sp_stdnt_rel.person_id%TYPE,

293: CLOSE c_person_number;
294: RETURN l_person_number;
295: END get_person_number;
296:
297: FUNCTION check_eligibility ( p_person_id igf_sp_stdnt_rel.person_id%TYPE,
298: p_min_att_type igf_sp_stdnt_rel.min_attendance_type%TYPE,
299: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,
300: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
301: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE)

Line 298: p_min_att_type igf_sp_stdnt_rel.min_attendance_type%TYPE,

294: RETURN l_person_number;
295: END get_person_number;
296:
297: FUNCTION check_eligibility ( p_person_id igf_sp_stdnt_rel.person_id%TYPE,
298: p_min_att_type igf_sp_stdnt_rel.min_attendance_type%TYPE,
299: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,
300: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
301: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE)
302: RETURN BOOLEAN

Line 299: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,

295: END get_person_number;
296:
297: FUNCTION check_eligibility ( p_person_id igf_sp_stdnt_rel.person_id%TYPE,
298: p_min_att_type igf_sp_stdnt_rel.min_attendance_type%TYPE,
299: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,
300: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
301: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE)
302: RETURN BOOLEAN
303: AS

Line 300: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,

296:
297: FUNCTION check_eligibility ( p_person_id igf_sp_stdnt_rel.person_id%TYPE,
298: p_min_att_type igf_sp_stdnt_rel.min_attendance_type%TYPE,
299: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,
300: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
301: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE)
302: RETURN BOOLEAN
303: AS
304: ------------------------------------------------------------------------------------

Line 301: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE)

297: FUNCTION check_eligibility ( p_person_id igf_sp_stdnt_rel.person_id%TYPE,
298: p_min_att_type igf_sp_stdnt_rel.min_attendance_type%TYPE,
299: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,
300: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
301: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE)
302: RETURN BOOLEAN
303: AS
304: ------------------------------------------------------------------------------------
305: --Created by : smanglm ( Oracle IDC)

Line 322: l_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE;

318: -- in the sponsor student relation. Moreover, the existing
319: -- comparison operators used for min.credit points and
320: -- Min. attendance type is changed.
321: -------------------------------------------------------------------------------------
322: l_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE;
323: l_min_attendance_type igf_sp_stdnt_rel.min_attendance_type%TYPE;
324: l_fte VARCHAR2 (10); --to be verified
325:
326: BEGIN

Line 323: l_min_attendance_type igf_sp_stdnt_rel.min_attendance_type%TYPE;

319: -- comparison operators used for min.credit points and
320: -- Min. attendance type is changed.
321: -------------------------------------------------------------------------------------
322: l_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE;
323: l_min_attendance_type igf_sp_stdnt_rel.min_attendance_type%TYPE;
324: l_fte VARCHAR2 (10); --to be verified
325:
326: BEGIN
327:

Line 456: FUNCTION recal_dis_gross_amt (p_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,

452: );
453: END IF;
454: END create_disb_dtl;
455:
456: FUNCTION recal_dis_gross_amt (p_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,
457: p_chk_elig VARCHAR2,
458: p_fee_cls_id igf_sp_std_fc.fee_cls_id%TYPE
459: )
460: RETURN NUMBER

Line 480: CURSOR c_stdnt_rel (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE)

476: --smadathi 17-May-2002 Bug 2369173. Division by 100 was incorporated where
477: -- pays only percent was involved in calculation.
478: -------------------------------------------------------------------------------------
479: -- cursor to find the tot_spnsr_amt
480: CURSOR c_stdnt_rel (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE)
481: IS
482: SELECT spstd.*, fmast.fund_code
483: FROM igf_sp_stdnt_rel_all spstd,
484: igf_aw_fund_mast_all fmast

Line 483: FROM igf_sp_stdnt_rel_all spstd,

479: -- cursor to find the tot_spnsr_amt
480: CURSOR c_stdnt_rel (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE)
481: IS
482: SELECT spstd.*, fmast.fund_code
483: FROM igf_sp_stdnt_rel_all spstd,
484: igf_aw_fund_mast_all fmast
485: WHERE spstd.spnsr_stdnt_id = cp_spnsr_stdnt_id
486: AND fmast.fund_id = spstd.fund_id;
487: rec_stdnt_rel c_stdnt_rel%ROWTYPE;

Line 490: CURSOR c_std_fc (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,

486: AND fmast.fund_id = spstd.fund_id;
487: rec_stdnt_rel c_stdnt_rel%ROWTYPE;
488:
489: -- cursor to get the charge at fee class
490: CURSOR c_std_fc (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,
491: cp_fee_cls_id igf_sp_std_fc.fee_cls_id%TYPE)
492: IS
493: SELECT *
494: FROM igf_sp_std_fc

Line 538: l_tot_spnsr_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;

534: );
535:
536: l_prg_attempt VARCHAR2(1);
537:
538: l_tot_spnsr_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
539:
540: l_msg_count NUMBER;
541: l_msg_data VARCHAR2(2000);
542: l_status BOOLEAN;

Line 547: l_n_eligible_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;

543:
544: l_v_fee_cal_type igs_ca_inst_all.cal_type%TYPE;
545: l_n_fee_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;
546: l_v_message_name fnd_new_messages.message_name%TYPE;
547: l_n_eligible_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
548: l_n_computed_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
549: l_n_new_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
550: l_n_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
551: l_n_final_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;

Line 548: l_n_computed_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;

544: l_v_fee_cal_type igs_ca_inst_all.cal_type%TYPE;
545: l_n_fee_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;
546: l_v_message_name fnd_new_messages.message_name%TYPE;
547: l_n_eligible_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
548: l_n_computed_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
549: l_n_new_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
550: l_n_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
551: l_n_final_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
552:

Line 549: l_n_new_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;

545: l_n_fee_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;
546: l_v_message_name fnd_new_messages.message_name%TYPE;
547: l_n_eligible_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
548: l_n_computed_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
549: l_n_new_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
550: l_n_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
551: l_n_final_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
552:
553: BEGIN

Line 550: l_n_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;

546: l_v_message_name fnd_new_messages.message_name%TYPE;
547: l_n_eligible_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
548: l_n_computed_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
549: l_n_new_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
550: l_n_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
551: l_n_final_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
552:
553: BEGIN
554: -- get the tot_spsnr_amt

Line 551: l_n_final_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;

547: l_n_eligible_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
548: l_n_computed_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
549: l_n_new_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
550: l_n_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
551: l_n_final_spns_amount igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
552:
553: BEGIN
554: -- get the tot_spsnr_amt
555: OPEN c_stdnt_rel (p_spnsr_stdnt_id);

Line 960: PROCEDURE create_aw_award (p_fund_id igf_sp_stdnt_rel.fund_id%TYPE,

956: CLOSE c_disb_num;
957: RETURN l_disb_num;
958: END get_disb_num;
959:
960: PROCEDURE create_aw_award (p_fund_id igf_sp_stdnt_rel.fund_id%TYPE,
961: p_base_id igf_sp_stdnt_rel.base_id%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,

Line 961: p_base_id igf_sp_stdnt_rel.base_id%TYPE,

957: RETURN l_disb_num;
958: END get_disb_num;
959:
960: PROCEDURE create_aw_award (p_fund_id igf_sp_stdnt_rel.fund_id%TYPE,
961: p_base_id igf_sp_stdnt_rel.base_id%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,

Line 962: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,

958: END get_disb_num;
959:
960: PROCEDURE create_aw_award (p_fund_id igf_sp_stdnt_rel.fund_id%TYPE,
961: p_base_id igf_sp_stdnt_rel.base_id%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,

Line 963: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE,

959:
960: PROCEDURE create_aw_award (p_fund_id igf_sp_stdnt_rel.fund_id%TYPE,
961: p_base_id igf_sp_stdnt_rel.base_id%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,

Line 965: p_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,

961: p_base_id igf_sp_stdnt_rel.base_id%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

Line 999: -- cursor to see that tot_spnsr_amount is present in the igf_sp_stdnt_rel table

995: -- was removed off from the message IGF_SP_CREATE_AWARD.
996: --vvutukur 15-apr-2002 Added cursor cur_include_as_plncrd to pass the show_on_bill selected from igs_fi_fund_mast
997: -- of particular fund_id. Done for bug#2293676.
998: -------------------------------------------------------------------------------------
999: -- cursor to see that tot_spnsr_amount is present in the igf_sp_stdnt_rel table
1000: CURSOR c_stdnt_rel (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE)
1001: IS
1002: SELECT *
1003: FROM igf_sp_stdnt_rel

Line 1000: CURSOR c_stdnt_rel (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE)

996: --vvutukur 15-apr-2002 Added cursor cur_include_as_plncrd to pass the show_on_bill selected from igs_fi_fund_mast
997: -- of particular fund_id. Done for bug#2293676.
998: -------------------------------------------------------------------------------------
999: -- cursor to see that tot_spnsr_amount is present in the igf_sp_stdnt_rel table
1000: CURSOR c_stdnt_rel (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE)
1001: IS
1002: SELECT *
1003: FROM igf_sp_stdnt_rel
1004: WHERE spnsr_stdnt_id = cp_spnsr_stdnt_id;

Line 1003: FROM igf_sp_stdnt_rel

999: -- cursor to see that tot_spnsr_amount is present in the igf_sp_stdnt_rel table
1000: CURSOR c_stdnt_rel (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE)
1001: IS
1002: SELECT *
1003: FROM igf_sp_stdnt_rel
1004: WHERE spnsr_stdnt_id = cp_spnsr_stdnt_id;
1005:
1006: rec_stdnt_rel c_stdnt_rel%ROWTYPE;
1007:

Line 1009: CURSOR c_std_fc (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE)

1005:
1006: rec_stdnt_rel c_stdnt_rel%ROWTYPE;
1007:
1008: -- cursor to fetch the FC record
1009: CURSOR c_std_fc (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE)
1010: IS
1011: SELECT *
1012: FROM igf_sp_std_fc
1013: WHERE spnsr_stdnt_id = cp_spnsr_stdnt_id;

Line 1023: l_n_tot_spns_amt igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;

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:
1025: BEGIN
1026: SAVEPOINT sp_award;
1027: --Get the show-on-bill value from igs_fi_fund_mast for passed fund_id.

Line 1029: -- check if tot_spnsr_amount is present in the igf_sp_stdnt_rel table

1025: BEGIN
1026: SAVEPOINT sp_award;
1027: --Get the show-on-bill value from igs_fi_fund_mast for passed fund_id.
1028: l_include_as_plncrd := get_show_on_bill(p_fund_id);
1029: -- check if tot_spnsr_amount is present in the igf_sp_stdnt_rel table
1030: OPEN c_stdnt_rel(p_spnsr_stdnt_id);
1031: FETCH c_stdnt_rel INTO rec_stdnt_rel;
1032: CLOSE c_stdnt_rel;
1033:

Line 1327: p_base_id igf_sp_stdnt_rel.base_id%TYPE,

1323: END create_aw_award;
1324:
1325: PROCEDURE loop_thru_spnsr_dtl_pvt (p_person_id igs_pe_person.person_id%TYPE,
1326: p_award_type VARCHAR2,
1327: p_base_id igf_sp_stdnt_rel.base_id%TYPE,
1328: p_fund_id igf_sp_stdnt_rel.base_id%TYPE,
1329: p_min_attendance_type igf_sp_stdnt_rel.min_attendance_type%TYPE,
1330: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,
1331: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,

Line 1328: p_fund_id igf_sp_stdnt_rel.base_id%TYPE,

1324:
1325: PROCEDURE loop_thru_spnsr_dtl_pvt (p_person_id igs_pe_person.person_id%TYPE,
1326: p_award_type VARCHAR2,
1327: p_base_id igf_sp_stdnt_rel.base_id%TYPE,
1328: p_fund_id igf_sp_stdnt_rel.base_id%TYPE,
1329: p_min_attendance_type igf_sp_stdnt_rel.min_attendance_type%TYPE,
1330: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,
1331: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
1332: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE,

Line 1329: p_min_attendance_type igf_sp_stdnt_rel.min_attendance_type%TYPE,

1325: PROCEDURE loop_thru_spnsr_dtl_pvt (p_person_id igs_pe_person.person_id%TYPE,
1326: p_award_type VARCHAR2,
1327: p_base_id igf_sp_stdnt_rel.base_id%TYPE,
1328: p_fund_id igf_sp_stdnt_rel.base_id%TYPE,
1329: p_min_attendance_type igf_sp_stdnt_rel.min_attendance_type%TYPE,
1330: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,
1331: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
1332: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE,
1333: p_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,

Line 1330: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,

1326: p_award_type VARCHAR2,
1327: p_base_id igf_sp_stdnt_rel.base_id%TYPE,
1328: p_fund_id igf_sp_stdnt_rel.base_id%TYPE,
1329: p_min_attendance_type igf_sp_stdnt_rel.min_attendance_type%TYPE,
1330: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,
1331: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
1332: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE,
1333: p_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,
1334: p_fee_type igf_aw_fund_mast.fee_type%TYPE,

Line 1331: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,

1327: p_base_id igf_sp_stdnt_rel.base_id%TYPE,
1328: p_fund_id igf_sp_stdnt_rel.base_id%TYPE,
1329: p_min_attendance_type igf_sp_stdnt_rel.min_attendance_type%TYPE,
1330: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,
1331: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
1332: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE,
1333: p_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,
1334: p_fee_type igf_aw_fund_mast.fee_type%TYPE,
1335: p_n_total_spnsr_amt igf_sp_stdnt_rel.tot_spnsr_amount%TYPE

Line 1332: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE,

1328: p_fund_id igf_sp_stdnt_rel.base_id%TYPE,
1329: p_min_attendance_type igf_sp_stdnt_rel.min_attendance_type%TYPE,
1330: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,
1331: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
1332: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE,
1333: p_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,
1334: p_fee_type igf_aw_fund_mast.fee_type%TYPE,
1335: p_n_total_spnsr_amt igf_sp_stdnt_rel.tot_spnsr_amount%TYPE
1336: )

Line 1333: p_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,

1329: p_min_attendance_type igf_sp_stdnt_rel.min_attendance_type%TYPE,
1330: p_min_credit_points igf_sp_stdnt_rel.min_credit_points%TYPE,
1331: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
1332: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE,
1333: p_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,
1334: p_fee_type igf_aw_fund_mast.fee_type%TYPE,
1335: p_n_total_spnsr_amt igf_sp_stdnt_rel.tot_spnsr_amount%TYPE
1336: )
1337: AS

Line 1335: p_n_total_spnsr_amt igf_sp_stdnt_rel.tot_spnsr_amount%TYPE

1331: p_ld_cal_type igf_sp_stdnt_rel.ld_cal_type%TYPE,
1332: p_ld_sequence_number igf_sp_stdnt_rel.ld_sequence_number%TYPE,
1333: p_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE,
1334: p_fee_type igf_aw_fund_mast.fee_type%TYPE,
1335: p_n_total_spnsr_amt igf_sp_stdnt_rel.tot_spnsr_amount%TYPE
1336: )
1337: AS
1338: ------------------------------------------------------------------------------------
1339: --Created by : smanglm ( Oracle IDC)

Line 1369: CURSOR c_manual_update (cp_base_id igf_sp_stdnt_rel.base_id%TYPE,

1365: -------------------------------------------------------------------------------------
1366: l_chk_elig VARCHAR2(1);
1367:
1368: -- cursor to see the value for the manual update
1369: CURSOR c_manual_update (cp_base_id igf_sp_stdnt_rel.base_id%TYPE,
1370: cp_fund_id igf_sp_stdnt_rel.fund_id%TYPE,
1371: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1372: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1373: )

Line 1370: cp_fund_id igf_sp_stdnt_rel.fund_id%TYPE,

1366: l_chk_elig VARCHAR2(1);
1367:
1368: -- cursor to see the value for the manual update
1369: CURSOR c_manual_update (cp_base_id igf_sp_stdnt_rel.base_id%TYPE,
1370: cp_fund_id igf_sp_stdnt_rel.fund_id%TYPE,
1371: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1372: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1373: )
1374: IS

Line 1412: CURSOR c_igf_sp_std_fc (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE)

1408: );
1409:
1410: rec_aw_awd_disb c_aw_awd_disb%ROWTYPE;
1411:
1412: CURSOR c_igf_sp_std_fc (cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE)
1413: IS
1414: SELECT *
1415: FROM igf_sp_std_fc
1416: WHERE spnsr_stdnt_id = cp_spnsr_stdnt_id;

Line 1432: l_n_tot_spns_amt igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;

1428: l_v_msg_null l_msg_tab;
1429:
1430: i BINARY_INTEGER;
1431:
1432: l_n_tot_spns_amt igf_sp_stdnt_rel.tot_spnsr_amount%TYPE;
1433:
1434: BEGIN -- begin for loop_thru_spnsr_dtl_pvt
1435:
1436: l_include_as_plncrd := get_show_on_bill(p_fund_id);

Line 2047: FROM igf_sp_stdnt_rel rel,

2043: SELECT rel.*,
2044: fund.fund_code,
2045: fund.description fund_desc,
2046: fund.fee_type
2047: FROM igf_sp_stdnt_rel rel,
2048: igf_aw_fund_mast fund
2049: WHERE rel.fund_id = fund.fund_id
2050: AND rel.fund_id = cp_fund_id
2051: AND fund.discontinue_fund <> cp_v_disc_fund

Line 2157: p_fund_id IN igf_sp_stdnt_rel.fund_id%TYPE,

2153: p_award_year IN VARCHAR2,
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