DBA Data[Home] [Help]

APPS.PV_PARTNER_PGM_TYPE_PVT dependencies on PV_PARTNER_PGM_TYPE_PVT

Line 1: PACKAGE BODY PV_PARTNER_PGM_TYPE_PVT as

1: PACKAGE BODY PV_PARTNER_PGM_TYPE_PVT as
2: /* $Header: pvxvpptb.pls 115.7 2003/03/05 23:28:11 pukken ship $*/
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_PARTNER_PGM_TYPE_PVT

2: /* $Header: pvxvpptb.pls 115.7 2003/03/05 23:28:11 pukken ship $*/
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_PARTNER_PGM_TYPE_PVT
7: -- Purpose
8: --
9: -- History
10: -- 22-APR-2002 Peter.Nixon Created

Line 28: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_PARTNER_PGM_TYPE_PVT';

24: -- End of Comments
25: -- ===============================================================
26:
27:
28: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_PARTNER_PGM_TYPE_PVT';
29: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvpptb.pls';
30:
31: /*** private routine declaration ***/
32: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

Line 320: l_tar_ptr_prgm_type_rec PV_PARTNER_PGM_TYPE_PVT.ptr_prgm_type_rec_type := p_ptr_prgm_type_rec;

316: l_api_version_number CONSTANT NUMBER := 1.0;
317:
318: -- Local Variables
319: l_ref_ptr_prgm_type_rec c_get_Partner_Pgm_Type%ROWTYPE ;
320: l_tar_ptr_prgm_type_rec PV_PARTNER_PGM_TYPE_PVT.ptr_prgm_type_rec_type := p_ptr_prgm_type_rec;
321:
322: BEGIN
323: ---------Initialize ------------------
324:

Line 533: l_tar_ptr_prgm_type_rec PV_PARTNER_PGM_TYPE_PVT.ptr_prgm_type_rec_type;

529: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Partner_Pgm_Type';
530: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
531: l_api_version_number CONSTANT NUMBER := 1.0;
532:
533: l_tar_ptr_prgm_type_rec PV_PARTNER_PGM_TYPE_PVT.ptr_prgm_type_rec_type;
534: l_ref_ptr_prgm_type_rec c_get_ptr_prgm_type_rec%ROWTYPE;
535: l_PROGRAM_TYPE_ID NUMBER;
536: l_return_status VARCHAR2(1);
537: l_msg_count NUMBER;

Line 642: -- Invoke table handler(PV_PARTNER_PGM_TYPE_PVT.Update_Partner_Pgm_Type)

638:
639: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update for soft delete');
640: END IF;
641:
642: -- Invoke table handler(PV_PARTNER_PGM_TYPE_PVT.Update_Partner_Pgm_Type)
643: PV_PARTNER_PGM_TYPE_PVT.Update_Partner_Pgm_Type(
644: p_api_version_number => l_api_version_number
645: ,p_init_msg_list => FND_API.g_false
646: ,p_commit => FND_API.g_false

Line 643: PV_PARTNER_PGM_TYPE_PVT.Update_Partner_Pgm_Type(

639: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update for soft delete');
640: END IF;
641:
642: -- Invoke table handler(PV_PARTNER_PGM_TYPE_PVT.Update_Partner_Pgm_Type)
643: PV_PARTNER_PGM_TYPE_PVT.Update_Partner_Pgm_Type(
644: p_api_version_number => l_api_version_number
645: ,p_init_msg_list => FND_API.g_false
646: ,p_commit => FND_API.g_false
647: ,p_validation_level => FND_API.g_valid_level_full

Line 1266: l_ptr_prgm_type_rec PV_Partner_Pgm_Type_PVT.ptr_prgm_type_rec_type;

1262: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Partner_Pgm_Type';
1263: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.'|| L_API_NAME;
1264: l_api_version_number CONSTANT NUMBER := 1.0;
1265: l_object_version_number NUMBER;
1266: l_ptr_prgm_type_rec PV_Partner_Pgm_Type_PVT.ptr_prgm_type_rec_type;
1267:
1268: BEGIN
1269: -- Standard Start of API savepoint
1270: SAVEPOINT VALIDATE_Partner_Pgm_Type_;

Line 1504: END PV_Partner_Pgm_Type_PVT;

1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1501: END Can_Be_Deleted;
1502:
1503:
1504: END PV_Partner_Pgm_Type_PVT;