[Home] [Help]
PACKAGE: APPS.QP_LIST_HEADERS_PVT
Source
1 PACKAGE QP_LIST_HEADERS_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPXVPRLS.pls 120.1 2005/06/15 03:51:33 appldev $ */
3
4 -- Start of Comments
5 -- API name Process_Price_List
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 -- Define Global Variables
21 G_MULTI_CURRENCY_INSTALLED VARCHAR2(5) := NVL(UPPER(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED')), 'N');
22
23 PROCEDURE Process_Price_List
24 ( p_api_version_number IN NUMBER
25 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
26 , p_commit IN VARCHAR2 := FND_API.G_FALSE
27 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
28 , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
29 QP_GLOBALS.G_MISS_CONTROL_REC
30 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
32 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
34 QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
35 , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
36 QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
37 , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
38 QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
39 , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
40 QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
41 , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
42 QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
43 , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
44 QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
45 , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
46 QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
47 , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
48 QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
49 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
50 , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
51 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
52 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
53 );
54
55 -- Start of Comments
56 -- API name Lock_Price_List
57 -- Type Private
58 -- Function
59 --
60 -- Pre-reqs
61 --
62 -- Parameters
63 --
64 -- Version Current version = 1.0
65 -- Initial version = 1.0
66 --
67 -- Notes
68 --
69 -- End of Comments
70
71 PROCEDURE Lock_Price_List
72 ( p_api_version_number IN NUMBER
73 , p_init_msg_list 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_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
80 QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
81 , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
82 QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
83 , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
84 QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
85 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
86 , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
87 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
88 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
89 );
90
91 -- Start of Comments
92 -- API name Get_Price_List
93 -- Type Private
94 -- Function
95 --
96 -- Pre-reqs
97 --
98 -- Parameters
99 --
100 -- Version Current version = 1.0
101 -- Initial version = 1.0
102 --
103 -- Notes
104 --
105 -- End of Comments
106
107 PROCEDURE Get_Price_List
108 ( p_api_version_number IN NUMBER
109 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
110 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
112 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113 , p_list_header_id IN NUMBER
114 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
115 , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
116 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
117 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
118 );
119
120 END QP_LIST_HEADERS_PVT;