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.PV_PARTNER_ACCESSES_PVT dependencies on PV_PARTNER_PROFILES

Line 986: -- check, the supplied partner in the PV_PARTNER_PROFILES table is ACTIVE and EXISTS.

982: p_partner_access_rec IN partner_access_rec_type,
983: x_return_status OUT NOCOPY VARCHAR2
984: )
985: IS
986: -- check, the supplied partner in the PV_PARTNER_PROFILES table is ACTIVE and EXISTS.
987: CURSOR l_chk_partner_active_csr(cv_partner_id IN NUMBER) IS
988: SELECT 'Y'
989: FROM pv_partner_profiles
990: WHERE partner_id = cv_partner_id

Line 989: FROM pv_partner_profiles

985: IS
986: -- check, the supplied partner in the PV_PARTNER_PROFILES table is ACTIVE and EXISTS.
987: CURSOR l_chk_partner_active_csr(cv_partner_id IN NUMBER) IS
988: SELECT 'Y'
989: FROM pv_partner_profiles
990: WHERE partner_id = cv_partner_id
991: AND status = 'A';
992:
993: -- check, the supplied resource in the JTF_RS_RESOURCE_EXTNS table is ACTIVE and EXISTS.