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_001 dependencies on IGS_FI_FEE_RET_SCHD

Line 980: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,

976: return NULL;
977: END finp_get_fps_start_dt;
978: --
979: FUNCTION finp_get_frtns_end_dt(
980: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,
981: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
982: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
983: p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
984: p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,

Line 981: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,

977: END finp_get_fps_start_dt;
978: --
979: FUNCTION finp_get_frtns_end_dt(
980: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,
981: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
982: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
983: p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
984: p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
985: p_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,

Line 982: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,

978: --
979: FUNCTION finp_get_frtns_end_dt(
980: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,
981: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
982: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
983: p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
984: p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
985: p_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
986: p_dai_sequence_num IN NUMBER )

Line 983: p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,

979: FUNCTION finp_get_frtns_end_dt(
980: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,
981: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
982: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
983: p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
984: p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
985: p_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
986: p_dai_sequence_num IN NUMBER )
987: RETURN DATE AS

Line 984: p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,

980: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,
981: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
982: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
983: p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
984: p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
985: p_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
986: p_dai_sequence_num IN NUMBER )
987: RETURN DATE AS
988:

Line 985: p_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,

981: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
982: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
983: p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
984: p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
985: p_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
986: p_dai_sequence_num IN NUMBER )
987: RETURN DATE AS
988:
989: BEGIN

Line 993: CURSOR c_frtns (cp_fee_cal_type IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE,

989: BEGIN
990: DECLARE
991: -- this cursor finds the next retention schedule entry
992: -- date alias instance value
993: CURSOR c_frtns (cp_fee_cal_type IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE,
994: cp_fee_ci_sequence_num IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,
995: cp_s_relation_type IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE,
996: cp_fee_type IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,
997: cp_fee_cat IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE,

Line 994: cp_fee_ci_sequence_num IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,

990: DECLARE
991: -- this cursor finds the next retention schedule entry
992: -- date alias instance value
993: CURSOR c_frtns (cp_fee_cal_type IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE,
994: cp_fee_ci_sequence_num IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,
995: cp_s_relation_type IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE,
996: cp_fee_type IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,
997: cp_fee_cat IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE,
998: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE) IS

Line 995: cp_s_relation_type IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE,

991: -- this cursor finds the next retention schedule entry
992: -- date alias instance value
993: CURSOR c_frtns (cp_fee_cal_type IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE,
994: cp_fee_ci_sequence_num IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,
995: cp_s_relation_type IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE,
996: cp_fee_type IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,
997: cp_fee_cat IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE,
998: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE) IS
999: SELECT daiv.alias_val

Line 996: cp_fee_type IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,

992: -- date alias instance value
993: CURSOR c_frtns (cp_fee_cal_type IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE,
994: cp_fee_ci_sequence_num IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,
995: cp_s_relation_type IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE,
996: cp_fee_type IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,
997: cp_fee_cat IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE,
998: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE) IS
999: SELECT daiv.alias_val
1000: FROM IGS_FI_FEE_RET_SCHD frtns,

Line 997: cp_fee_cat IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE,

993: CURSOR c_frtns (cp_fee_cal_type IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE,
994: cp_fee_ci_sequence_num IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,
995: cp_s_relation_type IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE,
996: cp_fee_type IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,
997: cp_fee_cat IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE,
998: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE) IS
999: SELECT daiv.alias_val
1000: FROM IGS_FI_FEE_RET_SCHD frtns,
1001: IGS_CA_DA_INST_V daiv

Line 1000: FROM IGS_FI_FEE_RET_SCHD frtns,

996: cp_fee_type IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,
997: cp_fee_cat IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE,
998: cp_alias_val IGS_CA_DA_INST_V.alias_val%TYPE) IS
999: SELECT daiv.alias_val
1000: FROM IGS_FI_FEE_RET_SCHD frtns,
1001: IGS_CA_DA_INST_V daiv
1002: WHERE frtns.fee_cal_type = cp_fee_cal_type AND
1003: frtns.fee_ci_sequence_number = cp_fee_ci_sequence_num AND
1004: frtns.s_relation_type = cp_s_relation_type AND

Line 1016: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE,

1012: ORDER BY daiv.alias_val ASC;
1013: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1014: -------------------------------------------------------------------------------
1015: FUNCTION finl_get_ass_end_dt(
1016: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE,
1017: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,
1018: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE,
1019: p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,
1020: p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE)

Line 1017: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,

1013: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
1014: -------------------------------------------------------------------------------
1015: FUNCTION finl_get_ass_end_dt(
1016: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE,
1017: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,
1018: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE,
1019: p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,
1020: p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE)
1021: RETURN DATE AS

Line 1018: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE,

1014: -------------------------------------------------------------------------------
1015: FUNCTION finl_get_ass_end_dt(
1016: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE,
1017: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,
1018: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE,
1019: p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,
1020: p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE)
1021: RETURN DATE AS
1022: BEGIN

Line 1019: p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,

1015: FUNCTION finl_get_ass_end_dt(
1016: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE,
1017: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,
1018: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE,
1019: p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,
1020: p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE)
1021: RETURN DATE AS
1022: BEGIN
1023: DECLARE

Line 1020: p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE)

1016: p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE,
1017: p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE,
1018: p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE,
1019: p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE,
1020: p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE)
1021: RETURN DATE AS
1022: BEGIN
1023: DECLARE
1024: -- this cursor finds the fee type cal instance end date alias instance value