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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 ,
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 )
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
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);
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