1 PACKAGE GMD_FORMULA_DETAIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: GMDVFMDS.pls 115.8 2002/10/24 20:58:34 santunes noship $ */
3
4 -- Start of commments
5 -- API name : Insert_FormulaDetail
6 -- Type : Private
7 -- Function :
8 -- Paramaters :
9 -- IN : p_api_version IN NUMBER Required
10 -- p_init_msg_list IN Varchar2 Optional
11 -- p_commit IN Varchar2 Optional
12 -- p_formula_detail_rec_type Required
13 --
14 -- OUT x_return_status OUT varchar2(1)
15 -- x_msg_count OUT Number
16 -- x_msg_data OUT varchar2(2000)
17 --
18 -- Version : Current Version 1.0
19 --
20 -- Notes :
21 -- End of comments
22
23 PROCEDURE Insert_FormulaDetail
24 ( p_api_version IN NUMBER ,
25 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
26 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
27 x_return_status OUT NOCOPY VARCHAR2 ,
28 x_msg_count OUT NOCOPY NUMBER ,
29 x_msg_data OUT NOCOPY VARCHAR2 ,
30 p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
31 );
32
33
34 -- Start of commments
35 -- API name : Update_FormulaDetail
36 -- Type : Private
37 -- Function :
38 -- Paramaters :
39 -- IN : p_api_version IN NUMBER Required
40 -- p_init_msg_list IN Varchar2 Optional
41 -- p_commit IN Varchar2 Optional
42 -- p_formula_detail_rec_type IN formula_header_rec_type Required
43 --
44 -- OUT x_return_status OUT varchar2(1)
45 -- x_msg_count OUT Number
46 -- x_msg_data OUT varchar2(2000)
47 --
48 -- Version : Current Version 1.0
49 --
50 -- Notes :
51 --
52 -- End of comments
53
54 PROCEDURE Update_FormulaDetail
55 ( p_api_version IN NUMBER ,
56 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
57 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
58 x_return_status OUT NOCOPY VARCHAR2 ,
59 x_msg_count OUT NOCOPY NUMBER ,
60 x_msg_data OUT NOCOPY VARCHAR2 ,
61 p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
62 );
63
64
65 -- Start of commments
66 -- API name : Delete_FormulaDetail
67 -- Type : Private
68 -- Function :
69 -- Paramaters :
70 -- IN : p_api_version IN NUMBER Required
71 -- p_init_msg_list IN Varchar2 Optional
72 -- p_commit IN Varchar2 Optional
73 -- p_formula_detail_rec_type IN formula_header_rec_type Required
74 --
75 -- OUT x_return_status OUT varchar2(1)
76 -- x_msg_count OUT Number
77 -- x_msg_data OUT varchar2(2000)
78 --
79 -- Version : Current Version 1.0
80 --
81 -- Notes :
82 --
83 -- End of comments
84
85 PROCEDURE Delete_FormulaDetail
86 ( p_api_version IN NUMBER ,
87 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
88 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
89 x_return_status OUT NOCOPY VARCHAR2 ,
90 x_msg_count OUT NOCOPY NUMBER ,
91 x_msg_data OUT NOCOPY VARCHAR2 ,
92 p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
93 );
94
95
96 END GMD_FORMULA_DETAIL_PVT;