APPS.IGS_FI_GEN_006 dependencies on IGS_EN_STDNT_PS_ATT

Line 27: p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,

23: p_correspondence_type IN VARCHAR2 ,
24: P_FIN_PERD IN VARCHAR2,
25: P_FEE_PERD IN VARCHAR2,
26: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
27: p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
28: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
29: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
30: p_person_group_id IN NUMBER ,
31: p_institution_cd IN VARCHAR2 ,

Line 28: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

24: P_FIN_PERD IN VARCHAR2,
25: P_FEE_PERD IN VARCHAR2,
26: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
27: p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
28: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
29: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
30: p_person_group_id IN NUMBER ,
31: p_institution_cd IN VARCHAR2 ,
32: p_addr_type IN VARCHAR2 ,

Line 29: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

25: P_FEE_PERD IN VARCHAR2,
26: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
27: p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
28: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
29: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
30: p_person_group_id IN NUMBER ,
31: p_institution_cd IN VARCHAR2 ,
32: p_addr_type IN VARCHAR2 ,
33: P_DATE_OF_ISSUE_C IN VARCHAR2,

Line 69: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

65: PROCEDURE finp_mnt_pymnt_schdl(
66: errbuf out NOCOPY varchar2,
67: retcode out NOCOPY number,
68: P_FEE_ASSESSMENT_PERIOD IN VARCHAR2,
69: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
70: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
71: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
72: p_notification_dt_c IN VARCHAR2,
73: p_num_days_to_notification NUMBER ,

Line 71: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,

67: retcode out NOCOPY number,
68: P_FEE_ASSESSMENT_PERIOD IN VARCHAR2,
69: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
70: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
71: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
72: p_notification_dt_c IN VARCHAR2,
73: p_num_days_to_notification NUMBER ,
74: p_next_bus_day_ind IN VARCHAR,
75: p_org_id NUMBER

Line 107: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

103: END finp_mnt_pymnt_schdl;
104:
105: FUNCTION finp_mnt_hecs_pymnt_optn(
106: p_effective_dt IN DATE ,
107: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
108: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
109: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
110: p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
111: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

Line 110: p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,

106: p_effective_dt IN DATE ,
107: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
108: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
109: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
110: p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
111: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
112: p_update_ind IN VARCHAR2,
113: p_deferred_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE ,
114: p_upfront_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE ,

Line 111: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

107: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
108: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
109: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
110: p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
111: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
112: p_update_ind IN VARCHAR2,
113: p_deferred_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE ,
114: p_upfront_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE ,
115: p_creation_dt IN OUT NOCOPY IGS_GE_S_LOG.creation_dt%TYPE ,

Line 142: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

138: PRAGMA EXCEPTION_INIT(e_resource_busy_exception, -54);
139: -- cursor to get student IGS_PS_COURSE HECS payment option details
140: CURSOR c_scho(
141: cp_effective_dt DATE,
142: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
143: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
144: SELECT IGS_EN_STDNTPSHECSOP.*, rowid
145: FROM IGS_EN_STDNTPSHECSOP
146: WHERE person_id = cp_person_id AND

Line 143: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

139: -- cursor to get student IGS_PS_COURSE HECS payment option details
140: CURSOR c_scho(
141: cp_effective_dt DATE,
142: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
143: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
144: SELECT IGS_EN_STDNTPSHECSOP.*, rowid
145: FROM IGS_EN_STDNTPSHECSOP
146: WHERE person_id = cp_person_id AND
147: course_cd = cp_course_cd AND