eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USEC_TCH_RESP

Line 6474: FROM igs_ps_usec_tch_resp

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'
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

Line 6519: DELETE igs_ps_usec_tch_resp WHERE instructor_id=p_tab_uso_ins(I).system_instructor_id AND

6515: p_tab_uso_ins(I).msg_to := fnd_msg_pub.count_msg;
6516: p_delete_status:= FALSE;
6517: RETURN;
6518: ELSE
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',

Line 6899: igs_ps_usec_tch_resp_pkg.check_constraints('LEAD_INSTRUCTOR_FLAG', p_usec_teach_resp_rec.lead_instructor_flag);

6895: p_usec_teach_resp_rec.status :='E';
6896: END;
6897:
6898: BEGIN
6899: igs_ps_usec_tch_resp_pkg.check_constraints('LEAD_INSTRUCTOR_FLAG', p_usec_teach_resp_rec.lead_instructor_flag);
6900: EXCEPTION
6901: WHEN OTHERS THEN
6902: fnd_message.set_name('IGS','IGS_PS_LEAD_INSTRUCTOR_FLAG');
6903: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',fnd_message.get, NULL,TRUE);

Line 6908: igs_ps_usec_tch_resp_pkg.check_constraints('CONFIRMED_FLAG', p_usec_teach_resp_rec.confirmed_flag);

6904: p_usec_teach_resp_rec.status :='E';
6905: END;
6906:
6907: BEGIN
6908: igs_ps_usec_tch_resp_pkg.check_constraints('CONFIRMED_FLAG', p_usec_teach_resp_rec.confirmed_flag);
6909: EXCEPTION
6910: WHEN OTHERS THEN
6911: fnd_message.set_name('IGS','IGS_PS_CONFIRMED_FLAG');
6912: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',fnd_message.get, NULL,TRUE);

Line 6918: igs_ps_usec_tch_resp_pkg.check_constraints('PERCENTAGE_ALLOCATION', p_usec_teach_resp_rec.wl_percentage_allocation);

6914: END;
6915:
6916: IF p_usec_teach_resp_rec.wl_percentage_allocation IS NOT NULL THEN
6917: BEGIN
6918: igs_ps_usec_tch_resp_pkg.check_constraints('PERCENTAGE_ALLOCATION', p_usec_teach_resp_rec.wl_percentage_allocation);
6919: EXCEPTION
6920: WHEN OTHERS THEN
6921: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PTS_RANGE_0_999','PERCENTAGE','LEGACY_TOKENS',TRUE);
6922: p_usec_teach_resp_rec.status :='E';

Line 6928: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LECTURE', p_usec_teach_resp_rec.instructional_load_lecture);

6924: END IF;
6925:
6926: IF p_usec_teach_resp_rec.instructional_load_lecture IS NOT NULL THEN
6927: BEGIN
6928: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LECTURE', p_usec_teach_resp_rec.instructional_load_lecture);
6929: EXCEPTION
6930: WHEN OTHERS THEN
6931: fnd_message.set_name('IGS','IGS_PS_INS_LOAD_LECTURE');
6932: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99',fnd_message.get, NULL,TRUE);

Line 6939: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LAB', p_usec_teach_resp_rec.instructional_load_laboratory);

6935: END IF;
6936:
6937: IF p_usec_teach_resp_rec.instructional_load_laboratory IS NOT NULL THEN
6938: BEGIN
6939: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LAB', p_usec_teach_resp_rec.instructional_load_laboratory);
6940: EXCEPTION
6941: WHEN OTHERS THEN
6942: fnd_message.set_name('IGS','IGS_PS_INS_LOAD_LAB');
6943: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99',fnd_message.get,NULL,TRUE);

Line 6950: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD', p_usec_teach_resp_rec.instructional_load_other);

6946: END IF;
6947:
6948: IF p_usec_teach_resp_rec.instructional_load_other IS NOT NULL THEN
6949: BEGIN
6950: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD', p_usec_teach_resp_rec.instructional_load_other);
6951: EXCEPTION
6952: WHEN OTHERS THEN
6953: fnd_message.set_name('IGS','IGS_PS_INS_LOAD_OTHER');
6954: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99',fnd_message.get,NULL,TRUE);

Line 6976: FROM igs_ps_usec_tch_resp

6972:
6973: PROCEDURE Assign_default(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS
6974: CURSOR cur_resp(cp_n_uoo_id IN NUMBER,cp_n_ins_id IN NUMBER) IS
6975: SELECT *
6976: FROM igs_ps_usec_tch_resp
6977: WHERE instructor_id = cp_n_ins_id
6978: AND uoo_id = cp_n_uoo_id;
6979: l_cur_resp cur_resp%ROWTYPE;
6980:

Line 7034: FROM IGS_PS_USEC_TCH_RESP

7030:
7031: PROCEDURE Business_validation(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS
7032: CURSOR c_lead_cnd (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%type) IS
7033: SELECT COUNT(*)
7034: FROM IGS_PS_USEC_TCH_RESP
7035: WHERE lead_instructor_flag='Y'
7036: AND uoo_id = cp_n_uoo_id
7037: AND ROWNUM = 1;
7038:

Line 7053: l_n_t_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE :=0;

7049: WHERE ROWNUM=1;
7050:
7051: rec_cal_inst c_cal_inst%ROWTYPE;
7052:
7053: l_n_t_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE :=0;
7054: l_n_t_lab igs_ps_usec_tch_resp.instructional_load_lab%TYPE :=0;
7055: l_n_t_other igs_ps_usec_tch_resp.instructional_load%TYPE :=0;
7056: l_n_total_wl NUMBER(10,2);
7057: l_n_exp_wl NUMBER(6,2);

Line 7054: l_n_t_lab igs_ps_usec_tch_resp.instructional_load_lab%TYPE :=0;

7050:
7051: rec_cal_inst c_cal_inst%ROWTYPE;
7052:
7053: l_n_t_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE :=0;
7054: l_n_t_lab igs_ps_usec_tch_resp.instructional_load_lab%TYPE :=0;
7055: l_n_t_other igs_ps_usec_tch_resp.instructional_load%TYPE :=0;
7056: l_n_total_wl NUMBER(10,2);
7057: l_n_exp_wl NUMBER(6,2);
7058: l_n_tot_fac_wl NUMBER(10,2);

Line 7055: l_n_t_other igs_ps_usec_tch_resp.instructional_load%TYPE :=0;

7051: rec_cal_inst c_cal_inst%ROWTYPE;
7052:
7053: l_n_t_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE :=0;
7054: l_n_t_lab igs_ps_usec_tch_resp.instructional_load_lab%TYPE :=0;
7055: l_n_t_other igs_ps_usec_tch_resp.instructional_load%TYPE :=0;
7056: l_n_total_wl NUMBER(10,2);
7057: l_n_exp_wl NUMBER(6,2);
7058: l_n_tot_fac_wl NUMBER(10,2);
7059: l_c_cal VARCHAR2(1);

Line 7152: FROM IGS_PS_USEC_TCH_RESP

7148: l_tab_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
7149:
7150: CURSOR c_count_lead (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
7151: SELECT count(*)
7152: FROM IGS_PS_USEC_TCH_RESP
7153: WHERE uoo_id = cp_n_uoo_id
7154: AND lead_instructor_flag = 'Y';
7155:
7156: CURSOR c_count_percent(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

Line 7158: FROM IGS_PS_USEC_TCH_RESP

7154: AND lead_instructor_flag = 'Y';
7155:
7156: CURSOR c_count_percent(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
7157: SELECT SUM(PERCENTAGE_ALLOCATION)
7158: FROM IGS_PS_USEC_TCH_RESP
7159: WHERE confirmed_flag = 'Y'
7160: AND uoo_id = cp_n_uoo_id;
7161:
7162: CURSOR c_unit_dtls (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

Line 7410: UPDATE IGS_PS_USEC_TCH_RESP SET

7406: END IF;
7407:
7408: IF p_usec_teach_resp_tbl(I).status = 'S' THEN
7409:
7410: UPDATE IGS_PS_USEC_TCH_RESP SET
7411: confirmed_flag = p_usec_teach_resp_tbl(I).confirmed_flag ,
7412: lead_instructor_flag = p_usec_teach_resp_tbl(I).lead_instructor_flag,
7413: instructional_load = p_usec_teach_resp_tbl(I).instructional_load_other,
7414: instructional_load_lab = p_usec_teach_resp_tbl(I).instructional_load_laboratory,