DBA Data[Home] [Help]

APPS.PV_TERR_ASSIGN_PUB dependencies on PV_TAP_ACCESS_TERRS_PVT

Line 1549: l_territory_access_rec PV_TAP_ACCESS_TERRS_PVT.TAP_ACCESS_TERRS_REC_TYPE ;

1545: l_msg_data VARCHAR(2000);
1546: l_res_created_flg VARCHAR2(1);
1547: l_tap_created_flg VARCHAR2(1);
1548: l_partner_access_id NUMBER;
1549: l_territory_access_rec PV_TAP_ACCESS_TERRS_PVT.TAP_ACCESS_TERRS_REC_TYPE ;
1550: l_resource_cnt NUMBER ;
1551: l_resource_rec PV_TERR_ASSIGN_PUB.ResourceRec;
1552: l_partner_type VARCHAR2(500) ;
1553: j_index NUMBER;

Line 1624: PV_TAP_ACCESS_TERRS_PVT.Create_Tap_Access_Terrs(

1620: l_territory_access_rec.partner_access_id,
1621: l_territory_access_rec.terr_id ) = 'N' ) THEN
1622:
1623: --- Create a Territory Accesses record for the given Partner_access_id.
1624: PV_TAP_ACCESS_TERRS_PVT.Create_Tap_Access_Terrs(
1625: p_api_version_number => 1.0,
1626: p_init_msg_list => FND_API.G_FALSE,
1627: p_commit => FND_API.G_FALSE,
1628: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1699: PV_TAP_ACCESS_TERRS_PVT.Create_Tap_Access_Terrs(

1695: l_territory_access_rec.partner_access_id,
1696: l_territory_access_rec.terr_id ) = 'N' ) THEN
1697:
1698: /* Create a Territory Accesses record for the given Partner_access_id */
1699: PV_TAP_ACCESS_TERRS_PVT.Create_Tap_Access_Terrs(
1700: p_api_version_number => 1.0,
1701: p_init_msg_list => FND_API.G_FALSE,
1702: p_commit => FND_API.G_FALSE,
1703: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2091: PV_TAP_ACCESS_TERRS_PVT.Delete_Tap_Access_Terrs(

2087: LOOP
2088: -- Delete the Territory record for the given PARTNER_ACCESS_ID and TERR_ID
2089: -- from PV_TAP_ACCESS_TERRS table.
2090:
2091: PV_TAP_ACCESS_TERRS_PVT.Delete_Tap_Access_Terrs(
2092: p_api_version_number => 1.0,
2093: p_init_msg_list => FND_API.G_FALSE,
2094: p_commit => FND_API.G_FALSE,
2095: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2108: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TAP_ACCESS_TERRS_PVT.Delete_Tap_Access_Terrs');

2104: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2105: RAISE FND_API.G_EXC_ERROR;
2106: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2107: -- FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2108: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TAP_ACCESS_TERRS_PVT.Delete_Tap_Access_Terrs');
2109: -- FND_MSG_PUB.Add;
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112: END IF;

Line 3545: l_territory_access_rec PV_TAP_ACCESS_TERRS_PVT.TAP_ACCESS_TERRS_REC_TYPE ;

3541: l_partner_access_id NUMBER := 0;
3542: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
3543: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
3544: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
3545: l_territory_access_rec PV_TAP_ACCESS_TERRS_PVT.TAP_ACCESS_TERRS_REC_TYPE ;
3546: l_resource_cnt NUMBER := 0;
3547: l_cm_added VARCHAR2(1) := 'N' ;
3548: l_res_created_flg VARCHAR2(1) := 'N' ;
3549: l_tap_created_flg VARCHAR2(1) := 'N' ;

Line 4111: l_territory_access_rec PV_TAP_ACCESS_TERRS_PVT.TAP_ACCESS_TERRS_REC_TYPE ;

4107: l_partner_access_id NUMBER := 0;
4108: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
4109: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
4110: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
4111: l_territory_access_rec PV_TAP_ACCESS_TERRS_PVT.TAP_ACCESS_TERRS_REC_TYPE ;
4112: l_resource_cnt NUMBER := 0;
4113: l_cm_added VARCHAR2(1) := 'N' ;
4114: l_res_created_flg VARCHAR2(1) := 'N' ;
4115: l_tap_created_flg VARCHAR2(1) := 'N' ;