DBA Data[Home] [Help]

APPS.PVX_PARTY_MERGE_PKG dependencies on PV_ASSIGNMENT_LOGS

Line 550: from PV_ASSIGNMENT_LOGS

546: x_return_status OUT NOCOPY VARCHAR2)
547: IS
548: cursor c1 is
549: select 1
550: from PV_ASSIGNMENT_LOGS
551: where partner_id = p_from_fk_id
552: for update nowait;
553:
554:

Line 601: from PV_ASSIGNMENT_LOGS

597: if p_from_fk_id <> p_to_fk_id then
598:
599: begin
600: select DISTINCT partner_id into l_ppf_id
601: from PV_ASSIGNMENT_LOGS
602: where partner_id = p_to_fk_id;
603: exception
604: When NO_DATA_FOUND then
605: l_ppf_id := Null;

Line 609: update PV_ASSIGNMENT_LOGS

605: l_ppf_id := Null;
606: end;
607:
608:
609: update PV_ASSIGNMENT_LOGS
610: set partner_id = decode(partner_id, p_from_fk_id, p_to_fk_id, partner_id),
611: last_update_date = SYSDATE,
612: last_updated_by = G_USER_ID,
613: last_update_login = G_LOGIN_ID