DBA Data[Home] [Help]

APPS.PVX_PARTY_MERGE_PKG dependencies on PV_GE_PARTY_NOTIFICATIONS

Line 790: from PV_GE_PARTY_NOTIFICATIONS

786: x_return_status OUT NOCOPY VARCHAR2)
787: IS
788: cursor c1 is
789: select 1
790: from PV_GE_PARTY_NOTIFICATIONS
791: where partner_id = p_from_fk_id
792: for update nowait;
793:
794:

Line 842: FROM PV_GE_PARTY_NOTIFICATIONS

838:
839:
840: BEGIN
841: SELECT DISTINCT partner_id INTO l_ppf_id
842: FROM PV_GE_PARTY_NOTIFICATIONS
843: WHERE partner_id = p_to_fk_id;
844: EXCEPTION
845: WHEN NO_DATA_FOUND THEN
846: l_ppf_id := Null;

Line 851: update PV_GE_PARTY_NOTIFICATIONS

847: END;
848:
849:
850:
851: update PV_GE_PARTY_NOTIFICATIONS
852: set partner_id = p_to_fk_id,
853: last_update_date = SYSDATE,
854: last_updated_by = G_USER_ID,
855: last_update_login = G_LOGIN_ID