APPS.IGS_FI_GEN_001 dependencies on IGS_PS_COURSE

Line 306: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,

302: p_fee_type IN VARCHAR2 ,
303: p_fee_cal_type IN VARCHAR2 ,
304: p_fee_ci_sequence_number IN NUMBER ,
305: p_fee_cat IN VARCHAR2 ,
306: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
307: p_transaction_cat IN VARCHAR2 )
308: RETURN VARCHAR2 AS
309:
310: BEGIN

Line 765: -- check for matching student IGS_PS_COURSE attempt

761: BEGIN
762: -- check the fee trigger group members
763: v_trigger_group_fired := TRUE;
764: FOR v_ftgv_rec IN c_ftgv_course LOOP
765: -- check for matching student IGS_PS_COURSE attempt
766: IF (v_ftgv_rec.code <> p_course_cd OR
767: NVL(v_ftgv_rec.version_number, p_version_number) <>
768: p_version_number) THEN
769: v_trigger_group_fired := FALSE;

Line 873: -- check IGS_PS_COURSE fee triggers

869: END IF;
870: CLOSE c_susa;
871: END LOOP;
872: ELSIF (v_s_fee_trigger_cat = 'COMPOSITE') THEN
873: -- check IGS_PS_COURSE fee triggers
874: FOR v_cft_rec IN c_cft LOOP
875: IF (v_cft_rec.fee_trigger_group_number IS NULL) THEN
876: -- Trigger Fired
877: RETURN 'CFT';

Line 1201: -- Routine to determine the HECS Fee assessed for a student IGS_PS_COURSE attempt.

1197: schodava 21-Jan-2002 Enh # 2187247
1198: SFCR021 - LCI-FCI Relation
1199: ******************************************************************/
1200: -- finp_get_hecs_fee
1201: -- Routine to determine the HECS Fee assessed for a student IGS_PS_COURSE attempt.
1202:
1203: cst_hecs CONSTANT VARCHAR2(4) := 'HECS';
1204: v_fp_total NUMBER;
1205: v_fee_cal_type igs_ca_inst.cal_type%TYPE;

Line 1275: -- cursor to get student IGS_PS_COURSE HECS payment option details

1271: RETURN varchar2 AS
1272:
1273: BEGIN
1274: DECLARE
1275: -- cursor to get student IGS_PS_COURSE HECS payment option details
1276: CURSOR c_scho(
1277: cp_effective_dt DATE,
1278: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1279: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS