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_SS_ENR_DETAILS dependencies on IGS_PS_UNIT_SUBTITLE

Line 563: igs_ps_unit_subtitle usub

559: uref.title,
560: usub.subtitle
561: FROM
562: igs_ps_usec_ref uref,
563: igs_ps_unit_subtitle usub
564: WHERE
565: uref.uoo_id = p_uoo_id AND
566: uref.subtitle_id = usub.subtitle_id(+);
567:

Line 577: igs_ps_unit_subtitle usub

573: uv.title,
574: usub.subtitle
575: FROM
576: igs_ps_unit_ver uv ,
577: igs_ps_unit_subtitle usub
578: WHERE
579: uv.unit_cd = cp_unit_cd AND
580: uv.version_number = cp_version_number AND
581: uv.subtitle_id = usub.subtitle_id(+);

Line 590: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

586: where uoo_id = cp_uoo_id;
587:
588: title_subtitle_dtls_rec usec_subtitle_dtls%ROWTYPE;
589: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
590: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
591: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
592: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
593: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
594: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

Line 592: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

588: title_subtitle_dtls_rec usec_subtitle_dtls%ROWTYPE;
589: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
590: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
591: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
592: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
593: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
594: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
595: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
596: l_unit_ver igs_ps_unit_ver.version_number%TYPE;

Line 594: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

590: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
591: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
592: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
593: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
594: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
595: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
596: l_unit_ver igs_ps_unit_ver.version_number%TYPE;
597: BEGIN
598: IF p_unit_cd IS NULL THEN

Line 676: igs_ps_unit_subtitle usub

672: uref.title,
673: usub.subtitle
674: FROM
675: igs_ps_usec_ref uref,
676: igs_ps_unit_subtitle usub
677: WHERE
678: uref.uoo_id = p_uoo_id AND
679: uref.subtitle_id = usub.subtitle_id(+);
680:

Line 688: igs_ps_unit_subtitle usub

684: uv.title,
685: usub.subtitle
686: FROM
687: igs_ps_unit_ver uv ,
688: igs_ps_unit_subtitle usub
689: WHERE
690: uv.unit_cd = p_unit_cd AND
691: uv.version_number = p_version_number AND
692: uv.subtitle_id = usub.subtitle_id(+);

Line 695: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

691: uv.version_number = p_version_number AND
692: uv.subtitle_id = usub.subtitle_id(+);
693: title_subtitle_dtls_rec usec_subtitle_dtls%ROWTYPE;
694: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
695: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
696: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
697: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
698: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
699: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

Line 697: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

693: title_subtitle_dtls_rec usec_subtitle_dtls%ROWTYPE;
694: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
695: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
696: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
697: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
698: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
699: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
700: BEGIN
701: -- first check if title and subtitle exists at student level

Line 699: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

695: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
696: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
697: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
698: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
699: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
700: BEGIN
701: -- first check if title and subtitle exists at student level
702: OPEN stdnt_subtitle_dtls;
703: FETCH stdnt_subtitle_dtls INTO title_subtitle_dtls_rec;

Line 761: igs_ps_unit_subtitle usub

757: uref.title,
758: usub.subtitle
759: FROM
760: igs_ps_usec_ref uref,
761: igs_ps_unit_subtitle usub
762: WHERE
763: uref.uoo_id = p_uoo_id AND
764: uref.subtitle_id = usub.subtitle_id(+);
765:

Line 773: igs_ps_unit_subtitle usub

769: uv.title,
770: usub.subtitle
771: FROM
772: igs_ps_unit_ver uv ,
773: igs_ps_unit_subtitle usub
774: WHERE
775: uv.unit_cd = p_unit_cd AND
776: uv.version_number = p_version_number AND
777: uv.subtitle_id = usub.subtitle_id(+);

Line 780: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

776: uv.version_number = p_version_number AND
777: uv.subtitle_id = usub.subtitle_id(+);
778: title_subtitle_dtls_rec usec_subtitle_dtls%ROWTYPE;
779: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
780: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
781: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
782: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
783: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
784: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

Line 782: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

778: title_subtitle_dtls_rec usec_subtitle_dtls%ROWTYPE;
779: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
780: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
781: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
782: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
783: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
784: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
785: BEGIN
786: -- first check if title and subtitle exists at student level

Line 784: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

780: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
781: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
782: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
783: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
784: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
785: BEGIN
786: -- first check if title and subtitle exists at student level
787: OPEN stdnt_subtitle_dtls;
788: FETCH stdnt_subtitle_dtls INTO title_subtitle_dtls_rec;

Line 4459: FROM igs_ps_unit_subtitle t,

4455: -------------------------------------------------------------------
4456: IS
4457: CURSOR c_us_title(cp_n_uoo_id IN NUMBER) IS
4458: SELECT t.subtitle
4459: FROM igs_ps_unit_subtitle t,
4460: igs_ps_usec_ref us
4461: WHERE us.uoo_id = cp_n_uoo_id
4462: AND us.subtitle_id = t.subtitle_id;
4463:

Line 4466: FROM igs_ps_unit_subtitle t,

4462: AND us.subtitle_id = t.subtitle_id;
4463:
4464: CURSOR c_uv_title(cp_n_uoo_id IN NUMBER) IS
4465: SELECT t.subtitle
4466: FROM igs_ps_unit_subtitle t,
4467: igs_ps_unit_ofr_opt_all us,
4468: igs_ps_unit_ver_all uv
4469: WHERE us.uoo_id = cp_n_uoo_id
4470: AND us.unit_cd = uv.unit_cd

Line 4473: l_c_subtitle igs_ps_unit_subtitle.subtitle%TYPE;

4469: WHERE us.uoo_id = cp_n_uoo_id
4470: AND us.unit_cd = uv.unit_cd
4471: AND us.version_number = uv.version_number
4472: AND uv.subtitle_id = t.subtitle_id;
4473: l_c_subtitle igs_ps_unit_subtitle.subtitle%TYPE;
4474: BEGIN
4475: OPEN c_us_title(p_n_uoo_id);
4476: FETCH c_us_title INTO l_c_subtitle;
4477: CLOSE c_us_title;