APPS.PV_TAP_ACCESS_TERRS_PVT dependencies on PV_TAP_ACCESS_TERRS

Line 1: PACKAGE BODY PV_TAP_ACCESS_TERRS_PVT as

1: PACKAGE BODY PV_TAP_ACCESS_TERRS_PVT as
2: /* $Header: pvxvtrab.pls 115.1 2003/10/17 09:52:51 rdsharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_TAP_ACCESS_TERRS_PVT

2: /* $Header: pvxvtrab.pls 115.1 2003/10/17 09:52:51 rdsharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_TAP_ACCESS_TERRS_PVT
7: -- Purpose
8: --
9: -- History
10: --

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_TAP_ACCESS_TERRS_PVT';

16: -- End of Comments
17: -- ===============================================================
18:
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_TAP_ACCESS_TERRS_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvtrab.pls';
22:
23: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
24: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 161: Pv_Tap_Access_Terrs_Pkg.Insert_Row(

157: PVX_Utility_PVT.debug_message( 'Private API: Calling create table handler');
158: END IF;
159:
160: -- Invoke table handler(Pv_Territory_Accesses_Pkg.Insert_Row)
161: Pv_Tap_Access_Terrs_Pkg.Insert_Row(
162: p_partner_access_id => p_tap_access_terrs_rec.partner_access_id,
163: p_terr_id => p_tap_access_terrs_rec.terr_id,
164: p_last_update_date => SYSDATE,
165: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 300: FROM PV_TAP_ACCESS_TERRS

296: IS
297:
298: CURSOR c_get_territory_accesses(cv_partner_access_id NUMBER,cv_terr_id NUMBER) IS
299: SELECT *
300: FROM PV_TAP_ACCESS_TERRS
301: WHERE partner_access_id = cv_partner_access_id
302: AND terr_id = cv_terr_id;
303:
304: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Tap_Access_Terrs';

Line 420: Pv_Tap_Access_Terrs_Pkg.Update_Row(

416: PVX_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
417: END IF;
418:
419: -- Invoke table handler(Pv_Territory_Accesses_Pkg.Update_Row)
420: Pv_Tap_Access_Terrs_Pkg.Update_Row(
421: p_partner_access_id => p_tap_access_terrs_rec.partner_access_id,
422: p_terr_id => p_tap_access_terrs_rec.terr_id,
423: p_last_update_date => SYSDATE,
424: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 601: Pv_Tap_Access_Terrs_Pkg.Delete_Row(

597: END IF;
598:
599: -- Invoke table handler(Pv_Territory_Accesses_Pkg.Delete_Row)
600:
601: Pv_Tap_Access_Terrs_Pkg.Delete_Row(
602: p_partner_access_id => p_partner_access_id,
603: p_terr_id => p_terr_id,
604: p_object_version_number => p_object_version_number ,
605: x_return_status => x_return_status );

Line 766: Pv_Tap_Access_Terrs_Pkg.Lock_Row(

762: -- Initialize API return status to SUCCESS
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764:
765: ------------------------ lock -------------------------
766: Pv_Tap_Access_Terrs_Pkg.Lock_Row(
767: p_partner_access_id,
768: p_terr_id,
769: p_object_version_number,
770: x_return_status);

Line 847: FROM PV_TAP_ACCESS_TERRS

843: l_valid_flag VARCHAR2(1):= 'N';
844: CURSOR l_Chk_Terr_Access_Uk_csr(cv_partner_access_id NUMBER,
845: cv_terr_id NUMBER ) IS
846: SELECT 'Y'
847: FROM PV_TAP_ACCESS_TERRS
848: WHERE partner_access_id = cv_partner_access_id
849: AND terr_id = cv_terr_id;
850:
851: BEGIN

Line 1008: FROM pv_tap_access_terrs

1004: l_return_status VARCHAR2(1);
1005:
1006: CURSOR c_complete IS
1007: SELECT *
1008: FROM pv_tap_access_terrs
1009: WHERE partner_access_id = p_tap_access_terrs_rec.partner_access_id
1010: AND terr_id = p_tap_access_terrs_rec.terr_id;
1011:
1012: l_tap_access_terrs_rec c_complete%ROWTYPE;

Line 1281: END PV_TAP_ACCESS_TERRS_PVT;

1277: p_data => x_msg_data
1278: );
1279: END Validate_Tap_Access_Terrs_Rec;
1280:
1281: END PV_TAP_ACCESS_TERRS_PVT;