APPS.IGS_FI_CHARGES_API_PVT dependencies on IGS_PS_UNIT_OFR_OPT

Line 341: FUNCTION validate_uoo(p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE) RETURN BOOLEAN AS

337: RETURN l_bool;
338:
339: END validate_cur;
340:
341: FUNCTION validate_uoo(p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE) RETURN BOOLEAN AS
342:
343: /***********************************************************************************************
344:
345: Created By: Amit Gairola

Line 367: CURSOR cur_uoo(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) IS

363: l_temp VARCHAR2(1);
364: l_bool BOOLEAN;
365:
366: -- Cursor for validating the unit section
367: CURSOR cur_uoo(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) IS
368: SELECT 'x'
369: FROM igs_ps_unit_ofr_opt
370: WHERE uoo_id = cp_uoo_id;
371:

Line 369: FROM igs_ps_unit_ofr_opt

365:
366: -- Cursor for validating the unit section
367: CURSOR cur_uoo(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) IS
368: SELECT 'x'
369: FROM igs_ps_unit_ofr_opt
370: WHERE uoo_id = cp_uoo_id;
371:
372: BEGIN
373:

Line 526: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;

522: l_v_transaction_type igs_fi_inv_int_all.transaction_type%TYPE;
523:
524: -- As part of the bug #1962286 the local variables l_unit_cd and l_unit_version_number were added
525:
526: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
527: l_unit_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
528:
529: -- cusor to get the version number form igs_en_stdnt_ps_att table for a person , course
530:

Line 527: l_unit_version_number igs_ps_unit_ofr_opt.version_number%TYPE;

523:
524: -- As part of the bug #1962286 the local variables l_unit_cd and l_unit_version_number were added
525:
526: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
527: l_unit_version_number igs_ps_unit_ofr_opt.version_number%TYPE;
528:
529: -- cusor to get the version number form igs_en_stdnt_ps_att table for a person , course
530:
531: CURSOR cur_ver (l_course_cd igs_fi_inv_int.course_Cd%TYPE,

Line 550: -- cursor to get the unit_cd and unit_version_number for a given uoo_id from igs_ps_unit_ofr_opt

546:
547: -- As part of the bug #1962286 the cursor cur_unit_cd_ver was added
548:
549: --
550: -- cursor to get the unit_cd and unit_version_number for a given uoo_id from igs_ps_unit_ofr_opt
551: --
552: CURSOR cur_unit_cd_ver (l_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE ) IS
553: SELECT unit_cd ,version_number
554: FROM igs_ps_unit_ofr_opt

Line 552: CURSOR cur_unit_cd_ver (l_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE ) IS

548:
549: --
550: -- cursor to get the unit_cd and unit_version_number for a given uoo_id from igs_ps_unit_ofr_opt
551: --
552: CURSOR cur_unit_cd_ver (l_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE ) IS
553: SELECT unit_cd ,version_number
554: FROM igs_ps_unit_ofr_opt
555: WHERE uoo_id = l_uoo_id;
556:

Line 554: FROM igs_ps_unit_ofr_opt

550: -- cursor to get the unit_cd and unit_version_number for a given uoo_id from igs_ps_unit_ofr_opt
551: --
552: CURSOR cur_unit_cd_ver (l_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE ) IS
553: SELECT unit_cd ,version_number
554: FROM igs_ps_unit_ofr_opt
555: WHERE uoo_id = l_uoo_id;
556:
557:
558: BEGIN