1 PACKAGE GMD_FORMULA_EFFECTIVITY_PVT AUTHID CURRENT_USER AS
2 /* $Header: GMDVFMES.pls 120.0 2005/05/25 19:36:16 appldev noship $ */
3
4 /*
5 Start of commments
6 API name : Insert_FormulaEffectivity
7 Type : Private
8 Function :
9 Paramaters :
10 IN : p_api_version IN NUMBER Required
11 p_init_msg_list IN Varchar2 Optional
12 p_commit IN Varchar2 Optional
13 p_formula_effectivity_rec_type
14
15 OUT x_return_status OUT varchar2(1)
16 x_msg_count OUT Number
17 x_msg_data OUT varchar2(2000)
18
19 Version : Current Version 1.0
20
21 Notes :
22 End of comments
23 */
24
25 PROCEDURE Insert_FormulaEffectivity
26 ( p_api_version IN NUMBER ,
27 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
28 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
29 x_return_status OUT NOCOPY VARCHAR2 ,
30 x_msg_count OUT NOCOPY NUMBER ,
31 x_msg_data OUT NOCOPY VARCHAR2 ,
32 p_formula_effectivity_rec IN fm_form_eff%ROWTYPE
33 );
34
35 /*
36 Start of commments
37 API name : Update_FormulaEffectivity
38 Type : Private
39 Function :
40 Paramaters :
41 IN : p_api_version IN NUMBER Required
42 p_init_msg_list IN Varchar2 Optional
43 p_commit IN Varchar2 Optional
44 p_formula_effectivity_rec_type IN
45 p_delete_mark IN NUMBER Required
46
47 OUT x_return_status OUT varchar2(1)
48 x_msg_count OUT Number
49 x_msg_data OUT varchar2(2000)
50
51 Version : Current Version 1.0
52
53 Notes :
54
55 End of comments
56 */
57
58 PROCEDURE Update_FormulaEffectivity
59 ( p_api_version IN NUMBER ,
60 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
61 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
62 x_return_status OUT NOCOPY VARCHAR2 ,
63 x_msg_count OUT NOCOPY NUMBER ,
64 x_msg_data OUT NOCOPY VARCHAR2 ,
65 p_formula_effectivity_rec IN fm_form_eff%ROWTYPE
66 );
67
68
69 END GMD_FORMULA_EFFECTIVITY_PVT;