APPS.IGS_PS_UNIT_VER_PKG dependencies on IGS_PS_USEC_REF

Line 3357: FROM igs_ps_usec_ref a ,

3353: AND NOT EXISTS (SELECT 'X' FROM igs_ps_usec_lim_wlst ulw WHERE ulw.uoo_id = us.uoo_id);
3354:
3355: CURSOR c_title(cp_unit_cd VARCHAR2, cp_version_number NUMBER) IS
3356: SELECT a.*,a.rowid
3357: FROM igs_ps_usec_ref a ,
3358: igs_ps_unit_ofr_opt_all b,
3359: igs_ca_inst_all c
3360: WHERE a.uoo_id= b.uoo_id
3361: AND b.unit_cd= cp_unit_cd

Line 3377: v_title igs_ps_usec_ref.title%TYPE;

3373: subtitle =cp_subtitle;
3374:
3375: update_flag BOOLEAN := FALSE;
3376: r_unit_subtitle igs_ps_unit_subtitle_v.subtitle_id%TYPE;
3377: v_title igs_ps_usec_ref.title%TYPE;
3378:
3379:
3380: BEGIN
3381: l_message_name := NULL;

Line 3440: Igs_Ps_Usec_Ref_Pkg.Update_Row (

3436: update_flag := TRUE;
3437: END IF;
3438:
3439: IF update_flag THEN
3440: Igs_Ps_Usec_Ref_Pkg.Update_Row (
3441: X_Mode => 'R',
3442: X_rowid => c_title_rec.rowid,
3443: X_Unit_Section_Reference_Id => c_title_rec.unit_section_reference_id,
3444: X_Uoo_Id => c_title_rec.uoo_id,