APPS.IGS_FI_VAL_CFT dependencies on IGS_PS_COURSE

Line 15: -- Ensure IGS_PS_COURSE fee triggers can be created.

11: -- sjadhav , 28-aug-2001
12: -- removed enrp_val_att_closed
13: --
14:
15: -- Ensure IGS_PS_COURSE fee triggers can be created.
16: FUNCTION finp_val_cft_ins(
17: p_fee_type IN VARCHAR2 ,
18: p_message_name OUT NOCOPY VARCHAR2 )
19: RETURN BOOLEAN AS

Line 22: -- Validate IGS_PS_FEE_TRG.IGS_FI_FEE_TYPE.s_fee_trigger_cat = IGS_PS_COURSE or COMPOSITE

18: p_message_name OUT NOCOPY VARCHAR2 )
19: RETURN BOOLEAN AS
20: gv_other_detail VARCHAR2(255);
21: BEGIN -- finp_val_cft_ins
22: -- Validate IGS_PS_FEE_TRG.IGS_FI_FEE_TYPE.s_fee_trigger_cat = IGS_PS_COURSE or COMPOSITE
23: -- otherwise IGS_PS_COURSE fee triggers cannot be defined.
24: DECLARE
25: CURSOR c_ft(
26: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

Line 23: -- otherwise IGS_PS_COURSE fee triggers cannot be defined.

19: RETURN BOOLEAN AS
20: gv_other_detail VARCHAR2(255);
21: BEGIN -- finp_val_cft_ins
22: -- Validate IGS_PS_FEE_TRG.IGS_FI_FEE_TYPE.s_fee_trigger_cat = IGS_PS_COURSE or COMPOSITE
23: -- otherwise IGS_PS_COURSE fee triggers cannot be defined.
24: DECLARE
25: CURSOR c_ft(
26: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
27: SELECT s_fee_trigger_cat

Line 122: -- Validate IGS_PS_COURSE code has an 'ACTIVE' or 'PLANNED' version.

118: END;
119: END finp_val_cft_open;
120: --
121: --
122: -- Validate IGS_PS_COURSE code has an 'ACTIVE' or 'PLANNED' version.
123: FUNCTION finp_val_cft_crs(
124: p_course_cd IN VARCHAR2 ,
125: p_message_name OUT NOCOPY VARCHAR2 )
126: RETURN BOOLEAN AS

Line 236: -- Validate IGS_PS_COURSE fee trigger can belong to a fee trigger group.

232: -- bug id : 1956374
233: -- sjadhav , 28-aug-2001
234: -- removed enrp_val_att_closed
235: --
236: -- Validate IGS_PS_COURSE fee trigger can belong to a fee trigger group.
237: FUNCTION finp_val_cft_ftg(
238: p_fee_cat IN IGS_FI_FEE_CAT_ALL.fee_cat%TYPE ,
239: p_fee_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
240: p_fee_ci_sequence_num IN NUMBER ,

Line 242: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE,

238: p_fee_cat IN IGS_FI_FEE_CAT_ALL.fee_cat%TYPE ,
239: p_fee_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
240: p_fee_ci_sequence_num IN NUMBER ,
241: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
242: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE,
243: p_fee_trigger_group_num IN NUMBER ,
244: p_message_name OUT NOCOPY VARCHAR2 )
245: RETURN BOOLEAN AS
246: gv_other_detail VARCHAR2(255);