[Home] [Help]
PACKAGE: APPS.QP_MODIFIERS_PVT
Source
1 PACKAGE QP_Modifiers_PVT AS
2 /* $Header: QPXVMLSS.pls 120.1 2005/06/15 00:27:08 appldev $ */
3
4 -- Start of Comments
5 -- API name Process_Modifiers
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_Modifiers
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_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
31 QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
32 , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
33 QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
34 , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
35 QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
36 , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
37 QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
38 , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
39 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
40 , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
41 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
42 , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
43 QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
44 , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
45 QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
46 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
47 , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
48 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
49 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
50 );
51
52 -- Start of Comments
53 -- API name Lock_Modifiers
54 -- Type Private
55 -- Function
56 --
57 -- Pre-reqs
58 --
59 -- Parameters
60 --
61 -- Version Current version = 1.0
62 -- Initial version = 1.0
63 --
64 -- Notes
65 --
66 -- End of Comments
67
68 PROCEDURE Lock_Modifiers
69 ( p_api_version_number IN NUMBER
70 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
71 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
73 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74 , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
75 QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
76 , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
77 QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
78 , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
79 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
80 , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
81 QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
82 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
83 , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
84 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
85 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
86 );
87
88 -- Start of Comments
89 -- API name Get_Modifiers
90 -- Type Private
91 -- Function
92 --
93 -- Pre-reqs
94 --
95 -- Parameters
96 --
97 -- Version Current version = 1.0
98 -- Initial version = 1.0
99 --
100 -- Notes
101 --
102 -- End of Comments
103
104 PROCEDURE Get_Modifiers
105 ( p_api_version_number IN NUMBER
106 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
107 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
109 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
110 , p_list_header_id IN NUMBER
111 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
112 , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
113 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
114 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
115 );
116
117 END QP_Modifiers_PVT;