1: PACKAGE BODY AMS_ITEM_OWNER_PVT as
2: /* $Header: amsvinvb.pls 120.3 2006/05/03 05:40:42 inanaiah noship $ */
3: -- Start of Comments
4: -- Package name : AMS_ITEM_OWNER_PVT
5: -- Purpose :
1: PACKAGE BODY AMS_ITEM_OWNER_PVT as
2: /* $Header: amsvinvb.pls 120.3 2006/05/03 05:40:42 inanaiah noship $ */
3: -- Start of Comments
4: -- Package name : AMS_ITEM_OWNER_PVT
5: -- Purpose :
6:
7: -- History :
8: -- 10/06/2000 abhola created.
29: -- NOTE :
30: -- End of Comments
31:
32:
33: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_ITEM_OWNER_PVT';
34: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvinvb.pls';
35:
36: ------------------------------------------------------------------
37: -- Function
527: l_api_version_number CONSTANT NUMBER := 1.0;
528: -- Local Variables
529: l_object_version_number NUMBER;
530: l_ITEM_OWNER_ID NUMBER;
531: l_ref_ITEM_OWNER_rec AMS_item_owner_PVT.ITEM_OWNER_Rec_Type;
532: l_tar_ITEM_OWNER_rec AMS_item_owner_PVT.ITEM_OWNER_Rec_Type := P_ITEM_OWNER_Rec;
533: l_rowid ROWID;
534: l_inv_item_rec_in INV_Item_GRP.Item_Rec_Type ;
535: l_inv_item_rec_out INV_Item_GRP.Item_Rec_Type ;
528: -- Local Variables
529: l_object_version_number NUMBER;
530: l_ITEM_OWNER_ID NUMBER;
531: l_ref_ITEM_OWNER_rec AMS_item_owner_PVT.ITEM_OWNER_Rec_Type;
532: l_tar_ITEM_OWNER_rec AMS_item_owner_PVT.ITEM_OWNER_Rec_Type := P_ITEM_OWNER_Rec;
533: l_rowid ROWID;
534: l_inv_item_rec_in INV_Item_GRP.Item_Rec_Type ;
535: l_inv_item_rec_out INV_Item_GRP.Item_Rec_Type ;
536: l_error_tbl INV_Item_GRP.Error_tbl_Type ;
1162: IS
1163: l_api_name CONSTANT VARCHAR2(30) := 'Validate_item_owner';
1164: l_api_version_number CONSTANT NUMBER := 1.0;
1165: l_object_version_number NUMBER;
1166: l_ITEM_OWNER_rec AMS_item_owner_PVT.ITEM_OWNER_Rec_Type;
1167:
1168: BEGIN
1169: -- Standard Start of API savepoint
1170: SAVEPOINT VALIDATE_ITEM_OWNER_;
1990:
1991:
1992: END init_inv_item_rec;
1993:
1994: End AMS_ITEM_OWNER_PVT;