914: p_tap_access_terrs_rec IN tap_access_terrs_rec_type,
915: x_return_status OUT NOCOPY VARCHAR2
916: )
917: IS
918: -- check, the supplied partner_access_id in the PV_PARTNER_ACCESSES table EXISTS.
919: CURSOR l_chk_paccess_active_csr(cv_partner_access_id IN NUMBER) IS
920: SELECT 'Y'
921: FROM pv_partner_accesses
922: WHERE partner_access_id = cv_partner_access_id;
917: IS
918: -- check, the supplied partner_access_id in the PV_PARTNER_ACCESSES table EXISTS.
919: CURSOR l_chk_paccess_active_csr(cv_partner_access_id IN NUMBER) IS
920: SELECT 'Y'
921: FROM pv_partner_accesses
922: WHERE partner_access_id = cv_partner_access_id;
923:
924: -- check, the supplied territory in the JTF_TERR_ALL table is ACTIVE and EXISTS.
925: CURSOR l_chk_terr_active_csr(cv_terr_id IN NUMBER) IS