APPS.PV_PARTNER_UTIL_PVT dependencies on PV_ENTY_ATTR_VALUE_PUB

Line 193: -- p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.ATTR_VALUE_TBL_TYPE

189: --
190: -- p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE Required
191: -- p_location_rec IN PV_PARTNER_UTIL_PVT.LOCATION_REC_TYPE Required
192: -- p_party_site_rec IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE Required
193: -- p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.ATTR_VALUE_TBL_TYPE
194: -- p_vad_partner_id IN NUMBER
195: -- p_member_type IN VARCHAR2
196: -- p_global_partner_id IN NUMBER
197: --

Line 346: -- p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.ATTR_VALUE_TBL_TYPE

342: --
343: -- p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE Required
344: -- p_location_rec IN PV_PARTNER_UTIL_PVT.LOCATION_REC_TYPE Required
345: -- p_party_site_rec IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE Required
346: -- p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.ATTR_VALUE_TBL_TYPE
347: -- p_vad_partner_id IN NUMBER
348: -- p_member_type IN VARCHAR2
349: -- p_global_partner_id IN NUMBER
350: --

Line 377: p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type,

373: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
374: p_location_rec IN PV_PARTNER_UTIL_PVT.LOCATION_REC_TYPE,
375: p_party_site_rec IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,
376: -- p_partner_types_tbl IN partner_types_tbl_type := g_miss_partner_types_tbl,
377: p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type,
378: p_vad_partner_id IN NUMBER,
379: p_member_type IN VARCHAR2 ,
380: p_global_partner_id IN NUMBER ,
381: x_party_id OUT NOCOPY NUMBER,

Line 984: -- p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.ATTR_VALUE_TBL_TYPE

980: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
981: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
982: --
983: -- p_party_id IN NUMBER Required
984: -- p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.ATTR_VALUE_TBL_TYPE
985: -- p_vad_partner_id IN NUMBER
986: -- p_member_type IN VARCHAR2
987: -- p_global_partner_id IN NUMBER
988: --

Line 1014: ,p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type

1010: ,x_return_status OUT NOCOPY VARCHAR2
1011: ,x_msg_data OUT NOCOPY VARCHAR2
1012: ,x_msg_count OUT NOCOPY NUMBER
1013: ,p_party_id IN NUMBER
1014: ,p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type
1015: ,p_vad_partner_id IN NUMBER
1016: ,p_member_type IN VARCHAR2
1017: ,p_global_partner_id IN NUMBER
1018: ,p_partner_qualifiers_tbl IN PV_TERR_ASSIGN_PUB.partner_qualifiers_tbl_type

Line 1116: l_attr_value_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;

1112: l_identity_sales_force_id NUMBER;
1113: l_access_id NUMBER;
1114: l_access_profile_rec AS_ACCESS_PUB.access_profile_rec_type;
1115:
1116: l_attr_value_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type;
1117: l_prtnr_access_id_tbl PV_TERR_ASSIGN_PUB.prtnr_aces_tbl_type;
1118:
1119: -- Local variable declaration for Standard Out variables.
1120: l_return_status VARCHAR2(1);

Line 1405: -- Upsert_Attr_Value API from PV_ENTY_ATTR_VALUE_PUB package.

1401: END IF;
1402: END IF;
1403:
1404: -- Add all Partner types in the attribute table by calling
1405: -- Upsert_Attr_Value API from PV_ENTY_ATTR_VALUE_PUB package.
1406:
1407: FOR I IN p_partner_types_tbl.first..p_partner_types_tbl.last
1408: LOOP
1409: l_partner_types := p_partner_types_tbl(I).attr_value;

Line 1415: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value (

1411: l_attr_value_tbl(I).attr_value_extn := p_partner_types_tbl(I).attr_value_extn;
1412: END LOOP;
1413:
1414: -- Call the API to insert the partner types in the attribute table.
1415: PV_ENTY_ATTR_VALUE_PUB.Upsert_Attr_Value (
1416: p_api_version_number=> 1.0
1417: ,p_init_msg_list => FND_API.g_false
1418: ,p_commit => FND_API.g_false
1419: ,p_validation_level => FND_API.g_valid_level_full

Line 1651: -- p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.ATTR_VALUE_TBL_TYPE

1647: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1648: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1649: --
1650: -- p_party_id IN NUMBER Required
1651: -- p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.ATTR_VALUE_TBL_TYPE
1652: -- p_vad_partner_id IN NUMBER
1653: -- p_member_type IN VARCHAR2
1654: -- p_global_partner_id IN NUMBER
1655: --

Line 1681: ,p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type

1677: ,x_msg_data OUT NOCOPY VARCHAR2
1678: ,x_msg_count OUT NOCOPY NUMBER
1679: ,p_party_id IN NUMBER
1680: -- ,p_partner_types_tbl IN partner_types_tbl_type := g_miss_partner_types_tbl
1681: ,p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type
1682: ,p_vad_partner_id IN NUMBER
1683: ,p_member_type IN VARCHAR2
1684: ,p_global_partner_id IN NUMBER
1685: ,x_partner_id OUT NOCOPY NUMBER

Line 1856: ,p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type

1852:
1853: ,p_party_id IN Number
1854: ,p_partner_qualifiers_tbl IN PV_TERR_ASSIGN_PUB.partner_qualifiers_tbl_type
1855: -- ,p_partner_types_tbl IN partner_types_tbl_type
1856: ,p_partner_types_tbl IN PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type
1857: ,p_vad_partner_id IN NUMBER
1858: ,p_person_rec IN PV_PARTNER_UTIL_PVT.PERSON_REC_TYPE
1859: ,p_phone_rec IN HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE
1860: ,p_email_rec IN HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE

Line 1886: l_partner_types_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type := p_partner_types_tbl;

1882: -- Details of local variables used in Create_Partner API call.
1883: -- l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE := p_organization_rec;
1884: -- l_location_rec PV_PARTNER_UTIL_PVT.LOCATION_REC_TYPE := p_location_rec;
1885: -- l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE := p_party_site_rec;
1886: l_partner_types_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type := p_partner_types_tbl;
1887: l_partner_id NUMBER ;
1888: l_vad_partner_id NUMBER := p_vad_partner_id;
1889: l_member_type VARCHAR2(30) := p_member_type;
1890: l_global_partner_id NUMBER := p_global_partner_id;