DBA Data[Home] [Help]

APPS.PV_PARTNER_UTIL_PVT dependencies on PV_TERR_ASSIGN_PUB

Line 1018: ,p_partner_qualifiers_tbl IN PV_TERR_ASSIGN_PUB.partner_qualifiers_tbl_type

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
1019: ,x_partner_id OUT NOCOPY NUMBER
1020: ,x_default_resp_id OUT NOCOPY NUMBER
1021: ,x_resp_map_rule_id OUT NOCOPY NUMBER
1022: ,x_group_id OUT NOCOPY NUMBER

Line 1028: l_partner_qualifiers_tbl PV_TERR_ASSIGN_PUB.partner_qualifiers_tbl_type := p_partner_qualifiers_tbl;

1024:
1025: L_API_NAME CONSTANT VARCHAR2(30) := 'Do_Create_Relationship';
1026: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1027:
1028: l_partner_qualifiers_tbl PV_TERR_ASSIGN_PUB.partner_qualifiers_tbl_type := p_partner_qualifiers_tbl;
1029: -- Cursor l_org_details_csr to get partner party details
1030: CURSOR l_org_details_csr (cv_party_id NUMBER) IS
1031: SELECT party_site_id
1032: FROM hz_party_sites

Line 1117: l_prtnr_access_id_tbl PV_TERR_ASSIGN_PUB.prtnr_aces_tbl_type;

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);
1121: l_msg_count NUMBER;

Line 1464: PV_TERR_ASSIGN_PUB.Create_Channel_Team (

1460: END IF;
1461:
1462: -- Create the Channel Team
1463: /*
1464: PV_TERR_ASSIGN_PUB.Create_Channel_Team (
1465: p_api_version_number => 1.0,
1466: p_init_msg_list => FND_API.G_FALSE ,
1467: p_commit => FND_API.G_FALSE ,
1468: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

Line 1482: PV_TERR_ASSIGN_PUB.Do_Create_Channel_Team (

1478: */
1479: -- Change the call to create channel team with qualifiers record
1480:
1481:
1482: PV_TERR_ASSIGN_PUB.Do_Create_Channel_Team (
1483: p_api_version_number => 1.0,
1484: p_init_msg_list => FND_API.G_FALSE ,
1485: p_commit => FND_API.G_FALSE ,
1486: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

Line 1696: l_partner_qualifiers_tbl PV_TERR_ASSIGN_PUB.partner_qualifiers_tbl_type;

1692: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1693:
1694:
1695: --Table for qualifier records
1696: l_partner_qualifiers_tbl PV_TERR_ASSIGN_PUB.partner_qualifiers_tbl_type;
1697: l_party_id NUMBER := p_party_id;
1698:
1699: -- Local variable declaration for Standard Out variables.
1700: l_return_status VARCHAR2(1);

Line 1712: PV_TERR_ASSIGN_PUB. get_partner_details(

1708:
1709: SAVEPOINT create_relationship_pvt;
1710: --Code to build the qualifiers rec and call the relationshi API
1711:
1712: PV_TERR_ASSIGN_PUB. get_partner_details(
1713: p_party_id => l_party_id ,
1714: x_return_status => l_return_status ,
1715: x_msg_count => l_msg_count ,
1716: x_msg_data => l_msg_data ,

Line 1854: ,p_partner_qualifiers_tbl IN PV_TERR_ASSIGN_PUB.partner_qualifiers_tbl_type

1850: ,p_party_site_rec IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE
1851: */
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

Line 1897: l_partner_qualifiers_tbl PV_TERR_ASSIGN_PUB.partner_qualifiers_tbl_type := p_partner_qualifiers_tbl;

1893: l_resp_map_rule_id NUMBER;
1894: l_group_id NUMBER;
1895:
1896: l_party_id NUMBER := p_party_id;
1897: l_partner_qualifiers_tbl PV_TERR_ASSIGN_PUB.partner_qualifiers_tbl_type := p_partner_qualifiers_tbl;
1898: -- Details of local variables used in Create_Person API call.
1899: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE := HZ_PARTY_V2PUB.g_miss_person_rec;
1900: l_cnt_per_party_id NUMBER;
1901: l_cnt_per_party_number NUMBER;