APPS.IGS_PS_GEN_001 dependencies on IGS_PS_USEC_TCH_RESP

Line 2222: FROM igs_ps_usec_tch_resp

2218:
2219: --11
2220: CURSOR usec_tchr ( p_uoo_id NUMBER) IS
2221: SELECT *
2222: FROM igs_ps_usec_tch_resp
2223: WHERE uoo_id = p_uoo_id;
2224:
2225: --12
2226: CURSOR usec_as ( p_uoo_id NUMBER) IS

Line 2373: CURSOR cur_usec_tchr_lead(cp_uoo_id igs_ps_usec_tch_resp.uoo_id%TYPE) IS

2369: AND us_ass_item_group_id = cp_us_ass_item_group_id;
2370: l_c_var VARCHAR2(1);
2371:
2372: --To find if there is any lead instructor in the Destination
2373: CURSOR cur_usec_tchr_lead(cp_uoo_id igs_ps_usec_tch_resp.uoo_id%TYPE) IS
2374: SELECT instructor_id
2375: FROM igs_ps_usec_tch_resp
2376: WHERE uoo_id = cp_uoo_id
2377: AND lead_instructor_flag = 'Y';

Line 2375: FROM igs_ps_usec_tch_resp

2371:
2372: --To find if there is any lead instructor in the Destination
2373: CURSOR cur_usec_tchr_lead(cp_uoo_id igs_ps_usec_tch_resp.uoo_id%TYPE) IS
2374: SELECT instructor_id
2375: FROM igs_ps_usec_tch_resp
2376: WHERE uoo_id = cp_uoo_id
2377: AND lead_instructor_flag = 'Y';
2378: cur_usec_tchr_lead_rec cur_usec_tchr_lead%ROWTYPE;
2379:

Line 2381: CURSOR cur_usec_tchr1(cp_uoo_id igs_ps_usec_tch_resp.uoo_id%TYPE,cp_ins igs_ps_usec_tch_resp.instructor_id%TYPE) IS

2377: AND lead_instructor_flag = 'Y';
2378: cur_usec_tchr_lead_rec cur_usec_tchr_lead%ROWTYPE;
2379:
2380: --To find if the occurrence instructor passed is a lead in the source.
2381: CURSOR cur_usec_tchr1(cp_uoo_id igs_ps_usec_tch_resp.uoo_id%TYPE,cp_ins igs_ps_usec_tch_resp.instructor_id%TYPE) IS
2382: SELECT instructor_id
2383: FROM igs_ps_usec_tch_resp
2384: WHERE uoo_id = cp_uoo_id
2385: AND lead_instructor_flag = 'Y'

Line 2383: FROM igs_ps_usec_tch_resp

2379:
2380: --To find if the occurrence instructor passed is a lead in the source.
2381: CURSOR cur_usec_tchr1(cp_uoo_id igs_ps_usec_tch_resp.uoo_id%TYPE,cp_ins igs_ps_usec_tch_resp.instructor_id%TYPE) IS
2382: SELECT instructor_id
2383: FROM igs_ps_usec_tch_resp
2384: WHERE uoo_id = cp_uoo_id
2385: AND lead_instructor_flag = 'Y'
2386: AND instructor_id = cp_ins;
2387: cur_usec_tchr1_rec cur_usec_tchr1%ROWTYPE;

Line 2391: l_dest_lead_inst_id igs_ps_usec_tch_resp.instructor_id%TYPE;

2387: cur_usec_tchr1_rec cur_usec_tchr1%ROWTYPE;
2388:
2389:
2390: l_resp_flag BOOLEAN ;
2391: l_dest_lead_inst_id igs_ps_usec_tch_resp.instructor_id%TYPE;
2392:
2393: ---------------------------
2394: CURSOR cur_ftci(cp_c_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
2395: cp_n_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS

Line 3263: CURSOR cur_usec_tchr_new (cp_uoo_id igs_ps_usec_tch_resp.uoo_id%TYPE,

3259:
3260: -- Rollover of unit section teaching responsibility records
3261: FOR usec_tchr_rec IN usec_tchr(p_old_uoo_Id ) LOOP
3262: DECLARE
3263: CURSOR cur_usec_tchr_new (cp_uoo_id igs_ps_usec_tch_resp.uoo_id%TYPE,
3264: cp_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE) IS
3265: SELECT 'X'
3266: FROM igs_ps_usec_tch_resp
3267: WHERE uoo_id = cp_uoo_id

Line 3264: cp_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE) IS

3260: -- Rollover of unit section teaching responsibility records
3261: FOR usec_tchr_rec IN usec_tchr(p_old_uoo_Id ) LOOP
3262: DECLARE
3263: CURSOR cur_usec_tchr_new (cp_uoo_id igs_ps_usec_tch_resp.uoo_id%TYPE,
3264: cp_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE) IS
3265: SELECT 'X'
3266: FROM igs_ps_usec_tch_resp
3267: WHERE uoo_id = cp_uoo_id
3268: AND instructor_id = cp_instructor_id

Line 3266: FROM igs_ps_usec_tch_resp

3262: DECLARE
3263: CURSOR cur_usec_tchr_new (cp_uoo_id igs_ps_usec_tch_resp.uoo_id%TYPE,
3264: cp_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE) IS
3265: SELECT 'X'
3266: FROM igs_ps_usec_tch_resp
3267: WHERE uoo_id = cp_uoo_id
3268: AND instructor_id = cp_instructor_id
3269: AND ROWNUM = 1;
3270: l_cur_usec_tchr_new cur_usec_tchr_new%ROWTYPE;

Line 3294: igs_ps_usec_tch_resp_pkg.insert_row(

3290: CLOSE c_tch_ins;
3291: OPEN cur_usec_tchr_new(p_new_uoo_id, usec_tchr_rec.instructor_id);
3292: FETCH cur_usec_tchr_new INTO l_cur_usec_tchr_new;
3293: IF cur_usec_tchr_new%NOTFOUND AND l_ins_exists THEN
3294: igs_ps_usec_tch_resp_pkg.insert_row(
3295: x_rowid => lv_rowid,
3296: x_unit_section_teach_resp_id => l_usec_tchr_id,
3297: x_instructor_id => usec_tchr_rec.instructor_id ,
3298: x_confirmed_flag => usec_tchr_rec.confirmed_flag ,

Line 4455: FROM igs_ps_usec_tch_resp utr,igs_ps_unit_ofr_opt_all opt

4451: )IS
4452: SELECT NVL(utr.INSTRUCTIONAL_LOAD_LAB,0) +
4453: NVL(utr.INSTRUCTIONAL_LOAD_LECTURE,0) +
4454: NVL(utr.INSTRUCTIONAL_LOAD,0) teach_wl
4455: FROM igs_ps_usec_tch_resp utr,igs_ps_unit_ofr_opt_all opt
4456: WHERE utr.instructor_id = cp_n_person_id AND
4457: utr.uoo_id = opt.uoo_id AND
4458: opt.cal_type = cp_c_cal_type AND
4459: utr.confirmed_flag = 'Y' AND