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 1670: -- Function : This procedure is used to create a partner record in PV_TAP_BATCH_CHG_PARTNERS

1666: -- Start of Comments
1667: --
1668: -- API name : CTeam_PartySite_Update
1669: -- Type : Private
1670: -- Function : This procedure is used to create a partner record in PV_TAP_BATCH_CHG_PARTNERS
1671: -- table, if any of the Party Site related partner qualifier change. The Party Site
1672: -- related partner qualifiers is as follows -
1673: -- * Identifying_address_flag
1674: --

Line 1732: FROM pv_tap_batch_chg_partners

1728:
1729: -- Cursor l_chng_partner_exist_csr.
1730: CURSOR l_chng_partner_exist_csr(cv_partner_id NUMBER) IS
1731: SELECT processed_flag, object_version_number
1732: FROM pv_tap_batch_chg_partners
1733: WHERE partner_id = cv_partner_id;
1734:
1735: BEGIN
1736:

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

1862: -- Start of Comments
1863: --
1864: -- API name : CTeam_Location_Update
1865: -- Type : Private
1866: -- Function : This procedure is used to create a partner record in PV_TAP_BATCH_CHG_PARTNERS
1867: -- table, if any of the Location related partner qualifier change. The location
1868: -- related partner qualifiers are as follows -
1869: -- * City
1870: -- * State

Line 1934: FROM pv_tap_batch_chg_partners

1930:
1931: -- Cursor l_chng_partner_exist_csr.
1932: CURSOR l_chng_partner_exist_csr(cv_partner_id NUMBER) IS
1933: SELECT processed_flag, object_version_number
1934: FROM pv_tap_batch_chg_partners
1935: WHERE partner_id = cv_partner_id;
1936:
1937: BEGIN
1938:

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

2069:
2070: --
2071: -- API name : CTeam_ContPoint_Update
2072: -- Type : Private
2073: -- Function : This procedure is used to create a partner record in PV_TAP_BATCH_CHG_PARTNERS
2074: -- table, if any of the Contact Point related partner qualifier change. The contact
2075: -- point related partner qualifiers are as follows -
2076: -- * Area code
2077: --

Line 2170: FROM pv_tap_batch_chg_partners

2166:
2167: -- Cursor l_chng_partner_exist_csr.
2168: CURSOR l_chng_partner_exist_csr(cv_partner_id NUMBER) IS
2169: SELECT processed_flag, object_version_number
2170: FROM pv_tap_batch_chg_partners
2171: WHERE partner_id = cv_partner_id;
2172:
2173: BEGIN
2174: