DBA Data[Home] [Help]

APPS.PVX_PRTNR_PRFLS_PVT dependencies on PV_PARTNER_PROFILES_S

Line 59: SELECT PV_partner_profiles_S.NEXTVAL

55:
56:
57: -- Cursor to get the sequence for prtnr_prfls
58: CURSOR c_prtnr_prfls_seq IS
59: SELECT PV_partner_profiles_S.NEXTVAL
60: FROM DUAL;
61:
62: -- Cursor to validate the uniqueness
63: CURSOR c_count(cv_partner_profile_id IN NUMBER) IS

Line 723: UPDATE PV_PARTNER_PROFILES SET

719: l_list.DELETE;
720:
721: END IF;
722:
723: UPDATE PV_PARTNER_PROFILES SET
724: last_update_date = SYSDATE
725: ,last_updated_by = NVL(FND_GLOBAL.user_id,-1)
726: ,last_update_login = NVL(FND_GLOBAL.conc_login_id,-1)
727: ,PARTNER_ID = l_prtnr_prfls_rec.PARTNER_ID