[Home] [Help]
1: PACKAGE BODY AMS_Iba_Pl_Sites_PVT as
2: /* $Header: amsvsitb.pls 120.0 2005/05/31 14:22:44 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
2: /* $Header: amsvsitb.pls 120.0 2005/05/31 14:22:44 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_Iba_Pl_Sites_PVT
7: -- Purpose
8: -- Private api created to insert/update/delete placement sites
9: -- History
10: -- 18-Apr-2001 sodixit Created
13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Iba_Pl_Sites_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvsitb.pls';
19:
20: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
343: -- Local Variables
344: l_object_version_number NUMBER;
345: l_SITE_ID NUMBER;
346: l_ref_iba_pl_sites_rec c_get_Iba_Pl_Sites%ROWTYPE ;
347: l_tar_iba_pl_sites_rec AMS_Iba_Pl_Sites_PVT.iba_pl_sites_rec_type := P_iba_pl_sites_rec;
348: l_rowid ROWID;
349: l_site_pages NUMBER;
350: l_siterefcode_changed VARCHAR2(1);
351: l_sitename_changed VARCHAR2(1);
1322:
1323: L_API_NAME CONSTANT VARCHAR2(30) := 'validate_iba_pl_sites';
1324: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1325: l_object_version_number NUMBER;
1326: l_iba_pl_sites_rec AMS_Iba_Pl_Sites_PVT.iba_pl_sites_rec_type;
1327:
1328: BEGIN
1329: -- Standard Start of API savepoint
1330: SAVEPOINT validate_iba_pl_sites_;
1479: p_data => x_msg_data
1480: );
1481: END validate_iba_pl_sites_rec;
1482:
1483: END AMS_Iba_Pl_Sites_PVT;