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 IGS_FI_GEN_GL

Line 603: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

599: l_rowid := NULL;
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,

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 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 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 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 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 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 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 823: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

819: fnd_file.put_line(fnd_file.log,l_msg_str_1);
820: l_rowid := NULL;
821: l_fee_cls_id := NULL;
822: BEGIN
823: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
824: igf_sp_fc_pkg.insert_row (
825: x_mode => 'R',
826: x_rowid => l_rowid,
827: x_fee_cls_id => l_fee_cls_id,

Line 831: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_fc.max_amount)

827: x_fee_cls_id => l_fee_cls_id,
828: x_fund_id => l_fund_id,
829: x_fee_class => l_c_igf_sp_fc.fee_class,
830: x_fee_percent => l_c_igf_sp_fc.fee_percent,
831: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_fc.max_amount)
832: );
833: EXCEPTION
834: WHEN OTHERS THEN
835: -- rolls back to the save point

Line 864: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

860: fnd_file.put_line(fnd_file.log,l_msg_str_1);
861: l_rowid := NULL;
862: l_fee_cls_prg_id := NULL;
863: BEGIN
864: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
865: igf_sp_prg_pkg.insert_row (
866: x_mode => 'R',
867: x_rowid => l_rowid,
868: x_fee_cls_prg_id => l_fee_cls_prg_id,

Line 873: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_prg.max_amount)

869: x_fee_cls_id => l_fee_cls_id,
870: x_course_cd => l_c_igf_sp_prg.course_cd,
871: x_version_number => l_c_igf_sp_prg.version_number,
872: x_fee_percent => l_c_igf_sp_prg.fee_percent,
873: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_prg.max_amount)
874: );
875: EXCEPTION
876: WHEN OTHERS THEN
877: -- rolls back to the save point

Line 902: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

898: fnd_file.put_line(fnd_file.log,l_msg_str_1);
899: l_rowid := NULL;
900: l_fee_cls_unit_id := NULL;
901: BEGIN
902: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
903: igf_sp_unit_pkg.insert_row (
904: x_mode => 'R',
905: x_rowid => l_rowid,
906: x_fee_cls_unit_id => l_fee_cls_unit_id,

Line 910: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_unit.max_amount)

906: x_fee_cls_unit_id => l_fee_cls_unit_id,
907: x_fee_cls_prg_id => l_fee_cls_prg_id,
908: x_unit_cd => l_c_igf_sp_unit.unit_cd,
909: x_version_number => l_c_igf_sp_unit.version_number,
910: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_unit.max_amount)
911: );
912: EXCEPTION
913: WHEN OTHERS THEN
914: -- rolls back to the save point

Line 1182: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

1178: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1179: l_spnsr_stdnt_id := NULL;
1180: l_rowid := NULL;
1181: BEGIN
1182: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1183: igf_sp_stdnt_rel_pkg.insert_row (
1184: x_mode => 'R',
1185: x_rowid => l_rowid,
1186: x_spnsr_stdnt_id => l_spnsr_stdnt_id,

Line 1192: x_tot_spnsr_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_stdnt_rel.tot_spnsr_amount),

1188: x_base_id => l_base_id,
1189: x_person_id => l_c_igf_sp_stdnt_rel.person_id,
1190: x_ld_cal_type => l_c_igf_aw_cal_rel.sc_cal_type,
1191: x_ld_sequence_number => l_c_igf_aw_cal_rel.sc_sequence_number,
1192: x_tot_spnsr_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_stdnt_rel.tot_spnsr_amount),
1193: x_min_credit_points => l_c_igf_sp_stdnt_rel.min_credit_points,
1194: x_min_attendance_type => l_c_igf_sp_stdnt_rel.min_attendance_type
1195: );
1196: EXCEPTION

Line 1224: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

1220: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1221: l_rowid := NULL;
1222: l_fee_cls_id := NULL;
1223: BEGIN
1224: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1225: igf_sp_std_fc_pkg.insert_row (
1226: x_mode => 'R',
1227: x_rowid => l_rowid,
1228: x_fee_cls_id => l_fee_cls_id,

Line 1232: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_fc.max_amount)

1228: x_fee_cls_id => l_fee_cls_id,
1229: x_spnsr_stdnt_id => l_spnsr_stdnt_id,
1230: x_fee_class => l_c_igf_sp_std_fc.fee_class,
1231: x_fee_percent => l_c_igf_sp_std_fc.fee_percent,
1232: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_fc.max_amount)
1233: );
1234: EXCEPTION
1235: WHEN OTHERS THEN
1236: -- rolls back to the save point

Line 1264: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

1260: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1261: l_fee_cls_prg_id := NULL;
1262: l_rowid := NULL;
1263: BEGIN
1264: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1265: igf_sp_std_prg_pkg.insert_row (
1266: x_mode => 'R',
1267: x_rowid => l_rowid,
1268: x_fee_cls_prg_id => l_fee_cls_prg_id,

Line 1273: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_prg.max_amount)

1269: x_fee_cls_id => l_fee_cls_id,
1270: x_course_cd => l_c_igf_sp_std_prg.course_cd,
1271: x_version_number => l_c_igf_sp_std_prg.version_number,
1272: x_fee_percent => l_c_igf_sp_std_prg.fee_percent,
1273: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_prg.max_amount)
1274: );
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: -- rolls back to the save point

Line 1301: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

1297: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1298: l_fee_cls_unit_id := NULL;
1299: l_rowid := NULL;
1300: BEGIN
1301: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1302: igf_sp_std_unit_pkg.insert_row (
1303: x_mode => 'R',
1304: x_rowid => l_rowid,
1305: x_fee_cls_unit_id => l_fee_cls_unit_id,

Line 1309: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_unit.max_amount)

1305: x_fee_cls_unit_id => l_fee_cls_unit_id,
1306: x_fee_cls_prg_id => l_fee_cls_prg_id,
1307: x_unit_cd => l_c_igf_sp_std_unit.unit_cd,
1308: x_version_number => l_c_igf_sp_std_unit.version_number,
1309: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_unit.max_amount)
1310: );
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: -- rolls back to the save point