APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USO_INSTRCTRS

Line 6213: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;

6209: Change History
6210: Who When What
6211: ***********************************************************************************************/
6212:
6213: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
6214: l_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE;
6215: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6216: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
6217: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;

Line 6214: l_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE;

6210: Who When What
6211: ***********************************************************************************************/
6212:
6213: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
6214: l_n_uso_id igs_ps_uso_instrctrs.unit_section_occurrence_id%TYPE;
6215: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6216: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
6217: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
6218: l_insert_status BOOLEAN;

Line 6469: FROM igs_ps_uso_instrctrs

6465:
6466: PROCEDURE delete_records(p_delete_status OUT NOCOPY BOOLEAN) IS
6467: CURSOR cur_ins_exists(cp_uso_id IN NUMBER) IS
6468: SELECT 'X'
6469: FROM igs_ps_uso_instrctrs
6470: WHERE unit_section_occurrence_id =cp_uso_id;
6471:
6472: CURSOR cur_resp_exists(cp_uoo_id IN NUMBER,cp_ins_id IN NUMBER) IS
6473: SELECT 'X'

Line 6477: AND NOT EXISTS (SELECT 'X' FROM igs_ps_uso_instrctrs a,igs_ps_usec_occurs_all b

6473: SELECT 'X'
6474: FROM igs_ps_usec_tch_resp
6475: WHERE uoo_id =cp_uoo_id
6476: AND instructor_id=cp_ins_id
6477: AND NOT EXISTS (SELECT 'X' FROM igs_ps_uso_instrctrs a,igs_ps_usec_occurs_all b
6478: WHERE a.unit_section_occurrence_id=b.unit_section_occurrence_id
6479: AND b.uoo_id=cp_uoo_id
6480: AND a.instructor_id=cp_ins_id);
6481:

Line 6499: DELETE igs_ps_uso_instrctrs WHERE unit_section_occurrence_id=p_tab_uso_ins(I).system_uso_id ;

6495:
6496: OPEN cur_ins_exists(p_tab_uso_ins(I).system_uso_id);
6497: FETCH cur_ins_exists INTO l_c_var;
6498: IF cur_ins_exists%FOUND THEN
6499: DELETE igs_ps_uso_instrctrs WHERE unit_section_occurrence_id=p_tab_uso_ins(I).system_uso_id ;
6500: END IF;
6501: CLOSE cur_ins_exists;
6502:
6503: OPEN cur_resp_exists(p_tab_uso_ins(I).system_uoo_id,p_tab_uso_ins(I).system_instructor_id);

Line 6523: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_uso_ins_ovrd.Delete_for_IGS_PS_USO_INSTRCTRS',

6519: DELETE igs_ps_usec_tch_resp WHERE instructor_id=p_tab_uso_ins(I).system_instructor_id AND
6520: uoo_id = p_tab_uso_ins(I).system_uoo_id ;
6521:
6522: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6523: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_uso_ins_ovrd.Delete_for_IGS_PS_USO_INSTRCTRS',
6524: 'Unit code:'||p_tab_uso_ins(I).unit_cd||' '||'Version number:'||p_tab_uso_ins(I).version_number||' '||
6525: 'teach_cal_alternate_code:'||p_tab_uso_ins(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_uso_ins(I).location_cd
6526: ||' '||'Unit Class:'||p_tab_uso_ins(I).unit_class||' '||'instructor_person_number:'||p_tab_uso_ins(I).instructor_person_number
6527: ||' '||'occurrence_identifier'||p_tab_uso_ins(I).occurrence_identifier

Line 6551: IF igs_ps_uso_instrctrs_pkg.get_uk_for_validation(p_tab_uso_ins(I).system_uso_id, p_tab_uso_ins(I).system_instructor_id) THEN

6547: IF p_tab_uso_ins.EXISTS(I) AND p_tab_uso_ins(I).status = 'S' THEN
6548: p_tab_uso_ins(I).msg_from := fnd_msg_pub.count_msg;
6549:
6550: -- Check uniqueness validation
6551: IF igs_ps_uso_instrctrs_pkg.get_uk_for_validation(p_tab_uso_ins(I).system_uso_id, p_tab_uso_ins(I).system_instructor_id) THEN
6552: p_tab_uso_ins(I).status :='E';
6553: fnd_message.set_name('IGS','IGS_PS_USO_INS');
6554: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', fnd_message.get, NULL, FALSE);
6555: p_c_rec_status := p_tab_uso_ins(I).status;

Line 6562: INSERT INTO IGS_PS_USO_INSTRCTRS (

6558: p_insert_status:= FALSE;
6559: RETURN;
6560: ELSE
6561:
6562: INSERT INTO IGS_PS_USO_INSTRCTRS (
6563: USO_INSTRUCTOR_ID,
6564: UNIT_SECTION_OCCURRENCE_ID,
6565: INSTRUCTOR_ID,
6566: CREATED_BY ,

Line 6572: igs_ps_uso_instrctrs_s.nextval,

6568: LAST_UPDATED_BY,
6569: LAST_UPDATE_DATE ,
6570: LAST_UPDATE_LOGIN
6571: ) VALUES (
6572: igs_ps_uso_instrctrs_s.nextval,
6573: p_tab_uso_ins(I).system_uso_id,
6574: p_tab_uso_ins(I).system_instructor_id,
6575: g_n_user_id,
6576: sysdate,

Line 6582: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_uso_ins_ovrd.Insert_for_IGS_PS_USO_INSTRCTRS',

6578: sysdate,
6579: g_n_login_id
6580: );
6581: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6582: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_uso_ins_ovrd.Insert_for_IGS_PS_USO_INSTRCTRS',
6583: 'Unit code:'||p_tab_uso_ins(I).unit_cd||' '||'Version number:'||p_tab_uso_ins(I).version_number||' '||
6584: 'teach_cal_alternate_code:'||p_tab_uso_ins(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_uso_ins(I).location_cd
6585: ||' '||'Unit Class:'||p_tab_uso_ins(I).unit_class||' '||'instructor_person_number:'||p_tab_uso_ins(I).instructor_person_number
6586: ||' '||'occurrence_identifier'||p_tab_uso_ins(I).occurrence_identifier

Line 6769: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;

6765: Known limitations,enhancements,remarks:
6766: Change History
6767: Who When What
6768: ***********************************************************************************************/
6769: l_n_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE;
6770: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
6771: l_d_start_dt igs_ps_usec_occurs_all.start_date%TYPE;
6772: l_d_end_dt igs_ps_usec_occurs_all.end_date%TYPE;
6773: l_message_name VARCHAR2(30);