APPS.IGS_ST_GEN_004 dependencies on IGS_PS_UNIT_OFR_OPT

Line 154: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE)

150: p_course_cd IN VARCHAR2 ,
151: p_unit_cd IN VARCHAR2 ,
152: p_sua_cal_type IN VARCHAR2 ,
153: p_sua_ci_sequence_number IN NUMBER,
154: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE)
155: RETURN NUMBER AS
156: gv_other_detail VARCHAR2(255);
157: BEGIN -- stap_get_un_comp_sts
158: -- Derive the IGS_PS_UNIT of study completion status

Line 366: igs_ps_unit_ofr_opt uoo

362: v_unit_completion_stat NUMBER;
363: CURSOR Cur_si_st_govtstdldtmp IS
364: SELECT sgs.*,uoo.uoo_id
365: FROM IGS_ST_GVT_STDNTLOAD sgs,
366: igs_ps_unit_ofr_opt uoo
367: WHERE sgs.submission_yr = p_submission_yr AND
368: sgs.submission_number = (p_submission_number - 1) AND
369: sgs.unit_cd = uoo.unit_cd AND
370: sgs.uv_version_number = uoo.version_number AND

Line 452: igs_ps_unit_ofr_opt uoo

448: uoo.uoo_id,
449: ess.sua_location_cd
450: FROM IGS_EN_ST_SNAPSHOT ess,
451: IGS_PS_TYPE ct,
452: igs_ps_unit_ofr_opt uoo
453: WHERE ess.snapshot_dt_time = cp_dt_time AND
454: ess.govt_reportable_ind <> 'X' AND
455: ct.course_type = ess.course_type AND
456: ess.unit_cd = uoo.unit_cd AND

Line 735: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)

731: p_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE,
732: p_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE,
733: p_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE,
734: p_unit_completion_status OUT NOCOPY NUMBER,
735: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)
736: AS
737: gv_other_detail VARCHAR2(255);
738: BEGIN
739: DECLARE

Line 2841: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE);

2837: tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
2838: govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,
2839: eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE,
2840: industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,
2841: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE);
2842: r_units r_units_typ;
2843: TYPE t_units_typ IS TABLE OF r_units%TYPE
2844: INDEX BY BINARY_INTEGER;
2845: t_old_units t_units_typ;

Line 2982: igs_ps_unit_ofr_opt uoo

2978: gslo.eftsu,
2979: gslo.industrial_ind,
2980: uoo.uoo_id
2981: FROM IGS_ST_GVT_STDNTLOAD gslo,
2982: igs_ps_unit_ofr_opt uoo
2983: WHERE gslo.submission_yr = p_submission_yr AND
2984: gslo.submission_number = p_submission_number AND
2985: gslo.govt_semester = cp_govt_semester AND
2986: gslo.person_id = cp_person_id AND

Line 3017: igs_ps_unit_ofr_opt uoo

3013: uoo.uoo_id
3014: FROM IGS_EN_ST_SNAPSHOT ess,
3015: IGS_PS_UNIT_VER uv,
3016: IGS_ST_GVTSEMLOAD_CA gslc,
3017: igs_ps_unit_ofr_opt uoo
3018: WHERE ess.snapshot_dt_time = cp_snapshot_dt_time AND
3019: ess.ci_cal_type = gslc.cal_type AND
3020: ess.ci_sequence_number = gslc.ci_sequence_number AND
3021: gslc.submission_yr = p_submission_yr AND

Line 3214: v_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

3210: v_perm_resident_cd IGS_PE_STATISTICS.perm_resident_cd%TYPE;
3211: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
3212: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
3213: v_old_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
3214: v_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
3215: -- declaration for rowid and the sequence number variable
3216: v_rowid VARCHAR2(25);
3217: v_seqnum IGS_ST_GVT_SPSHT_CHG.sequence_number%type;
3218: BEGIN