APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_USO_INSTRCTRS

Line 8270: --in production table(IGS_PS_USO_INSTRCTRS)

8266:
8267: END create_unit_ref_code;
8268:
8269: --This procedure is a sub process to create Unit Section Occurrence Instructors
8270: --in production table(IGS_PS_USO_INSTRCTRS)
8271: PROCEDURE create_uso_ins( p_tab_uso_ins IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type,
8272: p_c_rec_status OUT NOCOPY VARCHAR2 ) AS
8273: /***********************************************************************************************
8274:

Line 8292: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;

8288: For PSP Scheduling Enhancements TD:
8289: Modified local procedures validate_db_cons and validate_derivation.
8290: ***********************************************************************************************/
8291:
8292: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
8293: l_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE;
8294: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
8295: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
8296: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;

Line 8293: l_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE;

8289: Modified local procedures validate_db_cons and validate_derivation.
8290: ***********************************************************************************************/
8291:
8292: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
8293: l_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE;
8294: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
8295: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
8296: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
8297:

Line 8305: FUNCTION usoexists(p_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE) RETURN BOOLEAN AS

8301: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
8302: AND uso.no_set_day_ind ='N'
8303: AND uso.unit_section_occurrence_id=cp_unit_section_occurrence_id;
8304:
8305: FUNCTION usoexists(p_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE) RETURN BOOLEAN AS
8306: /***********************************************************************************************
8307: Created By : sommukhe
8308: Date Created By: 1-08-2006.
8309: Purpose : This utility procedure is to check if a uso exists in a pl/sql table

Line 8522: IF igs_ps_uso_instrctrs_pkg.get_uk_for_validation(l_n_uso_id, l_n_ins_id) THEN

8518: l_c_var VARCHAR2(1);
8519:
8520: BEGIN
8521: -- Check uniqueness validation
8522: IF igs_ps_uso_instrctrs_pkg.get_uk_for_validation(l_n_uso_id, l_n_ins_id) THEN
8523: p_uso_ins_rec.status :='W';
8524: fnd_message.set_name('IGS','IGS_PS_USO_INS');
8525: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', fnd_message.get, NULL, FALSE);
8526: RETURN;

Line 8641: INSERT INTO IGS_PS_USO_INSTRCTRS (

8637: ||' '||'production_uso_id:'||p_tab_uso_ins(I).production_uso_id||' '||'Status:'|| p_tab_uso_ins(I).status);
8638: END IF;
8639: END IF;
8640: IF p_tab_uso_ins(I).status = 'S' THEN
8641: INSERT INTO IGS_PS_USO_INSTRCTRS (
8642: USO_INSTRUCTOR_ID,
8643: UNIT_SECTION_OCCURRENCE_ID,
8644: INSTRUCTOR_ID,
8645: CREATED_BY ,

Line 8651: igs_ps_uso_instrctrs_s.nextval,

8647: LAST_UPDATED_BY,
8648: LAST_UPDATE_DATE ,
8649: LAST_UPDATE_LOGIN
8650: ) VALUES (
8651: igs_ps_uso_instrctrs_s.nextval,
8652: l_n_uso_id,
8653: l_n_ins_id,
8654: g_n_user_id,
8655: sysdate,