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

Line 173: igs_ca_inst ci

169: uso.thursday,uso.friday,uso.saturday , uso.sunday,uso.start_date,uso.end_date
170: FROM igs_ps_usec_occurs uso ,
171: igs_ps_uso_instrctrs usoi ,
172: igs_ps_unit_ofr_opt uoo ,
173: igs_ca_inst ci
174: WHERE usoi.instructor_id = p_person_id AND
175: usoi.unit_section_occurrence_id <> p_unit_section_occurrence_id AND
176: usoi.unit_section_occurrence_id = uso.unit_section_occurrence_id AND
177: uoo.uoo_id = uso.uoo_id AND

Line 334: cal_type igs_ca_inst_all.cal_type%TYPE,

330: FROM igs_ps_fac_tcft_tmp ;
331:
332:
333: TYPE teach_cal_rec IS RECORD(
334: cal_type igs_ca_inst_all.cal_type%TYPE,
335: sequence_number igs_ca_inst_all.sequence_number%TYPE
336: );
337: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
338: teachCalendar_tbl teachCalendar;

Line 335: sequence_number igs_ca_inst_all.sequence_number%TYPE

331:
332:
333: TYPE teach_cal_rec IS RECORD(
334: cal_type igs_ca_inst_all.cal_type%TYPE,
335: sequence_number igs_ca_inst_all.sequence_number%TYPE
336: );
337: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
338: teachCalendar_tbl teachCalendar;
339: l_n_counter NUMBER(10);

Line 369: igs_ca_inst ci

365: uoo.ci_sequence_number
366: FROM igs_ps_usec_occurs uso,
367: igs_ps_uso_instrctrs usoi ,
368: igs_ps_unit_ofr_opt uoo ,
369: igs_ca_inst ci
370: WHERE usoi.instructor_id = p_person_id AND
371: usoi.unit_section_occurrence_id = uso.unit_section_occurrence_id AND
372: uso.uoo_id = uoo.uoo_id AND
373: uoo.cal_type = ci.cal_type AND

Line 397: igs_ca_inst ci

393: uoo.ci_sequence_number
394: FROM igs_ps_usec_occurs uso,
395: igs_ps_uso_instrctrs usoi ,
396: igs_ps_unit_ofr_opt uoo ,
397: igs_ca_inst ci
398: WHERE usoi.instructor_id > -1 AND
399: usoi.unit_section_occurrence_id = uso.unit_section_occurrence_id AND
400: uso.uoo_id = uoo.uoo_id AND
401: uoo.cal_type = ci.cal_type AND

Line 566: l_source_cal_type igs_ca_inst.cal_type%TYPE ;

562: -- run the rollover for all the instructors if null
563: -- the source and dest calendars passed must be of the same calendar category
564: --and source is earlier than the dest
565: --
566: l_source_cal_type igs_ca_inst.cal_type%TYPE ;
567: l_dest_cal_type igs_ca_inst.cal_type%TYPE;
568: l_source_sequence_number igs_ca_inst.sequence_number%TYPE;
569: l_dest_sequence_number igs_ca_inst.sequence_number%TYPE;
570: l_source_start_date igs_ca_inst.start_dt%TYPE ;

Line 567: l_dest_cal_type igs_ca_inst.cal_type%TYPE;

563: -- the source and dest calendars passed must be of the same calendar category
564: --and source is earlier than the dest
565: --
566: l_source_cal_type igs_ca_inst.cal_type%TYPE ;
567: l_dest_cal_type igs_ca_inst.cal_type%TYPE;
568: l_source_sequence_number igs_ca_inst.sequence_number%TYPE;
569: l_dest_sequence_number igs_ca_inst.sequence_number%TYPE;
570: l_source_start_date igs_ca_inst.start_dt%TYPE ;
571: l_dest_start_date igs_ca_inst.start_dt%TYPE ;

Line 568: l_source_sequence_number igs_ca_inst.sequence_number%TYPE;

564: --and source is earlier than the dest
565: --
566: l_source_cal_type igs_ca_inst.cal_type%TYPE ;
567: l_dest_cal_type igs_ca_inst.cal_type%TYPE;
568: l_source_sequence_number igs_ca_inst.sequence_number%TYPE;
569: l_dest_sequence_number igs_ca_inst.sequence_number%TYPE;
570: l_source_start_date igs_ca_inst.start_dt%TYPE ;
571: l_dest_start_date igs_ca_inst.start_dt%TYPE ;
572: l_source_cal_cat igs_ca_type.s_cal_cat%TYPE ;

Line 569: l_dest_sequence_number igs_ca_inst.sequence_number%TYPE;

565: --
566: l_source_cal_type igs_ca_inst.cal_type%TYPE ;
567: l_dest_cal_type igs_ca_inst.cal_type%TYPE;
568: l_source_sequence_number igs_ca_inst.sequence_number%TYPE;
569: l_dest_sequence_number igs_ca_inst.sequence_number%TYPE;
570: l_source_start_date igs_ca_inst.start_dt%TYPE ;
571: l_dest_start_date igs_ca_inst.start_dt%TYPE ;
572: l_source_cal_cat igs_ca_type.s_cal_cat%TYPE ;
573: l_dest_cal_cat igs_ca_type.s_cal_cat%TYPE ;

Line 570: l_source_start_date igs_ca_inst.start_dt%TYPE ;

566: l_source_cal_type igs_ca_inst.cal_type%TYPE ;
567: l_dest_cal_type igs_ca_inst.cal_type%TYPE;
568: l_source_sequence_number igs_ca_inst.sequence_number%TYPE;
569: l_dest_sequence_number igs_ca_inst.sequence_number%TYPE;
570: l_source_start_date igs_ca_inst.start_dt%TYPE ;
571: l_dest_start_date igs_ca_inst.start_dt%TYPE ;
572: l_source_cal_cat igs_ca_type.s_cal_cat%TYPE ;
573: l_dest_cal_cat igs_ca_type.s_cal_cat%TYPE ;
574: l_fac_wl_id igs_ps_fac_wl.fac_wl_id%TYPE DEFAULT NULL;

Line 571: l_dest_start_date igs_ca_inst.start_dt%TYPE ;

567: l_dest_cal_type igs_ca_inst.cal_type%TYPE;
568: l_source_sequence_number igs_ca_inst.sequence_number%TYPE;
569: l_dest_sequence_number igs_ca_inst.sequence_number%TYPE;
570: l_source_start_date igs_ca_inst.start_dt%TYPE ;
571: l_dest_start_date igs_ca_inst.start_dt%TYPE ;
572: l_source_cal_cat igs_ca_type.s_cal_cat%TYPE ;
573: l_dest_cal_cat igs_ca_type.s_cal_cat%TYPE ;
574: l_fac_wl_id igs_ps_fac_wl.fac_wl_id%TYPE DEFAULT NULL;
575: