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_PARTNER_ACCESSES

Line 513: -- in the PV_PARTNER_ACCESSES table.

509: -- Funtion name : check_resource_exist
510: -- Type : Private
511: -- Function : The purpose of this function is to to check, whether the
512: -- given resource and the partner org record does not exists
513: -- in the PV_PARTNER_ACCESSES table.
514: --
515: -- Pre-reqs :
516: --
517: -- Paramaeters :

Line 538: FROM PV_PARTNER_ACCESSES

534: l_resource_exist VARCHAR2(1) ;
535:
536: CURSOR l_chk_resource_exist_csr(cv_partner_id NUMBER, cv_resource_id NUMBER) IS
537: SELECT 'Y'
538: FROM PV_PARTNER_ACCESSES
539: WHERE partner_id = cv_partner_id
540: AND resource_id = cv_resource_id ;
541: BEGIN
542: l_resource_exist := 'N';

Line 582: FROM PV_PARTNER_ACCESSES

578: l_exist VARCHAR2(1) ;
579:
580: CURSOR l_chk_channel_team_exist_csr(cv_partner_id NUMBER) IS
581: SELECT 'Y'
582: FROM PV_PARTNER_ACCESSES
583: WHERE partner_id = cv_partner_id;
584: BEGIN
585: l_exist := 'N';
586: OPEN l_chk_channel_team_exist_csr(p_partner_id);

Line 832: -- record in PV_PARTNER_ACCESSES table for the supplied resource_id

828: --
829: -- Funtion name : Chk_To_Create_Access_Rec
830: -- Type : Private
831: -- Function : The purpose of this procedure is to check, whether we can cretae a
832: -- record in PV_PARTNER_ACCESSES table for the supplied resource_id
833: -- and the given partner_id.
834: --
835: -- Pre-reqs :
836: --

Line 872: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;

868: l_res_created_flg VARCHAR2(1) ;
869: l_tap_created_flg VARCHAR2(1) ;
870: l_partner_access_id NUMBER;
871: l_VAD_partner_id NUMBER;
872: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
873:
874: l_return_status VARCHAR2(1);
875: l_msg_count NUMBER;
876: l_msg_data VARCHAR(2000);

Line 879: -- PV_PARTNER_ACCESSES table or not.

875: l_msg_count NUMBER;
876: l_msg_data VARCHAR(2000);
877:
878: -- Cursor l_chk_resource_exist_csr to check whether given resource_id and partner_id exists in
879: -- PV_PARTNER_ACCESSES table or not.
880: CURSOR l_chk_resource_exist_csr (cv_partner_id IN NUMBER, cv_resource_id IN NUMBER) IS
881: SELECT partner_access_id,
882: created_by_tap_flag
883: FROM PV_PARTNER_ACCESSES

Line 883: FROM PV_PARTNER_ACCESSES

879: -- PV_PARTNER_ACCESSES table or not.
880: CURSOR l_chk_resource_exist_csr (cv_partner_id IN NUMBER, cv_resource_id IN NUMBER) IS
881: SELECT partner_access_id,
882: created_by_tap_flag
883: FROM PV_PARTNER_ACCESSES
884: WHERE partner_id = cv_partner_id
885: AND resource_id = cv_resource_id;
886:
887: CURSOR l_VAD_Org_csr(cv_resource_id IN NUMBER) IS

Line 969: PV_Partner_Accesses_PVT.Create_Partner_Accesses(

965: l_partner_access_rec.keep_flag := 'N';
966: l_partner_access_rec.created_by_tap_flag := 'Y';
967: l_partner_access_rec.access_type := 'F';
968:
969: PV_Partner_Accesses_PVT.Create_Partner_Accesses(
970: p_api_version_number => 1.0,
971: p_init_msg_list => FND_API.G_FALSE,
972: p_commit => FND_API.G_FALSE,
973: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1048: -- PV_PARTNER_ACCESSES table as a Channel team member, if the logged

1044: --
1045: -- Funtion name : Cr_Login_User_Access_Rec
1046: -- Type : Private
1047: -- Function : The purpose of this procedure is to add the logged-in user to
1048: -- PV_PARTNER_ACCESSES table as a Channel team member, if the logged
1049: -- in user has a 'CHANNEL_MANAGER' or CHANNEL_REP' role.
1050: --
1051: -- Pre-reqs :
1052: --

Line 1092: FROM PV_PARTNER_ACCESSES

1088:
1089: CURSOR l_user_exists_csr(cv_partner_id NUMBER,
1090: cv_resource_id NUMBER ) IS
1091: SELECT 'Y'
1092: FROM PV_PARTNER_ACCESSES
1093: WHERE partner_id = cv_partner_id
1094: AND resource_id = cv_resource_id;
1095:
1096: l_resource_id NUMBER ;

Line 1105: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;

1101: l_res_created_flg VARCHAR2(1) ;
1102: l_partner_access_id NUMBER;
1103: l_cm_added VARCHAR2(1) ;
1104: l_user_exists VARCHAR2(1) ;
1105: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
1106:
1107: BEGIN
1108:
1109: l_res_created_flg := 'N';

Line 1128: in user record in the PV_PARTNER_ACCESSES table */

1124: OPEN l_user_exists_csr(p_partner_id, l_resource_id);
1125: FETCH l_user_exists_csr INTO l_user_exists ;
1126: IF (l_user_exists_csr%NOTFOUND ) THEN
1127: /* Call Chk_To_Create_Access_Rec procedure to create the logged
1128: in user record in the PV_PARTNER_ACCESSES table */
1129: /* Set the p_partner_access_rec record */
1130: l_partner_access_rec.partner_id := p_partner_id;
1131: l_partner_access_rec.resource_id := l_resource_id;
1132: l_partner_access_rec.keep_flag := 'Y';

Line 1136: PV_Partner_Accesses_PVT.Create_Partner_Accesses(

1132: l_partner_access_rec.keep_flag := 'Y';
1133: l_partner_access_rec.created_by_tap_flag := 'N';
1134: l_partner_access_rec.access_type := 'F';
1135:
1136: PV_Partner_Accesses_PVT.Create_Partner_Accesses(
1137: p_api_version_number => 1.0,
1138: p_init_msg_list => FND_API.G_FALSE,
1139: p_commit => FND_API.G_FALSE,
1140: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2015: -- team for a given Partner_id in the PV_PARTNER_ACCESSES

2011: --
2012: -- API name : Delete_Channel_Team
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

Line 2020: -- PV_PARTNER_ACCESSES table for a given partner_id. It also

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
2022: -- team member, if any exists in the PV_TAP_ACCESS_TERRS table.
2023: --
2024: -- Paramaeters :

Line 2055: -- partner_id, which we have to delete from PV_PARTNER_ACCESSES table.

2051: l_msg_data VARCHAR(2000);
2052: l_partner_id NUMBER;
2053:
2054: -- Cursor l_channel_team_csr to get all the channel team members for a given
2055: -- partner_id, which we have to delete from PV_PARTNER_ACCESSES table.
2056: CURSOR l_channel_team_csr (cv_partner_id IN NUMBER) IS
2057: SELECT partner_access_id, object_version_number
2058: FROM PV_PARTNER_ACCESSES
2059: WHERE partner_id = cv_partner_id

Line 2058: FROM PV_PARTNER_ACCESSES

2054: -- Cursor l_channel_team_csr to get all the channel team members for a given
2055: -- partner_id, which we have to delete from PV_PARTNER_ACCESSES table.
2056: CURSOR l_channel_team_csr (cv_partner_id IN NUMBER) IS
2057: SELECT partner_access_id, object_version_number
2058: FROM PV_PARTNER_ACCESSES
2059: WHERE partner_id = cv_partner_id
2060: AND KEEP_FLAG = 'N'
2061: AND CREATED_BY_TAP_FLAG = 'Y';
2062:

Line 2117: -- from PV_PARTNER_ACCESSES table.

2113:
2114: END LOOP; /* FOR l_territory_rec IN l_territory_csr( l_channel_team_rec.partner_access_id) */
2115:
2116: -- Delete the Partner Access record for the given PARTNER_ACCESS_ID
2117: -- from PV_PARTNER_ACCESSES table.
2118: PV_Partner_Accesses_PVT.Delete_Partner_Accesses(
2119: p_api_version_number => 1.0,
2120: p_init_msg_list => FND_API.G_FALSE,
2121: p_commit => FND_API.G_FALSE,

Line 2118: PV_Partner_Accesses_PVT.Delete_Partner_Accesses(

2114: END LOOP; /* FOR l_territory_rec IN l_territory_csr( l_channel_team_rec.partner_access_id) */
2115:
2116: -- Delete the Partner Access record for the given PARTNER_ACCESS_ID
2117: -- from PV_PARTNER_ACCESSES table.
2118: PV_Partner_Accesses_PVT.Delete_Partner_Accesses(
2119: p_api_version_number => 1.0,
2120: p_init_msg_list => FND_API.G_FALSE,
2121: p_commit => FND_API.G_FALSE,
2122: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2134: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Delete_Partner_Accesses');

2130: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2131: RAISE FND_API.G_EXC_ERROR;
2132: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2133: -- FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2134: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Delete_Partner_Accesses');
2135: -- FND_MSG_PUB.Add;
2136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2137: END IF;
2138: END IF;

Line 2625: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;

2621: l_vad_prtnr_access_id_tbl prtnr_aces_tbl_type;
2622: l_partner_id NUMBER;
2623: i NUMBER := 0;
2624: l_partner_access_id NUMBER := 0;
2625: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
2626: l_resource_cnt NUMBER := 0;
2627: l_cm_added VARCHAR2(1) := 'N' ;
2628: l_res_created_flg VARCHAR2(1) := 'N' ;
2629: l_login_user_id NUMBER;

Line 2677: -- PV_PARTNER_ACCESSES table, IF the user is playing a role of

2673: END IF;
2674:
2675: -- STEP (i) :
2676: -- Logic for inserting the logged in user's(Vendor employee) resource_id in the
2677: -- PV_PARTNER_ACCESSES table, IF the user is playing a role of
2678: -- 'CHANNEL_MANAGER' or 'CHANNEL_REP'
2679:
2680: IF (p_mode <> 'UPDATE') THEN
2681: IF (p_vad_partner_id IS NULL OR p_vad_partner_id = FND_API.g_miss_num) THEN

Line 2812: PV_Partner_Accesses_PVT.Create_Partner_Accesses(

2808: IF (check_channel_team_exist(
2809: p_partner_id => l_partner_id) = 'N') THEN
2810:
2811:
2812: PV_Partner_Accesses_PVT.Create_Partner_Accesses(
2813: p_api_version_number => 1.0,
2814: p_init_msg_list => FND_API.G_FALSE,
2815: p_commit => FND_API.G_FALSE,
2816: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2828: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Create_Partner_Accesses');

2824: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2825: RAISE FND_API.G_EXC_ERROR;
2826: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2827: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2828: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Create_Partner_Accesses');
2829: FND_MSG_PUB.Add;
2830: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2831: END IF;
2832: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 3542: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;

3538: l_partner_qualifier_rec partner_qualifiers_rec_type ;
3539: l_partner_exist VARCHAR2(1) := 'N';
3540: l_territory_exist VARCHAR2(1) := 'N';
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;

Line 3629: -- PV_PARTNER_ACCESSES table, IF the user is playing a role of

3625: END IF;
3626:
3627: -- STEP (i) :
3628: -- Logic for inserting the logged in user's(Vendor employee) resource_id in the
3629: -- PV_PARTNER_ACCESSES table, IF the user is playing a role of
3630: -- 'CHANNEL_MANAGER' or 'CHANNEL_REP'
3631:
3632: IF (p_mode <> 'UPDATE') THEN
3633: IF (p_vad_partner_id IS NULL OR p_vad_partner_id = FND_API.g_miss_num) THEN

Line 3914: PV_Partner_Accesses_PVT.Create_Partner_Accesses(

3910: p_partner_id => l_partner_id
3911: ,p_resource_id => l_partner_access_rec.resource_id ) = 'N') THEN
3912:
3913:
3914: PV_Partner_Accesses_PVT.Create_Partner_Accesses(
3915: p_api_version_number => 1.0,
3916: p_init_msg_list => FND_API.G_FALSE,
3917: p_commit => FND_API.G_FALSE,
3918: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3930: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Create_Partner_Accesses');

3926: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3927: RAISE FND_API.G_EXC_ERROR;
3928: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3929: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3930: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Create_Partner_Accesses');
3931: FND_MSG_PUB.Add;
3932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3933: END IF;
3934: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 4020: -- team for a given Partner_id in the PV_PARTNER_ACCESSES

4016: --
4017: -- API name : Create_Online_Channel_Team
4018: -- Type : Public
4019: -- Function : The purpose of this procedure is to create a Channel
4020: -- team for a given Partner_id in the PV_PARTNER_ACCESSES
4021: -- table.
4022: --
4023: -- Pre-reqs : Existing resource should have a "Channel Manager" or
4024: -- "Channel Rep" role at group level.

Line 4108: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;

4104: l_partner_qualifier_rec partner_qualifiers_rec_type ;
4105: l_partner_exist VARCHAR2(1) := 'N';
4106: l_territory_exist VARCHAR2(1) := 'N';
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;

Line 4189: -- PV_PARTNER_ACCESSES table, IF the user is playing a role of

4185: END IF;
4186:
4187: -- STEP (i) :
4188: -- Logic for inserting the logged in user's(Vendor employee) resource_id in the
4189: -- PV_PARTNER_ACCESSES table, IF the user is playing a role of
4190: -- 'CHANNEL_MANAGER' or 'CHANNEL_REP'
4191:
4192: IF (p_mode <> 'UPDATE') THEN
4193: IF (p_vad_partner_id IS NULL OR p_vad_partner_id = FND_API.g_miss_num) THEN

Line 4466: PV_Partner_Accesses_PVT.Create_Partner_Accesses(

4462: p_partner_id => l_partner_id
4463: ,p_resource_id => l_partner_access_rec.resource_id ) = 'N') THEN
4464:
4465:
4466: PV_Partner_Accesses_PVT.Create_Partner_Accesses(
4467: p_api_version_number => 1.0,
4468: p_init_msg_list => FND_API.G_FALSE,
4469: p_commit => FND_API.G_FALSE,
4470: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4482: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Create_Partner_Accesses');

4478: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4479: RAISE FND_API.G_EXC_ERROR;
4480: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4481: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
4482: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Create_Partner_Accesses');
4483: FND_MSG_PUB.Add;
4484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4485: END IF;
4486: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 4573: -- the PV_PARTNER_ACCESSES table.

4569: -- API name : Create_VAD_Channel_Team
4570: -- Type : Public
4571: -- Function : The purpose of this procedure is to create a Channel
4572: -- team of all VAD employees for a given VAD_Partner_id in
4573: -- the PV_PARTNER_ACCESSES table.
4574: --
4575: -- Pre-reqs : Existing resource should be a "Channel Manager" or
4576: -- "Channel Rep" role at group level.
4577: --

Line 4628: l_partner_access_rec PV_PARTNER_ACCESSES_PVT.partner_access_rec_type;

4624: l_vad_partner_id NUMBER;
4625: l_vad_party_id NUMBER;
4626: l_resource_id NUMBER;
4627: l_partner_access_id NUMBER;
4628: l_partner_access_rec PV_PARTNER_ACCESSES_PVT.partner_access_rec_type;
4629:
4630: -- Cursor l_party_id_csr to get the VAD Partner Org Id by supplying the
4631: -- VAD Partner id.
4632: CURSOR l_VAD_party_id_csr (cv_vad_partner_id NUMBER) IS

Line 4764: -- Create the resourse as a Channel Team member in PV_PARTNER_ACCESSES

4760:
4761: IF (check_resource_exist(l_partner_id, l_resource_id) = 'N')
4762: THEN
4763: l_resourse_cnt := l_resourse_cnt + 1;
4764: -- Create the resourse as a Channel Team member in PV_PARTNER_ACCESSES
4765: -- table by calling the PV_PARTNER_ACCESS_PVT.Create_Partner_Accesses
4766: -- procedure.
4767:
4768: -- set the resourse_id

Line 4772: PV_PARTNER_ACCESSES_PVT.Create_Partner_Accesses(

4768: -- set the resourse_id
4769: l_partner_access_rec.resource_id := l_resource_id;
4770:
4771: -- call the API
4772: PV_PARTNER_ACCESSES_PVT.Create_Partner_Accesses(
4773: p_api_version_number => 1.0,
4774: p_init_msg_list => FND_API.G_FALSE,
4775: p_commit => FND_API.G_FALSE,
4776: x_return_status => l_return_status,

Line 4788: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_PARTNER_ACCESSES_PVT.Create_Partner_Accesses');

4784: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4785: RAISE FND_API.G_EXC_ERROR;
4786: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4787: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
4788: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_PARTNER_ACCESSES_PVT.Create_Partner_Accesses');
4789: FND_MSG_PUB.Add;
4790: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4791: END IF;
4792: END IF;

Line 6086: -- partner_id from PV_PARTNER_ACCESSES table and re-assign the channel

6082: -- Function : The purpose of this procedure is to Update the Channel team for
6083: -- all those Partner's, who get affected by the change in territory
6084: -- definition. This procedure attached to 'Re-define Channel team for
6085: -- specific territories' concurrent request program. It reads all the
6086: -- partner_id from PV_PARTNER_ACCESSES table and re-assign the channel
6087: -- team.
6088: --
6089: -- Pre-reqs :
6090: --

Line 6192: FROM pv_partner_accesses ppa,

6188: cv_terr_id15 NUMBER, cv_terr_id16 NUMBER,
6189: cv_terr_id17 NUMBER, cv_terr_id18 NUMBER,
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