[Home] [Help]
PACKAGE: APPS.QP_PRICE_LIST_GRP
Source
1 PACKAGE QP_Price_List_GRP AUTHID CURRENT_USER AS
2 /* $Header: QPXGPRLS.pls 120.1 2005/06/10 01:45:24 appldev $ */
3
4 -- Start of Comments
5 -- API name Process_Price_List
6 -- Type Group
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_List
21 ( p_api_version_number IN NUMBER
22 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
24 , p_commit IN VARCHAR2 := FND_API.G_FALSE
25 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
27 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
29 QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
30 , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
31 QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
32 , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
33 QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
34 , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
35 QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
36 , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
37 QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
38 , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
39 QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
40 , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
41 QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
42 , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
43 QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
44 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
45 , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
46 , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
47 , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
48 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
49 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
50 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
51 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
52 );
53
54 -- Start of Comments
55 -- API name Lock_Price_List
56 -- Type Public
57 -- Function
58 --
59 -- Pre-reqs
60 --
61 -- Parameters
62 --
63 -- Version Current version = 1.0
64 -- Initial version = 1.0
65 --
66 -- Notes
67 --
68 -- End of Comments
69
70 PROCEDURE Lock_Price_List
71 ( p_api_version_number IN NUMBER
72 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
73 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
74 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
76 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
78 QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
79 , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
80 QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
81 , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
82 QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
83 , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
84 QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
85 , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
86 QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
87 , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
88 QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
89 , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
90 QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
91 , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
92 QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
93 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
94 , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
95 , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
96 , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
97 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
98 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
99 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
100 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
101 );
102
103 -- Start of Comments
104 -- API name Get_Price_List
105 -- Type Public
106 -- Function
107 --
108 -- Pre-reqs
109 --
110 -- Parameters
111 --
112 -- Version Current version = 1.0
113 -- Initial version = 1.0
114 --
115 -- Notes
116 --
117 -- End of Comments
118
119 PROCEDURE Get_Price_List
120 ( p_api_version_number IN NUMBER
121 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
122 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
123 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
125 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126 , p_list_header_id IN NUMBER :=
127 FND_API.G_MISS_NUM
128 , p_list_header IN VARCHAR2 :=
129 FND_API.G_MISS_CHAR
130 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
131 , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
132 , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
133 , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
134 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
135 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
136 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
137 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
138 );
139
140 END QP_Price_List_GRP;