DBA Data[Home] [Help]

APPS.PVX_PARTY_MERGE_PKG dependencies on PV_PG_ENRL_REQUESTS

Line 891: from PV_PG_ENRL_REQUESTS

887: x_return_status OUT NOCOPY VARCHAR2)
888: IS
889: cursor c1 is
890: select 1
891: from PV_PG_ENRL_REQUESTS
892: where partner_id = p_from_fk_id
893: for update nowait;
894:
895:

Line 1363: from PV_PG_ENRL_REQUESTS

1359: )
1360: IS
1361: cursor c1 is
1362: select 1
1363: from PV_PG_ENRL_REQUESTS
1364: where partner_id = p_from_fk_id
1365: for update nowait;
1366:
1367:

Line 1415: FROM PV_PG_ENRL_REQUESTS

1411:
1412:
1413: BEGIN
1414: SELECT DISTINCT partner_id INTO l_ppf_id
1415: FROM PV_PG_ENRL_REQUESTS
1416: WHERE partner_id = p_to_fk_id;
1417: EXCEPTION
1418: WHEN NO_DATA_FOUND THEN
1419: l_ppf_id := Null;

Line 1424: update PV_PG_ENRL_REQUESTS

1420: END;
1421:
1422:
1423:
1424: update PV_PG_ENRL_REQUESTS
1425: set contract_binding_contact_id = p_to_fk_id,
1426: last_update_date = SYSDATE,
1427: last_updated_by = G_USER_ID,
1428: last_update_login = G_LOGIN_ID