[Home] [Help]
43: p_val IN NUMBER
44: ) ;
45: FUNCTION get_alternate_code (p_c_cal_type IN VARCHAR2,
46: p_n_seq_num IN NUMBER)RETURN VARCHAR2;
47: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id
48: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id
49:
50:
51: PROCEDURE prgp_init_prs_sched(
44: ) ;
45: FUNCTION get_alternate_code (p_c_cal_type IN VARCHAR2,
46: p_n_seq_num IN NUMBER)RETURN VARCHAR2;
47: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id
48: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id
49:
50:
51: PROCEDURE prgp_init_prs_sched(
52: errbuf OUT NOCOPY VARCHAR2,
102: ci.alternate_code teaching_cal_alternate_code,
103: NULL subtitle,
104: uv.subtitle_id,
105: NVL(uoo.owner_org_unit_cd, uv.owner_org_unit_cd) owner_org_unit_cd
106: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv,igs_ca_inst_all ci, igs_ad_location_all loc
107: WHERE uoo.cal_type = l_cal_type
108: AND uoo.ci_sequence_number = l_ci_sequence_number
109: AND uoo.unit_cd=cp_unit_cd
110: AND uoo.version_number=cp_version_number
214: WHERE int_usec_id=cp_int_usec_id;
215:
216: l_int_pat_id NUMBER;
217: l_valid_occur BOOLEAN;
218: l_unit_status igs_ps_unit_ver_all.unit_status%TYPE;
219: ---
220:
221: l_trans_id igs_ps_sch_hdr_int.transaction_id%TYPE;
222: l_request_id igs_ps_sch_hdr_int.request_id%TYPE;
273: END create_header;
274:
275: -- Procedure to get the enrollment limits (Enrollment Expected, Enrollment Maximum and Override Maximum) for the unit section.
276: -- Uses inheritance logic to get enrollment limits.
277: -- (i.e gets enrollment limits from unit section[IGS_PS_USEC_LIM_WLST] level if defined (overriden) otherwise from unit level [IGS_PS_UNIT_VER_ALL].)
278: PROCEDURE get_enrollment_lmts(p_n_uoo_id IN NUMBER) AS
279:
280: -- gets the enrollment limits defined at unit section level.
281: CURSOR usec_lmts(cp_n_uoo_id IN NUMBER) IS
289: CURSOR unit_lmts(cp_n_uoo_id IN NUMBER) IS
290: SELECT unit.enrollment_expected,
291: NVL(unit.enrollment_maximum, 999999),
292: NVL(unit.override_enrollment_max,999999)
293: FROM IGS_PS_UNIT_VER_ALL unit,
294: IGS_PS_UNIT_OFR_OPT_ALL usec
295: WHERE unit.unit_cd = usec.unit_cd
296: AND unit.version_number = usec.version_number
297: AND usec.uoo_id = cp_n_uoo_id;
371: Change History
372:
373: Who When What
374: ***************************************************************/
375: l_u_enrollment_expected igs_ps_unit_ver_all.enrollment_expected%TYPE ;
376: l_u_enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%TYPE ;
377: l_u_override_enrollment_max igs_ps_unit_ver_all.override_enrollment_max%TYPE ;
378:
379:
372:
373: Who When What
374: ***************************************************************/
375: l_u_enrollment_expected igs_ps_unit_ver_all.enrollment_expected%TYPE ;
376: l_u_enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%TYPE ;
377: l_u_override_enrollment_max igs_ps_unit_ver_all.override_enrollment_max%TYPE ;
378:
379:
380: CURSOR c_section_exists(cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
373: Who When What
374: ***************************************************************/
375: l_u_enrollment_expected igs_ps_unit_ver_all.enrollment_expected%TYPE ;
376: l_u_enrollment_maximum igs_ps_unit_ver_all.enrollment_maximum%TYPE ;
377: l_u_override_enrollment_max igs_ps_unit_ver_all.override_enrollment_max%TYPE ;
378:
379:
380: CURSOR c_section_exists(cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
381: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,