APPS.IGS_PS_GEN_001 dependencies on IGS_PS_USEC_WLST_PRI

Line 2182: FROM igs_ps_usec_wlst_pri

2178:
2179: --5
2180: CURSOR wlst_pri(p_uoo_id NUMBER) IS
2181: SELECT *
2182: FROM igs_ps_usec_wlst_pri
2183: WHERE uoo_id = p_uoo_id;
2184:
2185: --6
2186: CURSOR wlst_prf(p_usec_pri_id NUMBER) IS

Line 2993: CURSOR cur_wlst_pri_new(cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE,

2989: IF NVL(l_cur_waitlist.waitlist_allowed,l_cur_wlst_limit_new.waitlist_allowed) = 'Y' THEN
2990: -- Rollover of unit section waitlist priority records
2991: FOR wlst_pri_rec IN wlst_pri (p_old_uoo_Id) LOOP
2992: DECLARE
2993: CURSOR cur_wlst_pri_new(cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE,
2994: cp_priority_number igs_ps_usec_wlst_pri.priority_number%TYPE,
2995: cp_priority_value igs_ps_usec_wlst_pri.priority_value%TYPE) IS
2996: SELECT unit_sec_waitlist_priority_id
2997: FROM igs_ps_usec_wlst_pri

Line 2994: cp_priority_number igs_ps_usec_wlst_pri.priority_number%TYPE,

2990: -- Rollover of unit section waitlist priority records
2991: FOR wlst_pri_rec IN wlst_pri (p_old_uoo_Id) LOOP
2992: DECLARE
2993: CURSOR cur_wlst_pri_new(cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE,
2994: cp_priority_number igs_ps_usec_wlst_pri.priority_number%TYPE,
2995: cp_priority_value igs_ps_usec_wlst_pri.priority_value%TYPE) IS
2996: SELECT unit_sec_waitlist_priority_id
2997: FROM igs_ps_usec_wlst_pri
2998: WHERE uoo_id = cp_uoo_id

Line 2995: cp_priority_value igs_ps_usec_wlst_pri.priority_value%TYPE) IS

2991: FOR wlst_pri_rec IN wlst_pri (p_old_uoo_Id) LOOP
2992: DECLARE
2993: CURSOR cur_wlst_pri_new(cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE,
2994: cp_priority_number igs_ps_usec_wlst_pri.priority_number%TYPE,
2995: cp_priority_value igs_ps_usec_wlst_pri.priority_value%TYPE) IS
2996: SELECT unit_sec_waitlist_priority_id
2997: FROM igs_ps_usec_wlst_pri
2998: WHERE uoo_id = cp_uoo_id
2999: AND priority_number = cp_priority_number

Line 2997: FROM igs_ps_usec_wlst_pri

2993: CURSOR cur_wlst_pri_new(cp_uoo_id igs_ps_usec_wlst_pri.uoo_id%TYPE,
2994: cp_priority_number igs_ps_usec_wlst_pri.priority_number%TYPE,
2995: cp_priority_value igs_ps_usec_wlst_pri.priority_value%TYPE) IS
2996: SELECT unit_sec_waitlist_priority_id
2997: FROM igs_ps_usec_wlst_pri
2998: WHERE uoo_id = cp_uoo_id
2999: AND priority_number = cp_priority_number
3000: AND priority_value = cp_priority_value
3001: AND ROWNUM = 1 ;

Line 3010: igs_ps_usec_wlst_pri_pkg.insert_row(

3006: BEGIN
3007: OPEN cur_wlst_pri_new(p_new_uoo_id, wlst_pri_rec.priority_number, wlst_pri_rec.priority_value);
3008: FETCH cur_wlst_pri_new INTO l_cur_wlst_pri_new;
3009: IF cur_wlst_pri_new%NOTFOUND THEN
3010: igs_ps_usec_wlst_pri_pkg.insert_row(
3011: x_rowid => lv_rowid,
3012: x_unit_sec_wlst_priority_id => l_usec_pri_id,
3013: x_priority_number => wlst_pri_rec.priority_number ,
3014: x_priority_value => wlst_pri_rec.priority_value ,