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_TAP_BATCH_CHG_PARTNERS

Line 30: * that organization record in PV_TAP_BATCH_CHG_PARTNERS table

26: * by TCA in R12 release.
27: * This issue reported by TCA in bug# 4528865. By removing the
28: * reference we are going to ignore whether the change were in any
29: * Territory related transaction qualifier or not. We will insert
30: * that organization record in PV_TAP_BATCH_CHG_PARTNERS table
31: * for Channel team assignment.
32: *
33: *******************************************************************/
34:

Line 1295: -- Function : This procedure is used to create a partner record in PV_TAP_BATCH_CHG_PARTNERS

1291: -- Start of Comments
1292: --
1293: -- API name : CTeam_Org_Update
1294: -- Type : Private
1295: -- Function : This procedure is used to create a partner record in PV_TAP_BATCH_CHG_PARTNERS
1296: -- table, if any of the Organization related partner qualifier change. The Org.
1297: -- related partner qualifiers are as follows -
1298: -- * Organization Name
1299: -- * Customer Category Code

Line 1359: FROM pv_tap_batch_chg_partners

1355:
1356: -- Cursor l_chng_partner_exist_csr.
1357: CURSOR l_chng_partner_exist_csr(cv_partner_id NUMBER) IS
1358: SELECT processed_flag, object_version_number
1359: FROM pv_tap_batch_chg_partners
1360: WHERE partner_id = cv_partner_id;
1361:
1362: BEGIN
1363:

Line 1391: -- Store this partner_id in PV_TAP_BATCH_CHG_PARTNERS table for later processing

1387: IF l_chng_partner_exist_csr%NOTFOUND THEN
1388:
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,

Line 1499: -- Function : This procedure is used to create a partner record in PV_TAP_BATCH_CHG_PARTNERS

1495: -- Start of Comments
1496: --
1497: -- API name : CTeam_PartySite_Update
1498: -- Type : Private
1499: -- Function : This procedure is used to create a partner record in PV_TAP_BATCH_CHG_PARTNERS
1500: -- table, if any of the Party Site related partner qualifier change. The Party Site
1501: -- related partner qualifiers is as follows -
1502: -- * Identifying_address_flag
1503: --

Line 1561: FROM pv_tap_batch_chg_partners

1557:
1558: -- Cursor l_chng_partner_exist_csr.
1559: CURSOR l_chng_partner_exist_csr(cv_partner_id NUMBER) IS
1560: SELECT processed_flag, object_version_number
1561: FROM pv_tap_batch_chg_partners
1562: WHERE partner_id = cv_partner_id;
1563:
1564: BEGIN
1565:

Line 1695: -- Function : This procedure is used to create a partner record in PV_TAP_BATCH_CHG_PARTNERS

1691: -- Start of Comments
1692: --
1693: -- API name : CTeam_Location_Update
1694: -- Type : Private
1695: -- Function : This procedure is used to create a partner record in PV_TAP_BATCH_CHG_PARTNERS
1696: -- table, if any of the Location related partner qualifier change. The location
1697: -- related partner qualifiers are as follows -
1698: -- * City
1699: -- * State

Line 1763: FROM pv_tap_batch_chg_partners

1759:
1760: -- Cursor l_chng_partner_exist_csr.
1761: CURSOR l_chng_partner_exist_csr(cv_partner_id NUMBER) IS
1762: SELECT processed_flag, object_version_number
1763: FROM pv_tap_batch_chg_partners
1764: WHERE partner_id = cv_partner_id;
1765:
1766: BEGIN
1767:

Line 1902: -- Function : This procedure is used to create a partner record in PV_TAP_BATCH_CHG_PARTNERS

1898:
1899: --
1900: -- API name : CTeam_ContPoint_Update
1901: -- Type : Private
1902: -- Function : This procedure is used to create a partner record in PV_TAP_BATCH_CHG_PARTNERS
1903: -- table, if any of the Contact Point related partner qualifier change. The contact
1904: -- point related partner qualifiers are as follows -
1905: -- * Area code
1906: --

Line 1999: FROM pv_tap_batch_chg_partners

1995:
1996: -- Cursor l_chng_partner_exist_csr.
1997: CURSOR l_chng_partner_exist_csr(cv_partner_id NUMBER) IS
1998: SELECT processed_flag, object_version_number
1999: FROM pv_tap_batch_chg_partners
2000: WHERE partner_id = cv_partner_id;
2001:
2002: BEGIN
2003: