1: PACKAGE BODY AMS_REL_ITEM_PVT as
2: /* $Header: amsvritb.pls 115.11 2002/11/14 00:56:47 abhola ship $ */
3: -- Start of Comments
4: -- Package name : AMS_REL_ITEM_PVT
5: -- Purpose :
1: PACKAGE BODY AMS_REL_ITEM_PVT as
2: /* $Header: amsvritb.pls 115.11 2002/11/14 00:56:47 abhola ship $ */
3: -- Start of Comments
4: -- Package name : AMS_REL_ITEM_PVT
5: -- Purpose :
6: -- History :
7: -- 08-FEB-2001 abhola created
8: -- 17-MAY-2002 abhola removed references to g_user_id
9: -- NOTE :
10: -- End of Comments
11:
12:
13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_REL_ITEM_PVT';
14: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvritb.pls';
15:
16:
17:
338: l_api_version_number CONSTANT NUMBER := 1.0;
339: -- Local Variables
340: l_object_version_number NUMBER;
341: l_RELATED_ITEM_ID NUMBER;
342: l_ref_REL_ITEM_rec AMS_rel_item_PVT.REL_ITEM_Rec_Type;
343: l_tar_REL_ITEM_rec AMS_rel_item_PVT.REL_ITEM_Rec_Type := P_REL_ITEM_Rec;
344: l_rowid ROWID;
345:
346: BEGIN
339: -- Local Variables
340: l_object_version_number NUMBER;
341: l_RELATED_ITEM_ID NUMBER;
342: l_ref_REL_ITEM_rec AMS_rel_item_PVT.REL_ITEM_Rec_Type;
343: l_tar_REL_ITEM_rec AMS_rel_item_PVT.REL_ITEM_Rec_Type := P_REL_ITEM_Rec;
344: l_rowid ROWID;
345:
346: BEGIN
347: -- Standard Start of API savepoint
818: IS
819: l_api_name CONSTANT VARCHAR2(30) := 'Validate_rel_item';
820: l_api_version_number CONSTANT NUMBER := 1.0;
821: l_object_version_number NUMBER;
822: l_REL_ITEM_rec AMS_rel_item_PVT.REL_ITEM_Rec_Type;
823:
824: BEGIN
825: -- Standard Start of API savepoint
826: SAVEPOINT VALIDATE_REL_ITEM_;
957: p_data => x_msg_data
958: );
959: END Validate_REL_ITEM_Rec;
960:
961: End AMS_REL_ITEM_PVT;