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_004 dependencies on IGS_CA_INST_ALL

Line 190: CURSOR cal_inst (cp_d_start_dt IN igs_ca_inst_all.start_dt%TYPE,

186: weekends_count BOOLEAN := FALSE;
187: weekends NUMBER := 0;
188:
189: --holiday cal
190: CURSOR cal_inst (cp_d_start_dt IN igs_ca_inst_all.start_dt%TYPE,
191: cp_d_end_dt IN igs_ca_inst_all.end_dt%TYPE) IS
192: SELECT
193: DISTINCT cv.alias_val
194: FROM

Line 191: cp_d_end_dt IN igs_ca_inst_all.end_dt%TYPE) IS

187: weekends NUMBER := 0;
188:
189: --holiday cal
190: CURSOR cal_inst (cp_d_start_dt IN igs_ca_inst_all.start_dt%TYPE,
191: cp_d_end_dt IN igs_ca_inst_all.end_dt%TYPE) IS
192: SELECT
193: DISTINCT cv.alias_val
194: FROM
195: igs_ca_inst ci,

Line 312: FROM igs_ca_inst_all ci,

308: -- Cursor to obtain the Teach Calendar end date
309: -- modifying the following cursor to select start date also. Also modified the from and where clause
310: CURSOR cur_teach_cal (cp_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
311: SELECT ci.start_dt, ci.end_dt
312: FROM igs_ca_inst_all ci,
313: igs_ps_unit_ofr_opt_all uoo
314: WHERE uoo.uoo_id = cp_n_uoo_id
315: AND uoo.cal_type = ci.cal_type
316: AND uoo.ci_sequence_number = ci.sequence_number;

Line 319: l_d_teach_start_dt igs_ca_inst_all.start_dt%TYPE;

315: AND uoo.cal_type = ci.cal_type
316: AND uoo.ci_sequence_number = ci.sequence_number;
317:
318: l_d_teach_end_dt igs_ps_unit_ofr_opt_v.cal_end_dt%TYPE;
319: l_d_teach_start_dt igs_ca_inst_all.start_dt%TYPE;
320: l_d_temp_end_dt igs_ca_inst_all.end_dt%TYPE;
321: l_d_temp_date igs_ca_inst_all.end_dt%TYPE;
322:
323: --Cursor to get the check whether we have to include weekends or not

Line 320: l_d_temp_end_dt igs_ca_inst_all.end_dt%TYPE;

316: AND uoo.ci_sequence_number = ci.sequence_number;
317:
318: l_d_teach_end_dt igs_ps_unit_ofr_opt_v.cal_end_dt%TYPE;
319: l_d_teach_start_dt igs_ca_inst_all.start_dt%TYPE;
320: l_d_temp_end_dt igs_ca_inst_all.end_dt%TYPE;
321: l_d_temp_date igs_ca_inst_all.end_dt%TYPE;
322:
323: --Cursor to get the check whether we have to include weekends or not
324: CURSOR c_weekend (cp_n_id IN NUMBER) IS

Line 321: l_d_temp_date igs_ca_inst_all.end_dt%TYPE;

317:
318: l_d_teach_end_dt igs_ps_unit_ofr_opt_v.cal_end_dt%TYPE;
319: l_d_teach_start_dt igs_ca_inst_all.start_dt%TYPE;
320: l_d_temp_end_dt igs_ca_inst_all.end_dt%TYPE;
321: l_d_temp_date igs_ca_inst_all.end_dt%TYPE;
322:
323: --Cursor to get the check whether we have to include weekends or not
324: CURSOR c_weekend (cp_n_id IN NUMBER) IS
325: SELECT incl_wkend_duration_flag

Line 1671: igs_ca_inst_all b

1667: CURSOR c_date(cp_n_uoo_id IN NUMBER) IS
1668: SELECT a.unit_section_start_date,
1669: NVL(a.unit_section_end_date,b.end_dt)
1670: FROM igs_ps_unit_ofr_opt_all a,
1671: igs_ca_inst_all b
1672: WHERE a.uoo_id = cp_n_uoo_id
1673: AND a.cal_type = b.cal_type
1674: AND a.ci_sequence_number = b.sequence_number;
1675:

Line 2297: CURSOR c_cal_inst (cp_d_start_dt IN igs_ca_inst_all.start_dt%TYPE,

2293: Change History (in reverse chronological order)
2294: Who When What
2295: ********************************************************************************************** */
2296:
2297: CURSOR c_cal_inst (cp_d_start_dt IN igs_ca_inst_all.start_dt%TYPE,
2298: cp_d_end_dt IN igs_ca_inst_all.end_dt%TYPE) IS
2299: SELECT DISTINCT ai.absolute_val
2300: FROM igs_ca_da_inst ai,
2301: igs_ca_inst_all ci,

Line 2298: cp_d_end_dt IN igs_ca_inst_all.end_dt%TYPE) IS

2294: Who When What
2295: ********************************************************************************************** */
2296:
2297: CURSOR c_cal_inst (cp_d_start_dt IN igs_ca_inst_all.start_dt%TYPE,
2298: cp_d_end_dt IN igs_ca_inst_all.end_dt%TYPE) IS
2299: SELECT DISTINCT ai.absolute_val
2300: FROM igs_ca_da_inst ai,
2301: igs_ca_inst_all ci,
2302: igs_ca_type ct,

Line 2301: igs_ca_inst_all ci,

2297: CURSOR c_cal_inst (cp_d_start_dt IN igs_ca_inst_all.start_dt%TYPE,
2298: cp_d_end_dt IN igs_ca_inst_all.end_dt%TYPE) IS
2299: SELECT DISTINCT ai.absolute_val
2300: FROM igs_ca_da_inst ai,
2301: igs_ca_inst_all ci,
2302: igs_ca_type ct,
2303: igs_ca_stat cs
2304: WHERE ai.cal_type = ci.cal_type
2305: AND ai.ci_sequence_number = ci.sequence_number