APPS.IGS_FI_GEN_006 dependencies on IGS_FI_HECS_PAY_OPTN

Line 113: p_deferred_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%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 ,
116: p_hecs_payment_type OUT NOCOPY FND_LOOKUP_Values.LOOKUP_CODE%TYPE ,
117: p_message_name OUT NOCOPY VARCHAR2)

Line 114: p_upfront_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%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 ,
116: p_hecs_payment_type OUT NOCOPY FND_LOOKUP_Values.LOOKUP_CODE%TYPE ,
117: p_message_name OUT NOCOPY VARCHAR2)
118: RETURN BOOLEAN AS

Line 156: cp_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE,

152: -- Maintain a student's IGS_PS_COURSE attempt HECS payment option on the basis of
153: -- their assessed liability and any up front payment made.
154: DECLARE
155: CURSOR c_hpo (
156: cp_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE,
157: cp_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE) IS
158: SELECT HECS_PAYMENT_OPTION
159: FROM IGS_FI_HECS_PAY_OPTN hpo,
160: IGS_FI_GOV_HEC_PA_OP ghpo

Line 159: FROM IGS_FI_HECS_PAY_OPTN hpo,

155: CURSOR c_hpo (
156: cp_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE,
157: cp_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE) IS
158: SELECT HECS_PAYMENT_OPTION
159: FROM IGS_FI_HECS_PAY_OPTN hpo,
160: IGS_FI_GOV_HEC_PA_OP ghpo
161: WHERE hpo.HECS_PAYMENT_OPTION = cp_payment_option AND
162: hpo.closed_ind = 'N' AND
163: hpo.GOVT_HECS_PAYMENT_OPTION = ghpo.GOVT_HECS_PAYMENT_OPTION AND

Line 166: cp_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE) IS

162: hpo.closed_ind = 'N' AND
163: hpo.GOVT_HECS_PAYMENT_OPTION = ghpo.GOVT_HECS_PAYMENT_OPTION AND
164: ghpo.s_hecs_payment_type = cp_hecs_payment_type;
165: CURSOR c_ghpo(
166: cp_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE) IS
167: SELECT ghpo.s_hecs_payment_type
168: FROM IGS_FI_HECS_PAY_OPTN hpo,
169: IGS_FI_GOV_HEC_PA_OP ghpo
170: WHERE hpo.HECS_PAYMENT_OPTION = cp_payment_option AND

Line 168: FROM IGS_FI_HECS_PAY_OPTN hpo,

164: ghpo.s_hecs_payment_type = cp_hecs_payment_type;
165: CURSOR c_ghpo(
166: cp_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE) IS
167: SELECT ghpo.s_hecs_payment_type
168: FROM IGS_FI_HECS_PAY_OPTN hpo,
169: IGS_FI_GOV_HEC_PA_OP ghpo
170: WHERE hpo.HECS_PAYMENT_OPTION = cp_payment_option AND
171: hpo.GOVT_HECS_PAYMENT_OPTION = ghpo.GOVT_HECS_PAYMENT_OPTION;
172: -- Modified the Cursor c_fadv to fetch the Data from the table IGS_FI_FEE_AS

Line 229: v_deferred_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE

225: v_tax_file_number_collected_dt
226: IGS_EN_STDNTPSHECSOP.tax_file_number_collected_dt%TYPE;
227: v_tax_file_certificate_number
228: IGS_EN_STDNTPSHECSOP.tax_file_certificate_number%TYPE;
229: v_deferred_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE
230: DEFAULT p_deferred_payment_option;
231: v_upfront_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE
232: DEFAULT p_upfront_payment_option;
233: v_valid_tax_details BOOLEAN DEFAULT FALSE;

Line 231: v_upfront_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE

227: v_tax_file_certificate_number
228: IGS_EN_STDNTPSHECSOP.tax_file_certificate_number%TYPE;
229: v_deferred_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE
230: DEFAULT p_deferred_payment_option;
231: v_upfront_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE
232: DEFAULT p_upfront_payment_option;
233: v_valid_tax_details BOOLEAN DEFAULT FALSE;
234: v_key IGS_GE_S_LOG.key%TYPE DEFAULT NULL;
235: v_text IGS_GE_S_LOG_ENTRY.text%TYPE DEFAULT NULL;