APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_UNIT_OFR_PAT

Line 171: FROM igs_ps_unit_ofr_pat us, igs_ca_inst_all b,igs_ps_unit_ver c, igs_ps_unit_stat d

167:
168: CURSOR pat_cur(cp_cal_type IN VARCHAR2, cp_ci_sequence_number IN NUMBER,
169: cp_unit_cd IN VARCHAR2, cp_version_number IN NUMBER) IS
170: SELECT us.*,b.alternate_code ,b.start_dt,b.end_dt,c.unit_status,c.enrollment_expected,c.enrollment_maximum,c.override_enrollment_max
171: FROM igs_ps_unit_ofr_pat us, igs_ca_inst_all b,igs_ps_unit_ver c, igs_ps_unit_stat d
172: WHERE us.cal_type=cp_cal_type
173: AND us.ci_sequence_number=cp_ci_sequence_number
174: AND (us.unit_cd=cp_unit_cd OR cp_unit_cd IS NULL)
175: AND (us.version_number=cp_version_number OR cp_version_number IS NULL)

Line 1246: FROM igs_ps_unit_ofr_pat pt

1242: cp_version_number IN NUMBER,
1243: cp_cal_type IN VARCHAR2,
1244: cp_ci_sequence_number IN NUMBER) IS
1245: SELECT pt.*,pt.rowid
1246: FROM igs_ps_unit_ofr_pat pt
1247: WHERE unit_cd=cp_unit_cd
1248: AND version_number=cp_version_number
1249: AND cal_type=cp_cal_type
1250: AND ci_sequence_number=cp_ci_sequence_number;

Line 1436: igs_ps_unit_ofr_pat_pkg.update_row (

1432: OPEN cur_prod_pattern(l_pattern_prod_rec.unit_cd,l_pattern_prod_rec.version_number,l_pattern_prod_rec.calendar_type,l_pattern_prod_rec.sequence_number);
1433: FETCH cur_prod_pattern INTO l_prod_pattern;
1434: CLOSE cur_prod_pattern;
1435:
1436: igs_ps_unit_ofr_pat_pkg.update_row (
1437: X_Mode => 'R',
1438: X_RowId => l_prod_pattern.rowid,
1439: X_Unit_Cd => l_prod_pattern.Unit_Cd,
1440: X_Version_Number => l_prod_pattern.Version_Number,

Line 3627: cp_unit_cd igs_ps_unit_ofr_pat_all.unit_cd%TYPE,

3623: c_prod_usec_rec c_prod_usec%ROWTYPE;
3624:
3625: CURSOR c_prod_pat (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,
3626: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE,
3627: cp_unit_cd igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
3628: cp_version_number igs_ps_unit_ofr_pat_all.version_number%TYPE) IS
3629: SELECT pt.ROWID prodrid,pt.*
3630: FROM igs_ps_unit_ofr_pat_all pt
3631: WHERE cal_type=cp_cal_type

Line 3628: cp_version_number igs_ps_unit_ofr_pat_all.version_number%TYPE) IS

3624:
3625: CURSOR c_prod_pat (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,
3626: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE,
3627: cp_unit_cd igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
3628: cp_version_number igs_ps_unit_ofr_pat_all.version_number%TYPE) IS
3629: SELECT pt.ROWID prodrid,pt.*
3630: FROM igs_ps_unit_ofr_pat_all pt
3631: WHERE cal_type=cp_cal_type
3632: AND ci_sequence_number =cp_sequence_number

Line 3630: FROM igs_ps_unit_ofr_pat_all pt

3626: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE,
3627: cp_unit_cd igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
3628: cp_version_number igs_ps_unit_ofr_pat_all.version_number%TYPE) IS
3629: SELECT pt.ROWID prodrid,pt.*
3630: FROM igs_ps_unit_ofr_pat_all pt
3631: WHERE cal_type=cp_cal_type
3632: AND ci_sequence_number =cp_sequence_number
3633: AND unit_cd= cp_unit_cd
3634: AND version_number=cp_version_number;

Line 3928: igs_ps_unit_ofr_pat_pkg.update_row (

3924:
3925: --update the production table
3926: OPEN c_prod_pat(l_ci_sequence_number,l_cal_type,c_int_pat_ss_rec.unit_cd ,c_int_pat_ss_rec.version_number );
3927: FETCH c_prod_pat INTO c_prod_pat_rec;
3928: igs_ps_unit_ofr_pat_pkg.update_row (
3929: x_rowid => c_prod_pat_rec.prodrid ,
3930: x_unit_cd => c_prod_pat_rec.unit_cd,
3931: x_version_number => c_prod_pat_rec.version_number,
3932: x_ci_sequence_number => c_prod_pat_rec.ci_sequence_number,