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_ALL

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