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 1716: -- 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;

1712: l_msg_data VARCHAR(2000);
1713: l_processed_flag VARCHAR2(1);
1714: l_object_version NUMBER;
1715:
1716: -- 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;
1717: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
1718:
1719: -- Cursor l_cust_is_partner_csr.
1720: CURSOR l_cust_is_partner_csr (cv_party_site_id NUMBER) IS

Line 1717: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;

1713: l_processed_flag VARCHAR2(1);
1714: l_object_version NUMBER;
1715:
1716: -- 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;
1717: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
1718:
1719: -- Cursor l_cust_is_partner_csr.
1720: CURSOR l_cust_is_partner_csr (cv_party_site_id NUMBER) IS
1721: SELECT partner_id

Line 1761: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(

1757: IF l_chng_partner_exist_csr%NOTFOUND THEN
1758: CLOSE l_chng_partner_exist_csr;
1759:
1760: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1761: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1762: p_api_version_number => 1.0 ,
1763: p_init_msg_list => FND_API.G_FALSE,
1764: p_commit => FND_API.G_FALSE,
1765: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1783: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(

1779: ELSE
1780: CLOSE l_chng_partner_exist_csr;
1781: IF (l_processed_flag <> 'P') THEN
1782: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1783: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1784: p_api_version_number => 1.0
1785: ,p_init_msg_list => FND_API.G_FALSE
1786: ,p_commit => FND_API.G_FALSE
1787: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

1794: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1795: RAISE FND_API.G_EXC_ERROR;
1796: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1798: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1799: FND_MSG_PUB.Add;
1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1801: END IF;
1802: END IF;

Line 1915: --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;

1911: l_msg_data VARCHAR(2000);
1912: l_processed_flag VARCHAR2(1);
1913: l_object_version NUMBER;
1914:
1915: --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;
1916: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
1917:
1918: -- Cursor l_cust_is_partner_csr.
1919: CURSOR l_cust_is_partner_csr (cv_location_id NUMBER) IS

Line 1916: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;

1912: l_processed_flag VARCHAR2(1);
1913: l_object_version NUMBER;
1914:
1915: --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;
1916: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
1917:
1918: -- Cursor l_cust_is_partner_csr.
1919: CURSOR l_cust_is_partner_csr (cv_location_id NUMBER) IS
1920: SELECT ppp.partner_id

Line 1969: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(

1965:
1966: CLOSE l_chng_partner_exist_csr;
1967:
1968: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1969: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1970: p_api_version_number => 1.0 ,
1971: p_init_msg_list => FND_API.G_FALSE,
1972: p_commit => FND_API.G_FALSE,
1973: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1991: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(

1987: ELSE
1988: CLOSE l_chng_partner_exist_csr;
1989: IF (l_processed_flag <> 'P') THEN
1990: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1991: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1992: p_api_version_number => 1.0
1993: ,p_init_msg_list => FND_API.G_FALSE
1994: ,p_commit => FND_API.G_FALSE
1995: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

2002: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2003: RAISE FND_API.G_EXC_ERROR;
2004: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2005: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2006: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2007: FND_MSG_PUB.Add;
2008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2009: END IF;
2010: END IF;

Line 2129: -- 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;

2125: l_msg_data VARCHAR(2000);
2126: l_processed_flag VARCHAR2(1);
2127: l_object_version NUMBER;
2128:
2129: -- 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;
2130: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
2131:
2132: -- Cursor l_cust_is_partner_csr.
2133: CURSOR l_cust_is_partner_csr (cv_contact_point_id NUMBER) IS

Line 2130: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;

2126: l_processed_flag VARCHAR2(1);
2127: l_object_version NUMBER;
2128:
2129: -- 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;
2130: l_batch_chg_prtnrs_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
2131:
2132: -- Cursor l_cust_is_partner_csr.
2133: CURSOR l_cust_is_partner_csr (cv_contact_point_id NUMBER) IS
2134: SELECT /*+ index(p) */ partner_id

Line 2198: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(

2194: IF l_chng_partner_exist_csr%NOTFOUND THEN
2195: CLOSE l_chng_partner_exist_csr;
2196:
2197: -- Call Channel_Team_Organization_Update to re-assign the Channel team
2198: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
2199: p_api_version_number => 1.0 ,
2200: p_init_msg_list => FND_API.G_FALSE,
2201: p_commit => FND_API.G_FALSE,
2202: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2222: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(

2218:
2219: IF (l_processed_flag <> 'P') THEN
2220: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
2221:
2222: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
2223: p_api_version_number => 1.0
2224: ,p_init_msg_list => FND_API.G_FALSE
2225: ,p_commit => FND_API.G_FALSE
2226: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

2233: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2234: RAISE FND_API.G_EXC_ERROR;
2235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2236: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2237: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2238: FND_MSG_PUB.Add;
2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2240: END IF;
2241: END IF;