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_VALIDATE_GENERIC_PKG dependencies on IGS_PS_RSV_USEC_PRF

Line 2019: FROM igs_ps_rsv_usec_pri usprv,igs_ps_rsv_usec_prf uspfv

2015: l_n_count_msg NUMBER(6);
2016:
2017: CURSOR c_rsv_perc_sum( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2018: SELECT nvl(SUM(percentage_reserved),0) percentage_reserved
2019: FROM igs_ps_rsv_usec_pri usprv,igs_ps_rsv_usec_prf uspfv
2020: WHERE usprv.rsv_usec_pri_id = uspfv.rsv_usec_pri_id
2021: AND usprv.uoo_id =cp_uoo_id;
2022:
2023: c_rsv_perc_sum_rec c_rsv_perc_sum%ROWTYPE;

Line 2038: FROM igs_ps_rsv_usec_prf

2034: WHERE uoo_id=cp_uoo_id;
2035:
2036: CURSOR c_usec_rsvprfc_ser(cp_rsv_usec_pri_id NUMBER) IS
2037: SELECT preference_order
2038: FROM igs_ps_rsv_usec_prf
2039: WHERE rsv_usec_pri_id = cp_rsv_usec_pri_id
2040: ORDER BY preference_order;
2041: l_c_usec_rsvprfc_ser c_usec_rsvprfc_ser%ROWTYPE;
2042:

Line 2518: CURSOR c_clstd(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS

2514: Who When What
2515: sommukhe 16-FEB-2006 Bug#3094371, replaced IGS_OR_UNIT by igs_or_inst_org_base_v for cursor c_org
2516: ********************************************************************************************** */
2517:
2518: CURSOR c_clstd(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS
2519: SELECT 'X'
2520: FROM igs_pr_class_std
2521: WHERE closed_ind = 'N'
2522: AND class_standing = cp_preference_code;

Line 2526: CURSOR c_pstage(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS

2522: AND class_standing = cp_preference_code;
2523:
2524: c_clstd_rec c_clstd%ROWTYPE;
2525:
2526: CURSOR c_pstage(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS
2527: SELECT 'X'
2528: FROM igs_ps_stage_type
2529: WHERE closed_ind = 'N'
2530: AND course_stage_type = cp_preference_code;

Line 2534: CURSOR c_prog(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,

2530: AND course_stage_type = cp_preference_code;
2531:
2532: c_pstage_rec c_pstage%ROWTYPE;
2533:
2534: CURSOR c_prog(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
2535: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS
2536: SELECT 'X'
2537: FROM igs_ps_ver pv, igs_ps_stat pvst
2538: WHERE pvst.course_status = pv.course_status

Line 2535: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS

2531:
2532: c_pstage_rec c_pstage%ROWTYPE;
2533:
2534: CURSOR c_prog(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
2535: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS
2536: SELECT 'X'
2537: FROM igs_ps_ver pv, igs_ps_stat pvst
2538: WHERE pvst.course_status = pv.course_status
2539: AND pvst.s_course_status <> 'INACTIVE'

Line 2545: CURSOR c_unit_set(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,

2541: AND pv.version_number=cp_preference_version;
2542:
2543: c_prog_rec c_prog%ROWTYPE;
2544:
2545: CURSOR c_unit_set(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
2546: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS
2547: SELECT 'X'
2548: FROM igs_en_unit_set us, igs_en_unit_set_stat uss
2549: WHERE us.unit_set_status = uss.unit_set_status

Line 2546: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS

2542:
2543: c_prog_rec c_prog%ROWTYPE;
2544:
2545: CURSOR c_unit_set(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
2546: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS
2547: SELECT 'X'
2548: FROM igs_en_unit_set us, igs_en_unit_set_stat uss
2549: WHERE us.unit_set_status = uss.unit_set_status
2550: AND uss.s_unit_set_status <> 'INACTIVE'

Line 2556: CURSOR c_pgrp(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS

2552: AND us.version_number = cp_preference_version;
2553:
2554: c_unit_set_rec c_unit_set%ROWTYPE;
2555:
2556: CURSOR c_pgrp(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS
2557: SELECT 'X'
2558: FROM igs_pe_persid_group_all
2559: WHERE closed_ind = 'N'
2560: AND group_cd = cp_preference_code

Line 2569: CURSOR c_org(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS

2565: ' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99);
2566:
2567: c_pgrp_rec c_pgrp%ROWTYPE;
2568:
2569: CURSOR c_org(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS
2570: SELECT 'X'
2571: FROM igs_or_inst_org_base_v a, igs_or_status b
2572: WHERE a.party_number = cp_preference_code
2573: AND a.org_status = b.org_status

Line 2667: CURSOR c_clstd(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS

2663: Who When What
2664: sommukhe 16-FEB-2006 Bug#3094371, replaced IGS_OR_UNIT by igs_or_inst_org_base_v for cursor c_org
2665: ********************************************************************************************** */
2666:
2667: CURSOR c_clstd(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS
2668: SELECT 'X'
2669: FROM igs_pr_class_std
2670: WHERE closed_ind = 'N'
2671: AND class_standing = cp_preference_code;

Line 2675: CURSOR c_pstage(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS

2671: AND class_standing = cp_preference_code;
2672:
2673: c_clstd_rec c_clstd%ROWTYPE;
2674:
2675: CURSOR c_pstage(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS
2676: SELECT 'X'
2677: FROM igs_ps_stage_type
2678: WHERE closed_ind = 'N'
2679: AND course_stage_type = cp_preference_code;

Line 2683: CURSOR c_prog(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,

2679: AND course_stage_type = cp_preference_code;
2680:
2681: c_pstage_rec c_pstage%ROWTYPE;
2682:
2683: CURSOR c_prog(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
2684: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS
2685: SELECT 'X'
2686: FROM igs_ps_ver pv, igs_ps_stat pvst
2687: WHERE pvst.course_status = pv.course_status

Line 2684: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS

2680:
2681: c_pstage_rec c_pstage%ROWTYPE;
2682:
2683: CURSOR c_prog(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
2684: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS
2685: SELECT 'X'
2686: FROM igs_ps_ver pv, igs_ps_stat pvst
2687: WHERE pvst.course_status = pv.course_status
2688: AND pvst.s_course_status <> 'INACTIVE'

Line 2694: CURSOR c_unit_set(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,

2690: AND pv.version_number=cp_preference_version;
2691:
2692: c_prog_rec c_prog%ROWTYPE;
2693:
2694: CURSOR c_unit_set(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
2695: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS
2696: SELECT 'X'
2697: FROM igs_en_unit_set us, igs_en_unit_set_stat uss
2698: WHERE us.unit_set_status = uss.unit_set_status

Line 2695: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS

2691:
2692: c_prog_rec c_prog%ROWTYPE;
2693:
2694: CURSOR c_unit_set(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
2695: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS
2696: SELECT 'X'
2697: FROM igs_en_unit_set us, igs_en_unit_set_stat uss
2698: WHERE us.unit_set_status = uss.unit_set_status
2699: AND uss.s_unit_set_status <> 'INACTIVE'

Line 2705: CURSOR c_org(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS

2701: AND us.version_number = cp_preference_version;
2702:
2703: c_unit_set_rec c_unit_set%ROWTYPE;
2704:
2705: CURSOR c_org(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS
2706: SELECT 'X'
2707: FROM igs_or_inst_org_base_v a, igs_or_status b
2708: WHERE a.party_number = cp_preference_code
2709: AND a.org_status = b.org_status