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_VALIDATE_LGCY_PKG dependencies on IGS_PS_USEC_TCH_RESP

Line 1318: FROM igs_ps_usec_tch_resp iputr

1314: AND version_number = cp_ver_num;
1315:
1316: CURSOR c_teach_resp(p_uoo_id NUMBER) IS
1317: SELECT rowid,iputr.*
1318: FROM igs_ps_usec_tch_resp iputr
1319: WHERE iputr.uoo_id = p_uoo_id
1320: AND iputr.percentage_allocation IS NOT NULL
1321: AND iputr.instructional_load_lab IS NULL
1322: AND iputr.instructional_load_lecture IS NULL

Line 1332: l_new_lab igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE;

1328: FROM igs_ps_usec_cps
1329: WHERE uoo_id = cp_n_uoo_id;
1330:
1331: c_usec_cp_rec c_usec_cp%ROWTYPE;
1332: l_new_lab igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE;
1333: l_new_lecture igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE;
1334: l_new_other igs_ps_usec_tch_resp_v.instructional_load%TYPE;
1335:
1336: l_c_override_ind igs_ps_unit_ver_all.points_override_ind%TYPE;

Line 1333: l_new_lecture igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE;

1329: WHERE uoo_id = cp_n_uoo_id;
1330:
1331: c_usec_cp_rec c_usec_cp%ROWTYPE;
1332: l_new_lab igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE;
1333: l_new_lecture igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE;
1334: l_new_other igs_ps_usec_tch_resp_v.instructional_load%TYPE;
1335:
1336: l_c_override_ind igs_ps_unit_ver_all.points_override_ind%TYPE;
1337: l_c_message VARCHAR2(30);

Line 1334: l_new_other igs_ps_usec_tch_resp_v.instructional_load%TYPE;

1330:
1331: c_usec_cp_rec c_usec_cp%ROWTYPE;
1332: l_new_lab igs_ps_usec_tch_resp_v.instructional_load_lab%TYPE;
1333: l_new_lecture igs_ps_usec_tch_resp_v.instructional_load_lecture%TYPE;
1334: l_new_other igs_ps_usec_tch_resp_v.instructional_load%TYPE;
1335:
1336: l_c_override_ind igs_ps_unit_ver_all.points_override_ind%TYPE;
1337: l_c_message VARCHAR2(30);
1338:

Line 1384: igs_ps_usec_tch_resp_pkg.update_row (

1380: l_new_lecture:=((c_teach_resp_rec.percentage_allocation/100)* p_usec_rec.work_load_cp_lecture);
1381: l_new_lab:=((c_teach_resp_rec.percentage_allocation/100)* p_usec_rec.work_load_cp_lab);
1382: l_new_other:=((c_teach_resp_rec.percentage_allocation/100)* p_usec_rec.work_load_other);
1383:
1384: igs_ps_usec_tch_resp_pkg.update_row (
1385: x_mode => 'R',
1386: x_rowid => c_teach_resp_rec.rowid,
1387: x_unit_section_teach_resp_id => c_teach_resp_rec.unit_section_teach_resp_id,
1388: x_instructor_id => c_teach_resp_rec.instructor_id,

Line 3296: CURSOR c_check_instrctr_exists(cp_n_instructor_id IGS_PS_USEC_TCH_RESP.INSTRUCTOR_ID%TYPE,

3292: Erroring out if the calculated workload exceeds the expected workload / calendar category is not at all set up /
3293: work load is not set up for employment category of instrutor getting imported.
3294: ********************************************************************************************** */
3295:
3296: CURSOR c_check_instrctr_exists(cp_n_instructor_id IGS_PS_USEC_TCH_RESP.INSTRUCTOR_ID%TYPE,
3297: cp_n_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
3298: SELECT COUNT(*)
3299: FROM igs_ps_usec_tch_resp
3300: WHERE instructor_id = cp_n_instructor_id

Line 3299: FROM igs_ps_usec_tch_resp

3295:
3296: CURSOR c_check_instrctr_exists(cp_n_instructor_id IGS_PS_USEC_TCH_RESP.INSTRUCTOR_ID%TYPE,
3297: cp_n_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
3298: SELECT COUNT(*)
3299: FROM igs_ps_usec_tch_resp
3300: WHERE instructor_id = cp_n_instructor_id
3301: AND uoo_id = cp_n_uoo_id
3302: AND ROWNUM = 1;
3303:

Line 3306: FROM IGS_PS_USEC_TCH_RESP

3302: AND ROWNUM = 1;
3303:
3304: CURSOR c_lead_cnd (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%type) IS
3305: SELECT COUNT(*)
3306: FROM IGS_PS_USEC_TCH_RESP
3307: WHERE lead_instructor_flag='Y'
3308: AND uoo_id = cp_n_uoo_id
3309: AND ROWNUM = 1;
3310:

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

3321: WHERE ROWNUM=1;
3322:
3323: rec_cal_inst c_cal_inst%ROWTYPE;
3324:
3325: l_n_t_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE :=0;
3326: l_n_t_lab igs_ps_usec_tch_resp.instructional_load_lab%TYPE :=0;
3327: l_n_t_other igs_ps_usec_tch_resp.instructional_load%TYPE :=0;
3328: l_n_total_wl NUMBER(10,2);
3329: l_n_exp_wl NUMBER(6,2);

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

3322:
3323: rec_cal_inst c_cal_inst%ROWTYPE;
3324:
3325: l_n_t_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE :=0;
3326: l_n_t_lab igs_ps_usec_tch_resp.instructional_load_lab%TYPE :=0;
3327: l_n_t_other igs_ps_usec_tch_resp.instructional_load%TYPE :=0;
3328: l_n_total_wl NUMBER(10,2);
3329: l_n_exp_wl NUMBER(6,2);
3330: l_n_tot_fac_wl NUMBER(10,2);

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

3323: rec_cal_inst c_cal_inst%ROWTYPE;
3324:
3325: l_n_t_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE :=0;
3326: l_n_t_lab igs_ps_usec_tch_resp.instructional_load_lab%TYPE :=0;
3327: l_n_t_other igs_ps_usec_tch_resp.instructional_load%TYPE :=0;
3328: l_n_total_wl NUMBER(10,2);
3329: l_n_exp_wl NUMBER(6,2);
3330: l_n_tot_fac_wl NUMBER(10,2);
3331: l_c_cal VARCHAR2(1);

Line 3363: igs_ps_usec_tch_resp_pkg.check_constraints('LEAD_INSTRUCTOR_FLAG', p_uso_ins_rec.lead_instructor_flag);

3359: END IF;
3360:
3361: -- Check constraints
3362: BEGIN
3363: igs_ps_usec_tch_resp_pkg.check_constraints('LEAD_INSTRUCTOR_FLAG', p_uso_ins_rec.lead_instructor_flag);
3364: EXCEPTION
3365: WHEN OTHERS THEN
3366: fnd_message.set_name('IGS','IGS_PS_LEAD_INSTRUCTOR_FLAG');
3367: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',fnd_message.get, NULL,TRUE);

Line 3371: igs_ps_usec_tch_resp_pkg.check_constraints('CONFIRMED_FLAG', p_uso_ins_rec.confirmed_flag);

3367: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',fnd_message.get, NULL,TRUE);
3368: p_uso_ins_rec.status :='E';
3369: END;
3370: BEGIN
3371: igs_ps_usec_tch_resp_pkg.check_constraints('CONFIRMED_FLAG', p_uso_ins_rec.confirmed_flag);
3372: EXCEPTION
3373: WHEN OTHERS THEN
3374: fnd_message.set_name('IGS','IGS_PS_CONFIRMED_FLAG');
3375: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',fnd_message.get, NULL,TRUE);

Line 3393: igs_ps_usec_tch_resp_pkg.check_constraints('PERCENTAGE_ALLOCATION', p_uso_ins_rec.wl_percentage_allocation);

3389: END IF;
3390:
3391: IF p_uso_ins_rec.wl_percentage_allocation IS NOT NULL THEN
3392: BEGIN
3393: igs_ps_usec_tch_resp_pkg.check_constraints('PERCENTAGE_ALLOCATION', p_uso_ins_rec.wl_percentage_allocation);
3394: EXCEPTION
3395: WHEN OTHERS THEN
3396: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PTS_RANGE_0_999','PERCENTAGE','LEGACY_TOKENS',TRUE);
3397: p_uso_ins_rec.status :='E';

Line 3411: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LECTURE', p_uso_ins_rec.instructional_load_lecture);

3407: END IF;
3408:
3409: IF p_uso_ins_rec.instructional_load_lecture IS NOT NULL THEN
3410: BEGIN
3411: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LECTURE', p_uso_ins_rec.instructional_load_lecture);
3412: EXCEPTION
3413: WHEN OTHERS THEN
3414: fnd_message.set_name('IGS','IGS_PS_INS_LOAD_LECTURE');
3415: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99',fnd_message.get, NULL,TRUE);

Line 3432: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LAB', p_uso_ins_rec.instructional_load_laboratory);

3428: END IF;
3429:
3430: IF p_uso_ins_rec.instructional_load_laboratory IS NOT NULL THEN
3431: BEGIN
3432: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD_LAB', p_uso_ins_rec.instructional_load_laboratory);
3433: EXCEPTION
3434: WHEN OTHERS THEN
3435: fnd_message.set_name('IGS','IGS_PS_INS_LOAD_LAB');
3436: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99',fnd_message.get,NULL,TRUE);

Line 3453: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD', p_uso_ins_rec.instructional_load_other);

3449: END IF;
3450:
3451: IF p_uso_ins_rec.instructional_load_other IS NOT NULL THEN
3452: BEGIN
3453: igs_ps_usec_tch_resp_pkg.check_constraints('INSTRUCTIONAL_LOAD', p_uso_ins_rec.instructional_load_other);
3454: EXCEPTION
3455: WHEN OTHERS THEN
3456: fnd_message.set_name('IGS','IGS_PS_INS_LOAD_OTHER');
3457: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99',fnd_message.get,NULL,TRUE);

Line 3541: INSERT INTO IGS_PS_USEC_TCH_RESP(

3537: CLOSE c_cal_inst;
3538: END IF;
3539: END IF;
3540: IF p_uso_ins_rec.status = 'S' THEN
3541: INSERT INTO IGS_PS_USEC_TCH_RESP(
3542: UNIT_SECTION_TEACH_RESP_ID,
3543: UOO_ID,
3544: INSTRUCTOR_ID,
3545: CONFIRMED_FLAG,

Line 3557: IGS_PS_USEC_TCH_RESP_S.nextval,

3553: LAST_UPDATED_BY,
3554: LAST_UPDATE_DATE,
3555: LAST_UPDATE_LOGIN
3556: ) VALUES (
3557: IGS_PS_USEC_TCH_RESP_S.nextval,
3558: p_n_uoo_id,
3559: p_n_ins_id,
3560: p_uso_ins_rec.confirmed_flag,
3561: p_uso_ins_rec.wl_percentage_allocation,

Line 3600: FROM IGS_PS_USEC_TCH_RESP

3596: l_tab_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
3597:
3598: CURSOR c_count_lead (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3599: SELECT count(*)
3600: FROM IGS_PS_USEC_TCH_RESP
3601: WHERE uoo_id = cp_n_uoo_id
3602: AND lead_instructor_flag = 'Y';
3603:
3604: CURSOR c_count_percent(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

Line 3606: FROM IGS_PS_USEC_TCH_RESP

3602: AND lead_instructor_flag = 'Y';
3603:
3604: CURSOR c_count_percent(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3605: SELECT SUM(PERCENTAGE_ALLOCATION)
3606: FROM IGS_PS_USEC_TCH_RESP
3607: WHERE confirmed_flag = 'Y'
3608: AND uoo_id = cp_n_uoo_id;
3609:
3610: CURSOR c_unit_dtls (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS