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

Line 275: IGS_CA_INST ci,

271: CURSOR c_cat_ci_cir_cs1 IS
272: SELECT cir.sub_cal_type,
273: cir.sub_ci_sequence_number
274: FROM IGS_CA_TYPE cat,
275: IGS_CA_INST ci,
276: IGS_CA_INST_REL cir,
277: IGS_CA_STAT cs
278: WHERE cir.sup_cal_type = p_prg_cal_type AND
279: cir.sup_ci_sequence_number = p_prg_sequence_number AND

Line 276: IGS_CA_INST_REL cir,

272: SELECT cir.sub_cal_type,
273: cir.sub_ci_sequence_number
274: FROM IGS_CA_TYPE cat,
275: IGS_CA_INST ci,
276: IGS_CA_INST_REL cir,
277: IGS_CA_STAT cs
278: WHERE cir.sup_cal_type = p_prg_cal_type AND
279: cir.sup_ci_sequence_number = p_prg_sequence_number AND
280: ci.cal_type = cir.sub_cal_type AND

Line 291: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,

287: -- kdande; 22-Apr-2003; Bug# 2829262
288: -- Added uoo_id field to the SELECT clause of cursor c_sua_sca.
289: --
290: CURSOR c_sua_sca (
291: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
292: cp_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
293: SELECT sua.unit_cd,
294: sua.cal_type,
295: sua.ci_sequence_number,

Line 292: cp_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS

288: -- Added uoo_id field to the SELECT clause of cursor c_sua_sca.
289: --
290: CURSOR c_sua_sca (
291: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
292: cp_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
293: SELECT sua.unit_cd,
294: sua.cal_type,
295: sua.ci_sequence_number,
296: sua.unit_attempt_status,

Line 319: IGS_CA_INST ci1,

315: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
316: SELECT cir.sup_cal_type,
317: cir.sup_ci_sequence_number
318: FROM IGS_CA_TYPE cat,
319: IGS_CA_INST ci1,
320: IGS_CA_INST_REL cir,
321: IGS_CA_STAT cs
322: WHERE cir.sub_cal_type = cp_sua_cal_type AND
323: cir.sub_ci_sequence_number = cp_sua_ci_sequence_number AND

Line 320: IGS_CA_INST_REL cir,

316: SELECT cir.sup_cal_type,
317: cir.sup_ci_sequence_number
318: FROM IGS_CA_TYPE cat,
319: IGS_CA_INST ci1,
320: IGS_CA_INST_REL cir,
321: IGS_CA_STAT cs
322: WHERE cir.sub_cal_type = cp_sua_cal_type AND
323: cir.sub_ci_sequence_number = cp_sua_ci_sequence_number AND
324: ci1.cal_type = cir.sup_cal_type AND

Line 337: FROM IGS_CA_INST ci2

333: p_prg_cal_type,
334: cir.sup_cal_type) = 'Y' AND
335: ci1.start_dt <
336: (SELECT ci2.start_dt
337: FROM IGS_CA_INST ci2
338: WHERE ci2.cal_type = p_prg_cal_type AND
339: ci2.sequence_number = p_prg_sequence_number);
340: BEGIN
341: FOR v_cir1_rec IN c_cat_ci_cir_cs1 LOOP

Line 446: IGS_CA_INST ci,

442: CURSOR c_cat_ci_cir_cs IS
443: SELECT cir.sub_cal_type,
444: cir.sub_ci_sequence_number
445: FROM IGS_CA_TYPE cat,
446: IGS_CA_INST ci,
447: IGS_CA_INST_REL cir,
448: IGS_CA_STAT cs
449: WHERE cir.sup_cal_type = p_prg_cal_type AND
450: cir.sup_ci_sequence_number = p_prg_sequence_number AND

Line 447: IGS_CA_INST_REL cir,

443: SELECT cir.sub_cal_type,
444: cir.sub_ci_sequence_number
445: FROM IGS_CA_TYPE cat,
446: IGS_CA_INST ci,
447: IGS_CA_INST_REL cir,
448: IGS_CA_STAT cs
449: WHERE cir.sup_cal_type = p_prg_cal_type AND
450: cir.sup_ci_sequence_number = p_prg_sequence_number AND
451: ci.cal_type = cir.sub_cal_type AND

Line 462: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,

458: -- kdande; 22-Apr-2003; Bug# 2829262
459: -- Added uoo_id field to the SELECT clause of the cursor c_sua_sca.
460: --
461: CURSOR c_sua_sca (
462: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
463: cp_sub_ci_sequence_number
464: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
465: SELECT sua.unit_cd,
466: sua.cal_type,

Line 464: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS

460: --
461: CURSOR c_sua_sca (
462: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
463: cp_sub_ci_sequence_number
464: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
465: SELECT sua.unit_cd,
466: sua.cal_type,
467: sua.ci_sequence_number,
468: sua.unit_attempt_status,

Line 549: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,

545:
546: END prgp_get_msr_efctv;
547:
548: FUNCTION prgp_get_prg_efctv(
549: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
550: p_prg_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE )
551: RETURN DATE AS
552: BEGIN -- prgp_get_prg_efctv
553: -- Get the effective date of a nominated progression period.

Line 550: p_prg_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE )

546: END prgp_get_msr_efctv;
547:
548: FUNCTION prgp_get_prg_efctv(
549: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
550: p_prg_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE )
551: RETURN DATE AS
552: BEGIN -- prgp_get_prg_efctv
553: -- Get the effective date of a nominated progression period.
554: -- This is retrieved from the IGS_CA_DA_INST table matching the value

Line 575: FROM IGS_CA_INST ci

571: WHERE sprgcc.s_control_num = 1)
572: ORDER BY 1 DESC; -- for latest if multiple dates exist
573: CURSOR c_ci IS
574: SELECT ci.end_dt
575: FROM IGS_CA_INST ci
576: WHERE ci.cal_type = p_prg_cal_type AND
577: ci.sequence_number = p_prg_sequence_number;
578: BEGIN
579: -- Search for alias value within the calendar