APPS.IGS_FI_VAL_FRTNS dependencies on IGS_FI_FEE_RET_SCHD

Line 24: -- Validate if IGS_FI_FEE_RET_SCHD records can be created.

20: p_message_name OUT NOCOPY VARCHAR2 )
21: RETURN BOOLEAN AS
22: gv_other_detail VARCHAR2(255);
23: BEGIN -- finp_val_frtns_creat
24: -- Validate if IGS_FI_FEE_RET_SCHD records can be created.
25: -- When defined at FTCI level, they cannot also be
26: -- defined at FCFL level and vice-versa.
27: DECLARE
28: CURSOR c_frtns (

Line 29: cp_s_relation_type IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE) IS

25: -- When defined at FTCI level, they cannot also be
26: -- defined at FCFL level and vice-versa.
27: DECLARE
28: CURSOR c_frtns (
29: cp_s_relation_type IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE) IS
30: SELECT 'x'
31: FROM IGS_FI_FEE_RET_SCHD
32: WHERE FEE_TYPE = p_fee_type AND
33: fee_cal_type = p_fee_cal_type AND

Line 31: FROM IGS_FI_FEE_RET_SCHD

27: DECLARE
28: CURSOR c_frtns (
29: cp_s_relation_type IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE) IS
30: SELECT 'x'
31: FROM IGS_FI_FEE_RET_SCHD
32: WHERE FEE_TYPE = p_fee_type AND
33: fee_cal_type = p_fee_cal_type AND
34: fee_ci_sequence_number = p_fee_ci_sequence_number AND
35: s_relation_type = cp_s_relation_type;

Line 78: -- Validate IGS_FI_FEE_RET_SCHD retention_amount

74: RETURN TRUE;
75: END;
76: END finp_val_frtns_creat;
77: --
78: -- Validate IGS_FI_FEE_RET_SCHD retention_amount
79: FUNCTION finp_val_frtns_amt(
80: p_retention_amount IN NUMBER ,
81: p_retention_percentage IN NUMBER ,
82: p_message_name OUT NOCOPY VARCHAR2 )

Line 86: -- Validate IGS_FI_FEE_RET_SCHD.retention_amount and

82: p_message_name OUT NOCOPY VARCHAR2 )
83: RETURN BOOLEAN AS
84: gv_other_detail VARCHAR2(255);
85: BEGIN -- finp_val_frtns_amt
86: -- Validate IGS_FI_FEE_RET_SCHD.retention_amount and
87: -- retention_percentage.
88: -- Only one of either retention_amount or retention_percentage
89: -- may be specified.
90: -- Set the default message number

Line 107: -- Validate IGS_FI_FEE_RET_SCHD fee type

103: -- 2. Return no error
104: RETURN TRUE;
105: END finp_val_frtns_amt;
106: --
107: -- Validate IGS_FI_FEE_RET_SCHD fee type
108: FUNCTION finp_val_frtns_ft(
109: p_fee_type IN VARCHAR2 ,
110: p_s_relation_type IN VARCHAR2 ,
111: p_message_name OUT NOCOPY VARCHAR2 )

Line 115: -- Validate IGS_FI_FEE_RET_SCHD.FEE_TYPE.

111: p_message_name OUT NOCOPY VARCHAR2 )
112: RETURN BOOLEAN AS
113: gv_other_detail VARCHAR2(255);
114: BEGIN -- finp_val_frtns_ft
115: -- Validate IGS_FI_FEE_RET_SCHD.FEE_TYPE.
116: -- If IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN', then retention schedules
117: -- can only be defined against fee_type_cal_instances. If the
118: -- IGS_FI_FEE_TYPE.optional_payment_ind
119: -- is set to 'Y' then fee retention schedules can only be set against

Line 194: -- Validate insert of the IGS_FI_FEE_RET_SCHD.

190: || that is set up in System Options Form.
191: ----------------------------------------------------------------------------*/
192: gv_other_detail VARCHAR2(255);
193: BEGIN -- finp_val_frtns_cur
194: -- Validate insert of the IGS_FI_FEE_RET_SCHD.
195: -- When adding an entry at the FTCI level;
196: -- check there are no related fee category fee liabilities
197: -- with a fee category currency set to other than the local
198: -- currency.