APPS.IGS_FI_CHARGES_API_PVT dependencies on IGS_PS_VER

Line 249: FUNCTION validate_course(p_course_cd IN igs_ps_ver.course_cd%TYPE) RETURN BOOLEAN AS

245:
246: RETURN l_bool;
247: END validate_fcfl;
248:
249: FUNCTION validate_course(p_course_cd IN igs_ps_ver.course_cd%TYPE) RETURN BOOLEAN AS
250:
251: /***********************************************************************************************
252:
253: Created By: Amit Gairola

Line 270: CURSOR cur_course(cp_course_cd igs_ps_ver.course_cd%TYPE,

266: l_temp VARCHAR2(1);
267: l_bool BOOLEAN;
268:
269: -- Cursor for validating the program
270: CURSOR cur_course(cp_course_cd igs_ps_ver.course_cd%TYPE,
271: cp_status VARCHAR2) IS
272: SELECT 'x'
273: FROM igs_ps_ver pv, igs_ps_stat ps
274: WHERE pv.course_cd = cp_course_cd

Line 273: FROM igs_ps_ver pv, igs_ps_stat ps

269: -- Cursor for validating the program
270: CURSOR cur_course(cp_course_cd igs_ps_ver.course_cd%TYPE,
271: cp_status VARCHAR2) IS
272: SELECT 'x'
273: FROM igs_ps_ver pv, igs_ps_stat ps
274: WHERE pv.course_cd = cp_course_cd
275: AND pv.course_status = ps.course_status
276: AND ps.s_course_status = cp_status;
277:

Line 1086: cp_course_cd igs_ps_ver.course_cd%TYPE,

1082: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
1083: cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
1084: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
1085: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1086: cp_course_cd igs_ps_ver.course_cd%TYPE,
1087: cp_uoo_id igs_fi_invln_int.uoo_id%TYPE,
1088: cp_location_cd igs_fi_invln_int.location_cd%TYPE,
1089: cp_transaction_type igs_fi_inv_int.transaction_type%TYPE,
1090: cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS

Line 1385: cp_course_cd igs_ps_ver.course_cd%TYPE,

1381: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
1382: cp_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
1383: cp_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1384: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1385: cp_course_cd igs_ps_ver.course_cd%TYPE,
1386: cp_transaction_type igs_fi_inv_int_all.transaction_type%TYPE,
1387: cp_uoo_id igs_fi_invln_int_all.uoo_id%TYPE,
1388: cp_location_cd igs_fi_invln_int_all.location_cd%TYPE,
1389: cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS

Line 1490: cp_course_cd igs_ps_ver.course_cd%TYPE,

1486: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
1487: cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
1488: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
1489: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1490: cp_course_cd igs_ps_ver.course_cd%TYPE,
1491: cp_transaction_type igs_fi_inv_int.transaction_type%TYPE,
1492: cp_uoo_id igs_fi_invln_int.uoo_id%TYPE,
1493: cp_location_cd igs_fi_invln_int.location_cd%TYPE,
1494: cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS