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_TERR_ASSIGN_PUB dependencies on PV_TAP_ACCESS_TERRS

Line 602: -- exists in the PV_TAP_ACCESS_TERRS table or not.

598: -- Funtion name : Check_Territory_Exist
599: -- Type : Private
600: -- Function : The purpose of this function is to to check, whether for
601: -- the given territory_id and the partner_access_id, record
602: -- exists in the PV_TAP_ACCESS_TERRS table or not.
603: --
604: -- Pre-reqs :
605: --
606: -- Paramaeters :

Line 626: FROM PV_TAP_ACCESS_TERRS

622: IS
623: l_territory_exist VARCHAR2(1) ;
624: CURSOR l_chk_terr_exist_csr(cv_terr_id NUMBER, cv_partner_access_id NUMBER) IS
625: SELECT 'Y'
626: FROM PV_TAP_ACCESS_TERRS
627: WHERE terr_id = cv_terr_id
628: AND partner_access_id = cv_partner_access_id ;
629: BEGIN
630: l_territory_exist := 'N';

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 2017: -- Channel team member from PV_TAP_ACCESS_TERRS table.

2013: -- Type : Private
2014: -- Function : The purpose of this procedure is to delete a Channel
2015: -- team for a given Partner_id in the PV_PARTNER_ACCESSES
2016: -- table and also delete the territory information for that
2017: -- Channel team member from PV_TAP_ACCESS_TERRS table.
2018: --
2019: -- Pre-reqs : It deletes the Channel team members, if any exists in the
2020: -- PV_PARTNER_ACCESSES table for a given partner_id. It also
2021: -- deletes the information about territory for that channel

Line 2022: -- team member, if any exists in the PV_TAP_ACCESS_TERRS table.

2018: --
2019: -- Pre-reqs : It deletes the Channel team members, if any exists in the
2020: -- PV_PARTNER_ACCESSES table for a given partner_id. It also
2021: -- deletes the information about territory for that channel
2022: -- team member, if any exists in the PV_TAP_ACCESS_TERRS table.
2023: --
2024: -- Paramaeters :
2025: -- IN :
2026: -- p_partner_id IN NUMBER

Line 2064: -- partner_access_id, which we have to delete from PV_TAP_ACCESS_TERRS table.

2060: AND KEEP_FLAG = 'N'
2061: AND CREATED_BY_TAP_FLAG = 'Y';
2062:
2063: -- Cursor l_territory_csr to get all the territory record for a given
2064: -- partner_access_id, which we have to delete from PV_TAP_ACCESS_TERRS table.
2065: CURSOR l_territory_csr (cv_partner_access_id IN NUMBER) IS
2066: SELECT partner_access_id, terr_id, object_version_number
2067: FROM PV_TAP_ACCESS_TERRS
2068: WHERE partner_access_id = cv_partner_access_id;

Line 2067: FROM PV_TAP_ACCESS_TERRS

2063: -- Cursor l_territory_csr to get all the territory record for a given
2064: -- partner_access_id, which we have to delete from PV_TAP_ACCESS_TERRS table.
2065: CURSOR l_territory_csr (cv_partner_access_id IN NUMBER) IS
2066: SELECT partner_access_id, terr_id, object_version_number
2067: FROM PV_TAP_ACCESS_TERRS
2068: WHERE partner_access_id = cv_partner_access_id;
2069:
2070: BEGIN
2071:

Line 2083: /*** First Delete, if any territory record exists in the PV_TAP_ACCESS_TERRS table for

2079:
2080: -- Find out all the Channel Team members for a given partner_id from l_channel_team_csr.
2081: FOR l_channel_team_rec IN l_channel_team_csr(p_partner_id)
2082: LOOP
2083: /*** First Delete, if any territory record exists in the PV_TAP_ACCESS_TERRS table for
2084: a gievn partner_access_id ***/
2085:
2086: FOR l_territory_rec IN l_territory_csr( l_channel_team_rec.partner_access_id)
2087: LOOP

Line 2089: -- from PV_TAP_ACCESS_TERRS table.

2085:
2086: FOR l_territory_rec IN l_territory_csr( l_channel_team_rec.partner_access_id)
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,

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 2315: -- PV_TAP_ACCESS_TERRS table or not.

2311: AND entity_id = cv_partner_id
2312: AND latest_flag = 'Y';
2313:
2314: -- Cursor l_chk_territory_exist_csr to check whether given partner_access_id and terr_id exists in
2315: -- PV_TAP_ACCESS_TERRS table or not.
2316: CURSOR l_chk_territory_exist_csr (cv_partner_access_id IN NUMBER, cv_terr_id IN NUMBER) IS
2317: SELECT 'Y'
2318: FROM PV_TAP_ACCESS_TERRS
2319: WHERE partner_access_id = cv_partner_access_id

Line 2318: FROM PV_TAP_ACCESS_TERRS

2314: -- Cursor l_chk_territory_exist_csr to check whether given partner_access_id and terr_id exists in
2315: -- PV_TAP_ACCESS_TERRS table or not.
2316: CURSOR l_chk_territory_exist_csr (cv_partner_access_id IN NUMBER, cv_terr_id IN NUMBER) IS
2317: SELECT 'Y'
2318: FROM PV_TAP_ACCESS_TERRS
2319: WHERE partner_access_id = cv_partner_access_id
2320: AND terr_id = cv_terr_id;
2321:
2322: BEGIN

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 3576: -- PV_TAP_ACCESS_TERRS table or not.

3572: AND entity_id = cv_partner_id
3573: AND latest_flag = 'Y';
3574:
3575: -- Cursor l_chk_territory_exist_csr to check whether given partner_access_id and terr_id exists in
3576: -- PV_TAP_ACCESS_TERRS table or not.
3577: CURSOR l_chk_territory_exist_csr (cv_partner_access_id IN NUMBER, cv_terr_id IN NUMBER) IS
3578: SELECT 'Y'
3579: FROM PV_TAP_ACCESS_TERRS
3580: WHERE partner_access_id = cv_partner_access_id

Line 3579: FROM PV_TAP_ACCESS_TERRS

3575: -- Cursor l_chk_territory_exist_csr to check whether given partner_access_id and terr_id exists in
3576: -- PV_TAP_ACCESS_TERRS table or not.
3577: CURSOR l_chk_territory_exist_csr (cv_partner_access_id IN NUMBER, cv_terr_id IN NUMBER) IS
3578: SELECT 'Y'
3579: FROM PV_TAP_ACCESS_TERRS
3580: WHERE partner_access_id = cv_partner_access_id
3581: AND terr_id = cv_terr_id;
3582: */
3583: BEGIN

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' ;

Line 4142: -- PV_TAP_ACCESS_TERRS table or not.

4138: AND entity_id = cv_partner_id
4139: AND latest_flag = 'Y';
4140:
4141: -- Cursor l_chk_territory_exist_csr to check whether given partner_access_id and terr_id exists in
4142: -- PV_TAP_ACCESS_TERRS table or not.
4143: CURSOR l_chk_territory_exist_csr (cv_partner_access_id IN NUMBER, cv_terr_id IN NUMBER) IS
4144: SELECT 'Y'
4145: FROM PV_TAP_ACCESS_TERRS
4146: WHERE partner_access_id = cv_partner_access_id

Line 4145: FROM PV_TAP_ACCESS_TERRS

4141: -- Cursor l_chk_territory_exist_csr to check whether given partner_access_id and terr_id exists in
4142: -- PV_TAP_ACCESS_TERRS table or not.
4143: CURSOR l_chk_territory_exist_csr (cv_partner_access_id IN NUMBER, cv_terr_id IN NUMBER) IS
4144: SELECT 'Y'
4145: FROM PV_TAP_ACCESS_TERRS
4146: WHERE partner_access_id = cv_partner_access_id
4147: AND terr_id = cv_terr_id;
4148:
4149: BEGIN

Line 6194: pv_tap_access_terrs ptat

6190: cv_terr_id19 NUMBER, cv_terr_id20 NUMBER ) IS
6191: SELECT ppa.partner_id
6192: FROM pv_partner_accesses ppa,
6193: pv_partner_profiles ppp,
6194: pv_tap_access_terrs ptat
6195: WHERE ppa.partner_access_id = ptat.partner_access_id
6196: AND ppa.partner_id = ppp.partner_id
6197: AND ppp.status = 'A'
6198: AND ptat.terr_id IN (