DBA Data[Home] [Help]

APPS.IGS_FI_VAL_FAS dependencies on IGS_FI_FEE_AS_ALL

Line 616: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,

612: -- masehgal 17-Jan-2002 ENH # 2170429
613: -- Obsoletion of SPONSOR_CD related Parameters from Function FINP_VAL_FAS_UPD
614:
615: FUNCTION finp_val_fas_upd(
616: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,

Line 617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,

613: -- Obsoletion of SPONSOR_CD related Parameters from Function FINP_VAL_FAS_UPD
614:
615: FUNCTION finp_val_fas_upd(
616: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,

Line 618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,

614:
615: FUNCTION finp_val_fas_upd(
616: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,

Line 619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,

615: FUNCTION finp_val_fas_upd(
616: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,

Line 620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,

616: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,

Line 621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,

617: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,

Line 622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,

618: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,

Line 623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,

619: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,

Line 624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,

620: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,

Line 625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,

621: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,

Line 626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,

622: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,

Line 627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,

623: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,

Line 628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,

624: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,

Line 629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,

625: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,

Line 630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,

626: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,

Line 631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,

627: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,

Line 632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,

628: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,

Line 633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,

629: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,

Line 634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,

630: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,

Line 635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,

631: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,

Line 636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,

632: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,

Line 637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,

633: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,

Line 638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,

634: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,

Line 639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,

635: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,

Line 640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,

636: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,

Line 641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,

637: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,

Line 642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,

638: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,

Line 643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,

639: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
647: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,

Line 644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,

640: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
647: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
648: p_message_name OUT NOCOPY VARCHAR2 )

Line 645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,

641: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
647: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
648: p_message_name OUT NOCOPY VARCHAR2 )
649: RETURN BOOLEAN AS

Line 646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,

642: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
647: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
648: p_message_name OUT NOCOPY VARCHAR2 )
649: RETURN BOOLEAN AS
650: gv_other_detail VARCHAR2(255);

Line 647: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,

643: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
644: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
645: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
646: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
647: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
648: p_message_name OUT NOCOPY VARCHAR2 )
649: RETURN BOOLEAN AS
650: gv_other_detail VARCHAR2(255);
651: BEGIN -- finp_val_fas_upd