APPS.IGS_PS_GEN_008 dependencies on IGS_PS_UOFR_WLST_PRF

Line 1789: CURSOR c_uofr_wlst_prf_det(cp_unit_ofr_wlst_priority_id igs_ps_uofr_wlst_prf.unit_ofr_waitlist_priority_id%TYPE) IS

1785: AND ci_sequence_number= p_ci_sequence_number;
1786:
1787: v_unit_ofr_wlist_pri_id igs_ps_uofr_wlst_pri.unit_ofr_waitlist_priority_id%TYPE;
1788:
1789: CURSOR c_uofr_wlst_prf_det(cp_unit_ofr_wlst_priority_id igs_ps_uofr_wlst_prf.unit_ofr_waitlist_priority_id%TYPE) IS
1790: SELECT *
1791: FROM igs_ps_uofr_wlst_prf
1792: WHERE unit_ofr_waitlist_priority_id = cp_unit_ofr_wlst_priority_id;
1793: v_unit_ofr_wlist_prf_id igs_ps_uofr_wlst_prf.unit_ofr_waitlist_pref_id%TYPE;

Line 1791: FROM igs_ps_uofr_wlst_prf

1787: v_unit_ofr_wlist_pri_id igs_ps_uofr_wlst_pri.unit_ofr_waitlist_priority_id%TYPE;
1788:
1789: CURSOR c_uofr_wlst_prf_det(cp_unit_ofr_wlst_priority_id igs_ps_uofr_wlst_prf.unit_ofr_waitlist_priority_id%TYPE) IS
1790: SELECT *
1791: FROM igs_ps_uofr_wlst_prf
1792: WHERE unit_ofr_waitlist_priority_id = cp_unit_ofr_wlst_priority_id;
1793: v_unit_ofr_wlist_prf_id igs_ps_uofr_wlst_prf.unit_ofr_waitlist_pref_id%TYPE;
1794:
1795:

Line 1793: v_unit_ofr_wlist_prf_id igs_ps_uofr_wlst_prf.unit_ofr_waitlist_pref_id%TYPE;

1789: CURSOR c_uofr_wlst_prf_det(cp_unit_ofr_wlst_priority_id igs_ps_uofr_wlst_prf.unit_ofr_waitlist_priority_id%TYPE) IS
1790: SELECT *
1791: FROM igs_ps_uofr_wlst_prf
1792: WHERE unit_ofr_waitlist_priority_id = cp_unit_ofr_wlst_priority_id;
1793: v_unit_ofr_wlist_prf_id igs_ps_uofr_wlst_prf.unit_ofr_waitlist_pref_id%TYPE;
1794:
1795:
1796: BEGIN
1797:

Line 1816: igs_ps_uofr_wlst_prf_pkg.Insert_Row(

1812: FOR c_uofr_wlst_prf_rec IN c_uofr_wlst_prf_det(c_uofr_wlst_pri_rec.unit_ofr_waitlist_priority_id)
1813: LOOP
1814: x_rowid := NULL;
1815: v_unit_ofr_wlist_prf_id := NULL;
1816: igs_ps_uofr_wlst_prf_pkg.Insert_Row(
1817: x_rowid => x_rowid,
1818: x_unit_ofr_wl_pref_id => v_unit_ofr_wlist_prf_id,
1819: x_unit_ofr_wl_priority_id => v_unit_ofr_wlist_pri_id,
1820: x_preference_order => c_uofr_wlst_prf_rec.preference_order,