PACKAGE: APPS.AMS_BOM_PVT

Source

1 PACKAGE AMS_BOM_PVT AUTHID CURRENT_USER as
2 /* $Header: amsvboms.pls 115.10 2002/11/15 21:02:03 abhola ship $ */
3 -- Start of Comments
4 -- Package name     : AMS_BOM_PVT
5 -- Purpose          : Wrapper on BOM APIs
6 -- History          : Created Sept 25 2000   ABHOLA
7 -- NOTE             :
8 -- End of Comments
9 
10 -- Default number of records fetch per call
11 
12 
13     TYPE BOM_REC_TYPE IS RECORD
14      (     Inventory_Item_Id            NUMBER := FND_API.G_MISS_NUM
15          , Organization_Id              NUMBER := FND_API.G_MISS_NUM
16 	 , Alternate_Bom_Code		VARCHAR2(10)	:= FND_API.G_MISS_CHAR
17 	 , Assembly_Type		NUMBER		:= FND_API.G_MISS_NUM
18 	 , Transaction_Type		VARCHAR2(30)	:= FND_API.G_MISS_CHAR
19 	 , Return_Status		VARCHAR2(1)	:= FND_API.G_MISS_CHAR
20 	);
21 
22       G_MISS_BOM_REC_TYPE  BOM_REC_TYPE;
23 
24     TYPE BOM_COMP_REC_TYPE IS RECORD
25 	(  Start_Effective_Date		DATE		:= FND_API.G_MISS_DATE
26 	 , Disable_Date			DATE		:= FND_API.G_MISS_DATE
27 	 , Operation_Sequence_Number	NUMBER		:= FND_API.G_MISS_NUM
28 	 , Component_Item_Name		VARCHAR2(81)	:= FND_API.G_MISS_CHAR
29          , Component_Item_Id            NUMBER          := FND_API.G_MISS_NUM
30 	 , Item_Sequence_Number		NUMBER		:= FND_API.G_MISS_NUM
31 	 , Quantity_Per_Assembly	NUMBER		:= FND_API.G_MISS_NUM
32 	 , Quantity_Related		NUMBER      	:= FND_API.G_MISS_NUM
33 	 , Return_Status     		VARCHAR2(1)    	:= FND_API.G_MISS_CHAR
34     );
35 
36       G_MISS_BOM_COMP_REC_TYPE          BOM_COMP_REC_TYPE;
37 
38 --      TYPE  BOM_COMP_Tbl_Type      IS TABLE OF BOM_COMP_REC_TYPE
39 --                                                INDEX BY BINARY_INTEGER;
40 
41 --      G_MISS_BOM_COMP_Tbl_Type          BOM_COMP_Tbl_Type;
42 
43 PROCEDURE Ams_Process_BOM(
44     P_Api_Version_Number         IN   NUMBER,
45     P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
46     P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
47     p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
48 
49     X_Return_Status              OUT NOCOPY  VARCHAR2,
50     X_Msg_Count                  OUT NOCOPY  NUMBER,
51     X_Msg_Data                   OUT NOCOPY  VARCHAR2,
52 
53     P_bom_rec_type               IN   BOM_REC_TYPE := G_MISS_BOM_REC_TYPE,
54 
55     P_bom_comp_rec_type          IN    BOM_COMP_REC_TYPE := G_MISS_BOM_COMP_REC_TYPE,
56 
57     P_Last_Update_Date           IN    DATE    := FND_API.G_MISS_DATE,
58     P_Last_Update_By             IN    NUMBER  := FND_API.G_MISS_NUM
59     );
60 
61 End AMS_BOM_PVT;