APPS.IGS_PS_GEN_001 dependencies on IGS_PS_UNIT_OFR_OPT_PKG

Line 4222: || call of igs_ps_unit_ofr_opt_pkg.update_row .

4218: || (reverse chronological order - newest change first)
4219: || sarakshi 21-oct-2003 Enh#3052452,used function igs_ps_gen_003.enrollment_for_uoo_check for checking the
4220: || existance of record in igs_en_su_attempt rather than explicitly coding a cursor locally.
4221: || sarakshi 18-sep-2003 Enh#3052452, added new parameters relation_type,sup_uoo_id,default_enroll_flag to the
4222: || call of igs_ps_unit_ofr_opt_pkg.update_row .
4223: || vvutukur 04-Aug-2003 Enh#3045069.PSP Enh Build.Modified the calls to igs_ps_unit_ofr_opt_pkg.update_row to add
4224: || new parameter not_multiple_section_flag.
4225: */
4226:

Line 4223: || vvutukur 04-Aug-2003 Enh#3045069.PSP Enh Build.Modified the calls to igs_ps_unit_ofr_opt_pkg.update_row to add

4219: || sarakshi 21-oct-2003 Enh#3052452,used function igs_ps_gen_003.enrollment_for_uoo_check for checking the
4220: || existance of record in igs_en_su_attempt rather than explicitly coding a cursor locally.
4221: || sarakshi 18-sep-2003 Enh#3052452, added new parameters relation_type,sup_uoo_id,default_enroll_flag to the
4222: || call of igs_ps_unit_ofr_opt_pkg.update_row .
4223: || vvutukur 04-Aug-2003 Enh#3045069.PSP Enh Build.Modified the calls to igs_ps_unit_ofr_opt_pkg.update_row to add
4224: || new parameter not_multiple_section_flag.
4225: */
4226:
4227: CURSOR c_uoo_id IS

Line 4266: igs_ps_unit_ofr_opt_pkg.update_row( x_rowid =>l_uoo_id.rowid,

4262: p_c_message_name:='IGS_PS_STATUS_NOT_UPD_ALLOWED';
4263: RETURN;
4264: ELSE
4265: FOR l_uoo_id IN c_uoo_id LOOP
4266: igs_ps_unit_ofr_opt_pkg.update_row( x_rowid =>l_uoo_id.rowid,
4267: x_unit_cd =>l_uoo_id.unit_cd,
4268: x_version_number =>l_uoo_id.version_number,
4269: x_cal_type =>l_uoo_id.cal_type,
4270: x_ci_sequence_number =>l_uoo_id.ci_sequence_number,

Line 4323: igs_ps_unit_ofr_opt_pkg.update_row( x_rowid =>l_uoo_id.rowid,

4319: --to OPEN for all the unit section under the calendar instance
4320:
4321: ELSIF p_c_new_cal_status = 'ACTIVE' AND p_c_old_cal_status ='INACTIVE' THEN
4322: FOR l_uoo_id IN c_uoo_id LOOP
4323: igs_ps_unit_ofr_opt_pkg.update_row( x_rowid =>l_uoo_id.rowid,
4324: x_unit_cd =>l_uoo_id.unit_cd,
4325: x_version_number =>l_uoo_id.version_number,
4326: x_cal_type =>l_uoo_id.cal_type,
4327: x_ci_sequence_number =>l_uoo_id.ci_sequence_number,