[Home] [Help]
PACKAGE: APPS.QP_PRICE_FORMULA_PVT
Source
1 PACKAGE QP_Price_Formula_PVT AS
2 /* $Header: QPXVPRFS.pls 120.1 2005/06/15 03:44:55 appldev $ */
3
4 -- Start of Comments
5 -- API name Process_Price_Formula
6 -- Type Private
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 PROCEDURE Process_Price_Formula
21 ( p_api_version_number IN NUMBER
22 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23 , p_commit IN VARCHAR2 := FND_API.G_FALSE
24 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25 , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
26 QP_GLOBALS.G_MISS_CONTROL_REC
27 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
31 QP_Price_Formula_PUB.G_MISS_FORMULA_REC
32 , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
33 QP_Price_Formula_PUB.G_MISS_FORMULA_REC
34 , p_FORMULA_LINES_tbl IN QP_Price_Formula_PUB.Formula_Lines_Tbl_Type :=
35 QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_TBL
36 , p_old_FORMULA_LINES_tbl IN QP_Price_Formula_PUB.Formula_Lines_Tbl_Type :=
37 QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_TBL
38 , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
39 , x_FORMULA_LINES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Tbl_Type
40 );
41
42 -- Start of Comments
43 -- API name Lock_Price_Formula
44 -- Type Private
45 -- Function
46 --
47 -- Pre-reqs
48 --
49 -- Parameters
50 --
51 -- Version Current version = 1.0
52 -- Initial version = 1.0
53 --
54 -- Notes
55 --
56 -- End of Comments
57
58 PROCEDURE Lock_Price_Formula
59 ( p_api_version_number IN NUMBER
60 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
61 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
63 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
65 QP_Price_Formula_PUB.G_MISS_FORMULA_REC
66 , p_FORMULA_LINES_tbl IN QP_Price_Formula_PUB.Formula_Lines_Tbl_Type :=
67 QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_TBL
68 , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
69 , x_FORMULA_LINES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Tbl_Type
70 );
71
72 -- Start of Comments
73 -- API name Get_Price_Formula
74 -- Type Private
75 -- Function
76 --
77 -- Pre-reqs
78 --
79 -- Parameters
80 --
81 -- Version Current version = 1.0
82 -- Initial version = 1.0
83 --
84 -- Notes
85 --
86 -- End of Comments
87
88 PROCEDURE Get_Price_Formula
89 ( p_api_version_number IN NUMBER
90 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
91 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
93 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 , p_price_formula_id IN NUMBER
95 , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
96 , x_FORMULA_LINES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Tbl_Type
97 );
98
99 END QP_Price_Formula_PVT;