DBA Data[Home] [Help]

APPS.PVX_PARTY_MERGE_PKG dependencies on PV_LEAD_PSS_LINES

Line 690: from PV_LEAD_PSS_LINES

686: x_return_status OUT NOCOPY VARCHAR2)
687: IS
688: cursor c1 is
689: select 1
690: from PV_LEAD_PSS_LINES
691: where partner_id = p_from_fk_id
692: for update nowait;
693:
694:

Line 741: from PV_LEAD_PSS_LINES

737: if p_from_fk_id <> p_to_fk_id then
738:
739: begin
740: select DISTINCT partner_id into l_ppf_id
741: from PV_LEAD_PSS_LINES
742: where partner_id = p_to_fk_id;
743: exception
744: When NO_DATA_FOUND then
745: l_ppf_id := Null;

Line 749: update PV_LEAD_PSS_LINES

745: l_ppf_id := Null;
746: end;
747:
748:
749: update PV_LEAD_PSS_LINES
750: set partner_id = decode(partner_id, p_from_fk_id, p_to_fk_id, partner_id),
751: last_update_date = SYSDATE,
752: last_updated_by = G_USER_ID,
753: last_update_login = G_LOGIN_ID