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.

[Home] [Help]

APPS.IGS_FI_GEN_002 dependencies on IGS_FI_FEE_TYPE_ALL

Line 664: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,

660: PROCEDURE finp_ins_fcfl_hist(
661: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE ,
662: p_fee_cal_type IN IGS_CA_TYPE.CAL_TYPE%TYPE ,
663: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
664: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
665: p_new_fee_liability_status IN VARCHAR2 ,
666: p_old_fee_liability_status IN VARCHAR2 ,
667: p_new_start_dt_alias IN IGS_CA_DA.DT_ALIAS%TYPE ,
668: p_old_start_dt_alias IN IGS_CA_DA.DT_ALIAS%TYPE ,

Line 1038: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,

1034: APP_EXCEPTION.RAISE_EXCEPTION;
1035: END finp_ins_ftci_hist;
1036: --
1037: PROCEDURE finp_ins_ft_hist(
1038: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
1039: p_new_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
1040: p_old_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
1041: p_new_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1042: p_old_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,

Line 1039: p_new_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,

1035: END finp_ins_ftci_hist;
1036: --
1037: PROCEDURE finp_ins_ft_hist(
1038: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
1039: p_new_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
1040: p_old_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
1041: p_new_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1042: p_old_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1043: p_new_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,

Line 1040: p_old_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,

1036: --
1037: PROCEDURE finp_ins_ft_hist(
1038: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
1039: p_new_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
1040: p_old_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
1041: p_new_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1042: p_old_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1043: p_new_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1044: p_old_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,

Line 1041: p_new_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,

1037: PROCEDURE finp_ins_ft_hist(
1038: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
1039: p_new_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
1040: p_old_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
1041: p_new_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1042: p_old_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1043: p_new_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1044: p_old_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1045: p_new_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,

Line 1042: p_old_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,

1038: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
1039: p_new_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
1040: p_old_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
1041: p_new_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1042: p_old_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1043: p_new_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1044: p_old_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1045: p_new_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1046: p_old_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,

Line 1043: p_new_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,

1039: p_new_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
1040: p_old_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
1041: p_new_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1042: p_old_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1043: p_new_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1044: p_old_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1045: p_new_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1046: p_old_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1047: p_new_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,

Line 1044: p_old_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,

1040: p_old_s_fee_type IN IGS_FI_FEE_TYPE_ALL.s_fee_type%TYPE ,
1041: p_new_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1042: p_old_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1043: p_new_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1044: p_old_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1045: p_new_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1046: p_old_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1047: p_new_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1048: p_old_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,

Line 1045: p_new_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,

1041: p_new_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1042: p_old_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1043: p_new_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1044: p_old_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1045: p_new_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1046: p_old_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1047: p_new_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1048: p_old_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1049: p_new_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865

Line 1046: p_old_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,

1042: p_old_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
1043: p_new_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1044: p_old_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1045: p_new_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1046: p_old_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1047: p_new_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1048: p_old_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1049: p_new_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1050: p_old_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865

Line 1047: p_new_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,

1043: p_new_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1044: p_old_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1045: p_new_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1046: p_old_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1047: p_new_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1048: p_old_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1049: p_new_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1050: p_old_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1051: p_new_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,

Line 1048: p_old_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,

1044: p_old_description IN IGS_FI_FEE_TYPE_ALL.description%TYPE ,
1045: p_new_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1046: p_old_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1047: p_new_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1048: p_old_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1049: p_new_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1050: p_old_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1051: p_new_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1052: p_old_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,

Line 1049: p_new_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865

1045: p_new_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1046: p_old_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1047: p_new_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1048: p_old_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1049: p_new_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1050: p_old_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1051: p_new_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1052: p_old_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1053: p_new_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,

Line 1050: p_old_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865

1046: p_old_optional_payment_ind IN IGS_FI_FEE_TYPE_ALL.optional_payment_ind%TYPE ,
1047: p_new_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1048: p_old_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1049: p_new_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1050: p_old_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1051: p_new_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1052: p_old_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1053: p_new_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1054: p_old_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,

Line 1051: p_new_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,

1047: p_new_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1048: p_old_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1049: p_new_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1050: p_old_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1051: p_new_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1052: p_old_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1053: p_new_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1054: p_old_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1055: p_new_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,

Line 1052: p_old_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,

1048: p_old_closed_ind IN IGS_FI_FEE_TYPE_ALL.closed_ind%TYPE ,
1049: p_new_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1050: p_old_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1051: p_new_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1052: p_old_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1053: p_new_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1054: p_old_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1055: p_new_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
1056: p_old_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,

Line 1053: p_new_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,

1049: p_new_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1050: p_old_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1051: p_new_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1052: p_old_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1053: p_new_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1054: p_old_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1055: p_new_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
1056: p_old_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
1057: p_new_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE ,

Line 1054: p_old_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,

1050: p_old_fee_class IN IGS_FI_FEE_TYPE_ALL.fee_class%TYPE, --for Bug 2175865
1051: p_new_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1052: p_old_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1053: p_new_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1054: p_old_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1055: p_new_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
1056: p_old_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
1057: p_new_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE ,
1058: p_old_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE )

Line 1055: p_new_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,

1051: p_new_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1052: p_old_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1053: p_new_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1054: p_old_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1055: p_new_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
1056: p_old_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
1057: p_new_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE ,
1058: p_old_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE )
1059: AS

Line 1056: p_old_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,

1052: p_old_designated_payment_flag IN igs_fi_fee_type_all.designated_payment_flag%TYPE,
1053: p_new_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1054: p_old_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1055: p_new_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
1056: p_old_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
1057: p_new_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE ,
1058: p_old_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE )
1059: AS
1060: /*----------------------------------------------------------------------------

Line 1057: p_new_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE ,

1053: p_new_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1054: p_old_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1055: p_new_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
1056: p_old_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
1057: p_new_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE ,
1058: p_old_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE )
1059: AS
1060: /*----------------------------------------------------------------------------
1061: || Created By :

Line 1058: p_old_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE )

1054: p_old_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
1055: p_new_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
1056: p_old_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
1057: p_new_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE ,
1058: p_old_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE )
1059: AS
1060: /*----------------------------------------------------------------------------
1061: || Created By :
1062: || Created On :