DBA Data[Home] [Help]

APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_USEC_OCCURS_PKG

Line 83: igs_ps_usec_occurs_pkg.update_row (

79: END IF;
80:
81: IF schd_stat ='USER_CANCEL' OR (schd_stat ='USER_UPDATE' AND (c_usec_occurs_rec.schedule_status IS NOT NULL AND c_usec_occurs_rec.schedule_status <> 'PROCESSING')) THEN
82:
83: igs_ps_usec_occurs_pkg.update_row (
84: x_rowid => c_usec_occurs_rec.ROWID,
85: x_unit_section_occurrence_id => c_usec_occurs_rec.unit_section_occurrence_id,
86: x_uoo_id => c_usec_occurs_rec.uoo_id,
87: x_monday => c_usec_occurs_rec.monday,

Line 1209: igs_ps_usec_occurs_pkg.update_row (

1205: IF p_usec_rec.unit_section_status = 'CANCELLED' THEN
1206: IF (NVL(fnd_profile.value('IGS_PS_SCH_SOFT_NOT_INSTLD'),'N')) = 'N' THEN
1207: IF p_usec_rec.status <> 'E' THEN
1208: FOR rec_uso IN c_uso(c_usec_rec.uoo_id) LOOP
1209: igs_ps_usec_occurs_pkg.update_row (
1210: X_Mode => 'R',
1211: X_RowId => rec_uso.rowid ,
1212: X_unit_section_occurrence_id => rec_uso.unit_section_occurrence_id,
1213: X_uoo_id => rec_uso.uoo_id,