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_GEN_001 dependencies on IGS_CA_INST

Line 248: -- Find the latest IGS_CA_INST of IGS_PS_OFR_INST

244: EXISTS (SELECT 1
245: FROM IGS_GE_NOTE nte
246: WHERE nte.reference_number = coon.reference_number AND
247: nte.note_text IS NOT NULL);
248: -- Find the latest IGS_CA_INST of IGS_PS_OFR_INST
249: -- which returns the list in descending order, and the first record
250: -- (ie. the latest instance) will be selected
251: CURSOR gc_coi_rec IS
252: SELECT *

Line 2334: igs_ca_inst ci,

2330: CURSOR c_fee_type_cal_exists(cp_c_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
2331: SELECT ci.cal_type,ci.sequence_number
2332: FROM igs_fi_fee_type ft,
2333: igs_fi_f_typ_ca_inst ftci,
2334: igs_ca_inst ci,
2335: igs_ca_type ct,
2336: igs_ca_stat cs
2337: WHERE ft.s_fee_type IN ('TUTNFEE', 'OTHER', 'SPECIAL', 'AUDIT')
2338: AND ft.closed_ind = 'N'

Line 2348: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS

2344: AND ct.s_cal_cat = 'FEE'
2345: AND ci.cal_status = cs.cal_status
2346: AND cs.s_cal_status = 'ACTIVE';
2347:
2348: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
2349: SELECT start_dt,end_dt
2350: FROM igs_ca_inst_all
2351: WHERE cal_type = cp_cal_type
2352: AND sequence_number = cp_seq_num;

Line 2350: FROM igs_ca_inst_all

2346: AND cs.s_cal_status = 'ACTIVE';
2347:
2348: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
2349: SELECT start_dt,end_dt
2350: FROM igs_ca_inst_all
2351: WHERE cal_type = cp_cal_type
2352: AND sequence_number = cp_seq_num;
2353:
2354: l_d_src_teach_cal_start_dt DATE;

Line 2397: FROM igs_ca_inst_rel

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
2396: SELECT sup_cal_type cal_type, sup_ci_sequence_number sequence_number
2397: FROM igs_ca_inst_rel
2398: WHERE (sub_cal_type,sub_ci_sequence_number) IN (SELECT load_cal_type, load_ci_sequence_number
2399: FROM igs_ca_teach_to_load_v
2400: WHERE teach_cal_type = cp_c_cal_type
2401: AND teach_ci_sequence_number = cp_n_sequence_number);

Line 2403: cal_type igs_ca_inst_all.cal_type%TYPE,

2399: FROM igs_ca_teach_to_load_v
2400: WHERE teach_cal_type = cp_c_cal_type
2401: AND teach_ci_sequence_number = cp_n_sequence_number);
2402: TYPE teach_cal_rec IS RECORD(
2403: cal_type igs_ca_inst_all.cal_type%TYPE,
2404: sequence_number igs_ca_inst_all.sequence_number%TYPE
2405: );
2406: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
2407: teachCalendar_tbl teachCalendar;

Line 2404: sequence_number igs_ca_inst_all.sequence_number%TYPE

2400: WHERE teach_cal_type = cp_c_cal_type
2401: AND teach_ci_sequence_number = cp_n_sequence_number);
2402: TYPE teach_cal_rec IS RECORD(
2403: cal_type igs_ca_inst_all.cal_type%TYPE,
2404: sequence_number igs_ca_inst_all.sequence_number%TYPE
2405: );
2406: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
2407: teachCalendar_tbl teachCalendar;
2408: l_n_counter NUMBER(10);

Line 3982: igs_ca_inst ci,

3978: CURSOR c_fee_type_exists(cp_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
3979: SELECT ci.cal_type,ci.sequence_number
3980: FROM igs_fi_fee_type ft,
3981: igs_fi_f_typ_ca_inst ftci,
3982: igs_ca_inst ci,
3983: igs_ca_type ct,
3984: igs_ca_stat cs
3985: WHERE ft.s_fee_type = 'SPECIAL'
3986: AND ft.closed_ind = 'N'

Line 4419: cp_c_cal_type igs_ca_inst.cal_type%TYPE,

4415: l_n_exp_wl igs_ps_emp_cats_wl.expected_wl_num%TYPE:=0;
4416:
4417: /* Cursor to get the override expected workload */
4418: CURSOR c_fac_ovr_wl(cp_n_person_id hz_parties.party_id%TYPE,
4419: cp_c_cal_type igs_ca_inst.cal_type%TYPE,
4420: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE
4421: ) IS
4422: SELECT NVL(fow.new_exp_wl,0)
4423: FROM igs_ps_fac_wl fw,igs_ps_fac_ovr_wl fow

Line 4420: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE

4416:
4417: /* Cursor to get the override expected workload */
4418: CURSOR c_fac_ovr_wl(cp_n_person_id hz_parties.party_id%TYPE,
4419: cp_c_cal_type igs_ca_inst.cal_type%TYPE,
4420: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE
4421: ) IS
4422: SELECT NVL(fow.new_exp_wl,0)
4423: FROM igs_ps_fac_wl fw,igs_ps_fac_ovr_wl fow
4424: WHERE fw.person_id = cp_n_person_id AND

Line 4434: cp_c_cal_type igs_ca_inst.cal_type%TYPE,

4430: l_n_fac_ovr_wl igs_ps_fac_ovr_wl.new_exp_wl%TYPE:=0;
4431:
4432: /* Cursor to get sum of workload from assigned workload */
4433: CURSOR c_fac_assign_wl(cp_n_person_id hz_parties.party_id%TYPE,
4434: cp_c_cal_type igs_ca_inst.cal_type%TYPE,
4435: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE
4436: ) IS
4437: SELECT NVL(SUM(NVL(fat.default_wl,0)),0)
4438: FROM igs_ps_fac_wl fw,igs_ps_fac_asg_task fat

Line 4435: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE

4431:
4432: /* Cursor to get sum of workload from assigned workload */
4433: CURSOR c_fac_assign_wl(cp_n_person_id hz_parties.party_id%TYPE,
4434: cp_c_cal_type igs_ca_inst.cal_type%TYPE,
4435: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE
4436: ) IS
4437: SELECT NVL(SUM(NVL(fat.default_wl,0)),0)
4438: FROM igs_ps_fac_wl fw,igs_ps_fac_asg_task fat
4439: WHERE fw.person_id = cp_n_person_id AND

Line 4449: cp_c_cal_type igs_ca_inst.cal_type%TYPE,

4445: l_n_fac_assign_wl NUMBER:=0;
4446:
4447: /* Cursor to get sum of workload from Unit Section Teaching Responsibility */
4448: CURSOR c_tch_resp_wl(cp_n_person_id hz_parties.party_id%TYPE,
4449: cp_c_cal_type igs_ca_inst.cal_type%TYPE,
4450: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE
4451: )IS
4452: SELECT NVL(utr.INSTRUCTIONAL_LOAD_LAB,0) +
4453: NVL(utr.INSTRUCTIONAL_LOAD_LECTURE,0) +

Line 4450: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE

4446:
4447: /* Cursor to get sum of workload from Unit Section Teaching Responsibility */
4448: CURSOR c_tch_resp_wl(cp_n_person_id hz_parties.party_id%TYPE,
4449: cp_c_cal_type igs_ca_inst.cal_type%TYPE,
4450: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE
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

Line 4466: l_c_tch_cal_type igs_ca_inst.cal_type%TYPE;

4462:
4463: l_n_wl NUMBER:=0;
4464: l_n_tch_resp_wl NUMBER:=0;
4465: l_c_s_cal_cat igs_ca_type.s_cal_cat%TYPE;
4466: l_c_tch_cal_type igs_ca_inst.cal_type%TYPE;
4467: l_n_tch_cal_seq_num igs_ca_inst.sequence_number%TYPE;
4468:
4469: TYPE ref_cur_get_teach_cal IS REF CURSOR;
4470: c_get_tch_cal ref_cur_get_teach_cal;

Line 4467: l_n_tch_cal_seq_num igs_ca_inst.sequence_number%TYPE;

4463: l_n_wl NUMBER:=0;
4464: l_n_tch_resp_wl NUMBER:=0;
4465: l_c_s_cal_cat igs_ca_type.s_cal_cat%TYPE;
4466: l_c_tch_cal_type igs_ca_inst.cal_type%TYPE;
4467: l_n_tch_cal_seq_num igs_ca_inst.sequence_number%TYPE;
4468:
4469: TYPE ref_cur_get_teach_cal IS REF CURSOR;
4470: c_get_tch_cal ref_cur_get_teach_cal;
4471:

Line 4513: ' FROM igs_ca_inst_rel cir, igs_ca_type ct'||

4509:
4510: /* Cursor to get teaching calendars for respective Academic calendars */
4511:
4512: OPEN c_get_tch_cal FOR 'SELECT cir.sub_cal_type,cir.sub_ci_sequence_number'||
4513: ' FROM igs_ca_inst_rel cir, igs_ca_type ct'||
4514: ' WHERE cir.sub_cal_type = ct.cal_type AND'||
4515: ' ct.s_cal_cat = :1 AND'||
4516: ' sup_cal_type = :2 AND'||
4517: ' sup_ci_sequence_number = :3 ' USING l_c_s_cal_cat,p_c_cal_type,p_n_cal_seq_num;

Line 4587: l_c_cal_type igs_ca_inst.cal_type%TYPE;

4583: FROM igs_ps_exp_wl;
4584:
4585: l_c_cal_cat_code igs_ps_exp_wl.calendar_cat%TYPE;
4586: l_c_s_cal_cat igs_ca_type.s_cal_cat%TYPE;
4587: l_c_cal_type igs_ca_inst.cal_type%TYPE;
4588: l_n_cal_seq_num igs_ca_inst.sequence_number%TYPE;
4589:
4590:
4591: TYPE ref_cur_get_cal IS REF CURSOR;

Line 4588: l_n_cal_seq_num igs_ca_inst.sequence_number%TYPE;

4584:
4585: l_c_cal_cat_code igs_ps_exp_wl.calendar_cat%TYPE;
4586: l_c_s_cal_cat igs_ca_type.s_cal_cat%TYPE;
4587: l_c_cal_type igs_ca_inst.cal_type%TYPE;
4588: l_n_cal_seq_num igs_ca_inst.sequence_number%TYPE;
4589:
4590:
4591: TYPE ref_cur_get_cal IS REF CURSOR;
4592: c_get_cal ref_cur_get_cal;

Line 4617: ' FROM igs_ca_inst_rel cir, igs_ca_type ct'||

4613:
4614: /* Cursor for to get Academic calendar when Teach cal is passed */
4615:
4616: OPEN c_get_cal FOR 'SELECT cir.sup_cal_type,cir.sup_ci_sequence_number'||
4617: ' FROM igs_ca_inst_rel cir, igs_ca_type ct'||
4618: ' WHERE cir.sup_cal_type = ct.cal_type AND'||
4619: ' ct.s_cal_cat = :1 AND'||
4620: ' sub_cal_type = :2 AND'||
4621: ' sub_ci_sequence_number = :3 ' USING l_c_s_cal_cat,p_c_cal_type,p_n_cal_seq_num;