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

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 195: igs_ca_inst ci,

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,
196: igs_ca_type ct,
197: igs_ca_stat cs,
198: igs_ca_da_inst_v cv
199: WHERE

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 1118: IGS_CA_INST ci,

1114:
1115: CURSOR c_m_alias_val IS
1116: SELECT TRUNC(max(dai.absolute_val)), TRUNC(min(dai.absolute_val))
1117: FROM IGS_CA_DA_INST dai,
1118: IGS_CA_INST ci,
1119: IGS_CA_TYPE ct,
1120: IGS_CA_STAT cs
1121: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
1122: ct.S_CAL_CAT = cst_holiday AND

Line 1133: FROM IGS_CA_INST ci,

1129: SELECT 'x'
1130: FROM IGS_CA_TYPE ct
1131: WHERE ct.S_CAL_CAT = cst_holiday AND
1132: EXISTS (SELECT 'x'
1133: FROM IGS_CA_INST ci,
1134: IGS_CA_STAT cs
1135: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
1136: ci.CAL_STATUS = cs.CAL_STATUS AND
1137: cs.s_cal_status = cst_active AND

Line 1236: IGS_CA_INST ci,

1232: SELECT TRUNC(MAX(dai2.absolute_val)), TRUNC(MIN(dai1.absolute_val))
1233: FROM IGS_CA_DA_INST dai1,
1234: IGS_CA_DA_INST dai2,
1235: IGS_CA_DA_INST_PAIR daip,
1236: IGS_CA_INST ci,
1237: IGS_CA_TYPE ct,
1238: IGS_CA_STAT cs
1239: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
1240: ct.S_CAL_CAT = cst_holiday AND

Line 1259: FROM IGS_CA_INST ci,

1255: SELECT 'x'
1256: FROM IGS_CA_TYPE ct
1257: WHERE ct.S_CAL_CAT = cst_holiday AND
1258: EXISTS (SELECT 'x'
1259: FROM IGS_CA_INST ci,
1260: IGS_CA_STAT cs
1261: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
1262: ci.CAL_STATUS = cs.CAL_STATUS AND
1263: cs.s_cal_status = cst_active AND

Line 1292: RETURN ('IGS_CA_INSTBREAK_CONST_UNRSLV');

1288: -- constraint does not require resolving
1289: RETURN null;
1290: ELSE
1291: -- constraint cannot be resolved
1292: RETURN ('IGS_CA_INSTBREAK_CONST_UNRSLV');
1293: END IF;
1294: ELSE
1295: IF p_cnstrt_condition = cst_must THEN
1296: IF (p_date_val > v_max_alias_val AND

Line 1301: RETURN ('IGS_CA_INSTBREAK_CONS_UNRSVLD');

1297: p_cnstrt_resolution >0 ) OR
1298: (p_date_val < v_min_alias_val AND
1299: p_cnstrt_resolution <0 ) THEN
1300: -- constraint cannot be resolved
1301: RETURN ('IGS_CA_INSTBREAK_CONS_UNRSVLD');
1302: END IF;
1303: END IF;
1304: v_tmp_date_val := p_date_val;
1305:

Line 1329: RETURN ('IGS_CA_INSTBREAK_CONS_UNRSVLD');

1325: p_cnstrt_resolution >0 ) OR
1326: (v_tmp_date_val < v_min_alias_val AND
1327: p_cnstrt_resolution <0 ) THEN
1328: -- constraint cannot be resolved
1329: RETURN ('IGS_CA_INSTBREAK_CONS_UNRSVLD');
1330: END IF;
1331: v_changed := TRUE;
1332: END IF;
1333: END IF;

Line 1559: l_cal_type igs_ca_inst.cal_type%TYPE;

1555: --sarakshi 22-Aug-2005 bug#4113948, Return the last meeting date if p_date is greater than the last meeting date
1556: -------------------------------------------------------------------
1557: IS
1558:
1559: l_cal_type igs_ca_inst.cal_type%TYPE;
1560: l_seq_number igs_ca_inst.sequence_number%TYPE;
1561: l_enddate DATE; -- new deadline date
1562:
1563: l_return VARCHAR2(1) ; -- decide whether old date exists as deadline or not

Line 1560: l_seq_number igs_ca_inst.sequence_number%TYPE;

1556: -------------------------------------------------------------------
1557: IS
1558:
1559: l_cal_type igs_ca_inst.cal_type%TYPE;
1560: l_seq_number igs_ca_inst.sequence_number%TYPE;
1561: l_enddate DATE; -- new deadline date
1562:
1563: l_return VARCHAR2(1) ; -- decide whether old date exists as deadline or not
1564: p_unit_sec_end_date DATE;

Line 1580: CURSOR cur_calinst (cp_cal_type igs_ca_inst.cal_type%TYPE,

1576: WHERE uoo_id = cp_uoo_id;
1577:
1578:
1579: --Cursor to fetch the Calendar Instance End Date
1580: CURSOR cur_calinst (cp_cal_type igs_ca_inst.cal_type%TYPE,
1581: cp_seq_number igs_ca_inst.sequence_number%TYPE)
1582: IS
1583: SELECT end_dt
1584: FROM igs_ca_inst

Line 1581: cp_seq_number igs_ca_inst.sequence_number%TYPE)

1577:
1578:
1579: --Cursor to fetch the Calendar Instance End Date
1580: CURSOR cur_calinst (cp_cal_type igs_ca_inst.cal_type%TYPE,
1581: cp_seq_number igs_ca_inst.sequence_number%TYPE)
1582: IS
1583: SELECT end_dt
1584: FROM igs_ca_inst
1585: WHERE cal_type=cp_cal_type

Line 1584: FROM igs_ca_inst

1580: CURSOR cur_calinst (cp_cal_type igs_ca_inst.cal_type%TYPE,
1581: cp_seq_number igs_ca_inst.sequence_number%TYPE)
1582: IS
1583: SELECT end_dt
1584: FROM igs_ca_inst
1585: WHERE cal_type=cp_cal_type
1586: AND sequence_number=cp_seq_number;
1587:
1588:

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