eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_TAP_BES_PKG dependencies on PV_BATCH_CHG_PRTNR_PVT

Line 1346: -- l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type:= PV_BATCH_CHG_PRTNR_PVT.g_miss_Batch_Chg_Prtnrs_rec;

1342: l_msg_data VARCHAR(2000);
1343: l_processed_flag VARCHAR2(1);
1344: l_object_version NUMBER;
1345:
1346: -- l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type:= PV_BATCH_CHG_PRTNR_PVT.g_miss_Batch_Chg_Prtnrs_rec;
1347: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
1348:
1349: -- Cursor l_cust_is_partner_csr.
1350: CURSOR l_cust_is_partner_csr (cv_partner_party_id NUMBER) IS

Line 1347: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;

1343: l_processed_flag VARCHAR2(1);
1344: l_object_version NUMBER;
1345:
1346: -- l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type:= PV_BATCH_CHG_PRTNR_PVT.g_miss_Batch_Chg_Prtnrs_rec;
1347: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
1348:
1349: -- Cursor l_cust_is_partner_csr.
1350: CURSOR l_cust_is_partner_csr (cv_partner_party_id NUMBER) IS
1351: SELECT partner_id

Line 1393: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(

1389: CLOSE l_chng_partner_exist_csr;
1390:
1391: -- Store this partner_id in PV_TAP_BATCH_CHG_PARTNERS table for later processing
1392: -- for channel team assignment.
1393: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1394: p_api_version_number => 1.0 ,
1395: p_init_msg_list => FND_API.G_FALSE,
1396: p_commit => FND_API.G_FALSE,
1397: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1415: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(

1411: ELSE
1412: CLOSE l_chng_partner_exist_csr;
1413: IF (l_processed_flag <> 'P') THEN
1414: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1415: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
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 1430: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

1426: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1429: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1430: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1431: FND_MSG_PUB.Add;
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1433: END IF;
1434: END IF;

Line 1545: -- l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type:= PV_BATCH_CHG_PRTNR_PVT.g_miss_Batch_Chg_Prtnrs_rec;

1541: l_msg_data VARCHAR(2000);
1542: l_processed_flag VARCHAR2(1);
1543: l_object_version NUMBER;
1544:
1545: -- l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type:= PV_BATCH_CHG_PRTNR_PVT.g_miss_Batch_Chg_Prtnrs_rec;
1546: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
1547:
1548: -- Cursor l_cust_is_partner_csr.
1549: CURSOR l_cust_is_partner_csr (cv_party_site_id NUMBER) IS

Line 1546: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;

1542: l_processed_flag VARCHAR2(1);
1543: l_object_version NUMBER;
1544:
1545: -- l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type:= PV_BATCH_CHG_PRTNR_PVT.g_miss_Batch_Chg_Prtnrs_rec;
1546: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
1547:
1548: -- Cursor l_cust_is_partner_csr.
1549: CURSOR l_cust_is_partner_csr (cv_party_site_id NUMBER) IS
1550: SELECT partner_id

Line 1590: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(

1586: IF l_chng_partner_exist_csr%NOTFOUND THEN
1587: CLOSE l_chng_partner_exist_csr;
1588:
1589: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1590: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1591: p_api_version_number => 1.0 ,
1592: p_init_msg_list => FND_API.G_FALSE,
1593: p_commit => FND_API.G_FALSE,
1594: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1612: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(

1608: ELSE
1609: CLOSE l_chng_partner_exist_csr;
1610: IF (l_processed_flag <> 'P') THEN
1611: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1612: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1613: p_api_version_number => 1.0
1614: ,p_init_msg_list => FND_API.G_FALSE
1615: ,p_commit => FND_API.G_FALSE
1616: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1627: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

1623: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1624: RAISE FND_API.G_EXC_ERROR;
1625: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1627: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1628: FND_MSG_PUB.Add;
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: END IF;
1631: END IF;

Line 1744: --l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type:= PV_BATCH_CHG_PRTNR_PVT.g_miss_Batch_Chg_Prtnrs_rec;

1740: l_msg_data VARCHAR(2000);
1741: l_processed_flag VARCHAR2(1);
1742: l_object_version NUMBER;
1743:
1744: --l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type:= PV_BATCH_CHG_PRTNR_PVT.g_miss_Batch_Chg_Prtnrs_rec;
1745: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
1746:
1747: -- Cursor l_cust_is_partner_csr.
1748: CURSOR l_cust_is_partner_csr (cv_location_id NUMBER) IS

Line 1745: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;

1741: l_processed_flag VARCHAR2(1);
1742: l_object_version NUMBER;
1743:
1744: --l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type:= PV_BATCH_CHG_PRTNR_PVT.g_miss_Batch_Chg_Prtnrs_rec;
1745: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
1746:
1747: -- Cursor l_cust_is_partner_csr.
1748: CURSOR l_cust_is_partner_csr (cv_location_id NUMBER) IS
1749: SELECT ppp.partner_id

Line 1798: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(

1794:
1795: CLOSE l_chng_partner_exist_csr;
1796:
1797: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1798: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1799: p_api_version_number => 1.0 ,
1800: p_init_msg_list => FND_API.G_FALSE,
1801: p_commit => FND_API.G_FALSE,
1802: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1820: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(

1816: ELSE
1817: CLOSE l_chng_partner_exist_csr;
1818: IF (l_processed_flag <> 'P') THEN
1819: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1820: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1821: p_api_version_number => 1.0
1822: ,p_init_msg_list => FND_API.G_FALSE
1823: ,p_commit => FND_API.G_FALSE
1824: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1835: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

1831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1834: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1835: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1836: FND_MSG_PUB.Add;
1837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1838: END IF;
1839: END IF;

Line 1958: -- l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type:= PV_BATCH_CHG_PRTNR_PVT.g_miss_Batch_Chg_Prtnrs_rec;

1954: l_msg_data VARCHAR(2000);
1955: l_processed_flag VARCHAR2(1);
1956: l_object_version NUMBER;
1957:
1958: -- l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type:= PV_BATCH_CHG_PRTNR_PVT.g_miss_Batch_Chg_Prtnrs_rec;
1959: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
1960:
1961: -- Cursor l_cust_is_partner_csr.
1962: CURSOR l_cust_is_partner_csr (cv_contact_point_id NUMBER) IS

Line 1959: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;

1955: l_processed_flag VARCHAR2(1);
1956: l_object_version NUMBER;
1957:
1958: -- l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type:= PV_BATCH_CHG_PRTNR_PVT.g_miss_Batch_Chg_Prtnrs_rec;
1959: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
1960:
1961: -- Cursor l_cust_is_partner_csr.
1962: CURSOR l_cust_is_partner_csr (cv_contact_point_id NUMBER) IS
1963: SELECT /*+ index(p) */ partner_id

Line 2027: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(

2023: IF l_chng_partner_exist_csr%NOTFOUND THEN
2024: CLOSE l_chng_partner_exist_csr;
2025:
2026: -- Call Channel_Team_Organization_Update to re-assign the Channel team
2027: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
2028: p_api_version_number => 1.0 ,
2029: p_init_msg_list => FND_API.G_FALSE,
2030: p_commit => FND_API.G_FALSE,
2031: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2051: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(

2047:
2048: IF (l_processed_flag <> 'P') THEN
2049: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
2050:
2051: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
2052: p_api_version_number => 1.0
2053: ,p_init_msg_list => FND_API.G_FALSE
2054: ,p_commit => FND_API.G_FALSE
2055: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2066: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

2062: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2063: RAISE FND_API.G_EXC_ERROR;
2064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2065: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2066: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2067: FND_MSG_PUB.Add;
2068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2069: END IF;
2070: END IF;