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.IGS_FI_GEN_002 dependencies on IGS_FI_FEE_RET_SCHD

Line 770: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,

766: --
767: --Removed the procedure finp_ins_fps_hist as part of SFCR005 Clean Up Build. Bug#2531390.
768: --
769: PROCEDURE finp_ins_frtns_hist(
770: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,
771: p_fee_ci_sequence_number IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
772: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
773: p_sequence_number IN IGS_FI_FEE_RET_SCHD.sequence_number%TYPE ,
774: p_new_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,

Line 771: p_fee_ci_sequence_number IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,

767: --Removed the procedure finp_ins_fps_hist as part of SFCR005 Clean Up Build. Bug#2531390.
768: --
769: PROCEDURE finp_ins_frtns_hist(
770: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,
771: p_fee_ci_sequence_number IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
772: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
773: p_sequence_number IN IGS_FI_FEE_RET_SCHD.sequence_number%TYPE ,
774: p_new_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
775: p_old_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,

Line 772: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,

768: --
769: PROCEDURE finp_ins_frtns_hist(
770: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,
771: p_fee_ci_sequence_number IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
772: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
773: p_sequence_number IN IGS_FI_FEE_RET_SCHD.sequence_number%TYPE ,
774: p_new_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
775: p_old_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
776: p_new_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,

Line 773: p_sequence_number IN IGS_FI_FEE_RET_SCHD.sequence_number%TYPE ,

769: PROCEDURE finp_ins_frtns_hist(
770: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,
771: p_fee_ci_sequence_number IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
772: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
773: p_sequence_number IN IGS_FI_FEE_RET_SCHD.sequence_number%TYPE ,
774: p_new_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
775: p_old_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
776: p_new_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
777: p_old_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,

Line 774: p_new_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,

770: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,
771: p_fee_ci_sequence_number IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
772: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
773: p_sequence_number IN IGS_FI_FEE_RET_SCHD.sequence_number%TYPE ,
774: p_new_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
775: p_old_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
776: p_new_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
777: p_old_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
778: p_new_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,

Line 775: p_old_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,

771: p_fee_ci_sequence_number IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
772: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
773: p_sequence_number IN IGS_FI_FEE_RET_SCHD.sequence_number%TYPE ,
774: p_new_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
775: p_old_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
776: p_new_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
777: p_old_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
778: p_new_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
779: p_old_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,

Line 776: p_new_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,

772: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
773: p_sequence_number IN IGS_FI_FEE_RET_SCHD.sequence_number%TYPE ,
774: p_new_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
775: p_old_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
776: p_new_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
777: p_old_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
778: p_new_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
779: p_old_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
780: p_new_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,

Line 777: p_old_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,

773: p_sequence_number IN IGS_FI_FEE_RET_SCHD.sequence_number%TYPE ,
774: p_new_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
775: p_old_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
776: p_new_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
777: p_old_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
778: p_new_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
779: p_old_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
780: p_new_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
781: p_old_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,

Line 778: p_new_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,

774: p_new_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
775: p_old_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
776: p_new_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
777: p_old_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
778: p_new_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
779: p_old_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
780: p_new_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
781: p_old_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
782: p_new_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,

Line 779: p_old_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,

775: p_old_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
776: p_new_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
777: p_old_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
778: p_new_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
779: p_old_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
780: p_new_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
781: p_old_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
782: p_new_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
783: p_old_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,

Line 780: p_new_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,

776: p_new_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
777: p_old_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
778: p_new_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
779: p_old_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
780: p_new_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
781: p_old_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
782: p_new_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
783: p_old_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
784: p_new_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,

Line 781: p_old_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,

777: p_old_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
778: p_new_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
779: p_old_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
780: p_new_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
781: p_old_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
782: p_new_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
783: p_old_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
784: p_new_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
785: p_old_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,

Line 782: p_new_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,

778: p_new_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
779: p_old_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
780: p_new_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
781: p_old_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
782: p_new_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
783: p_old_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
784: p_new_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
785: p_old_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
786: p_new_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,

Line 783: p_old_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,

779: p_old_schedule_number IN IGS_FI_FEE_RET_SCHD.schedule_number%TYPE ,
780: p_new_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
781: p_old_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
782: p_new_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
783: p_old_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
784: p_new_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
785: p_old_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
786: p_new_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
787: p_old_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,

Line 784: p_new_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,

780: p_new_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
781: p_old_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
782: p_new_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
783: p_old_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
784: p_new_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
785: p_old_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
786: p_new_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
787: p_old_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
788: p_new_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,

Line 785: p_old_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,

781: p_old_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
782: p_new_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
783: p_old_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
784: p_new_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
785: p_old_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
786: p_new_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
787: p_old_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
788: p_new_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
789: p_old_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,

Line 786: p_new_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,

782: p_new_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
783: p_old_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
784: p_new_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
785: p_old_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
786: p_new_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
787: p_old_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
788: p_new_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
789: p_old_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
790: p_new_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE ,

Line 787: p_old_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,

783: p_old_dai_sequence_number IN IGS_FI_FEE_RET_SCHD.dai_sequence_number%TYPE ,
784: p_new_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
785: p_old_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
786: p_new_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
787: p_old_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
788: p_new_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
789: p_old_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
790: p_new_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE ,
791: p_old_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE )

Line 788: p_new_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,

784: p_new_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
785: p_old_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
786: p_new_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
787: p_old_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
788: p_new_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
789: p_old_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
790: p_new_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE ,
791: p_old_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE )
792: AS

Line 789: p_old_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,

785: p_old_retention_percentage IN IGS_FI_FEE_RET_SCHD.retention_percentage%TYPE ,
786: p_new_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
787: p_old_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
788: p_new_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
789: p_old_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
790: p_new_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE ,
791: p_old_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE )
792: AS
793: /*----------------------------------------------------------------------------

Line 790: p_new_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE ,

786: p_new_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
787: p_old_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
788: p_new_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
789: p_old_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
790: p_new_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE ,
791: p_old_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE )
792: AS
793: /*----------------------------------------------------------------------------
794: || Created By :

Line 791: p_old_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE )

787: p_old_retention_amount IN IGS_FI_FEE_RET_SCHD.retention_amount%TYPE ,
788: p_new_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
789: p_old_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
790: p_new_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE ,
791: p_old_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE )
792: AS
793: /*----------------------------------------------------------------------------
794: || Created By :
795: || Created On :

Line 812: -- Create a history for a IGS_FI_FEE_RET_SCHD record.

808: r_frtnsh IGS_FI_F_RET_SCHD_HT%ROWTYPE;
809: v_create_history BOOLEAN := FALSE;
810: l_n_org_id IGS_FI_F_RET_SCHD_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;
811: BEGIN
812: -- Create a history for a IGS_FI_FEE_RET_SCHD record.
813: -- Check if any of the non-primary key fields have been changed
814: -- and set the flag v_create_history to indicate so.
815: IF NVL(p_new_fee_type, 'NULL') <> NVL(p_old_fee_type, 'NULL') THEN
816: r_frtnsh.FEE_TYPE := p_old_fee_type;