1 PACKAGE DPP_PRICING_PVT AS
2 /* $Header: dppvqpns.pls 120.1 2007/11/28 10:21:44 sdasan noship $ */
3 TYPE dpp_pl_notify_rec_type IS RECORD
4 (
5 PP_Transaction_No VARCHAR2(40),
6 Effectivity_Date DATE,
7 Org_ID NUMBER,
8 Vendor_ID NUMBER,
9 Vendor_Site_ID NUMBER,
10 Vendor_Number VARCHAR2(40),
11 Vendor_Name VARCHAR2(240),
12 Vendor_Site_Code VARCHAR2(15),
13 Operating_Unit VARCHAR2(240)
14 );
15
16 g_dpp_pl_notify_rec dpp_pl_notify_rec_type;
17
18 TYPE dpp_object_name_tbl_type IS TABLE OF QP_SECU_LIST_HEADERS_V.NAME%TYPE INDEX BY BINARY_INTEGER;
19
20 TYPE dpp_pl_notify_line_rec_type IS RECORD
21 (
22 Inventory_Item_ID NUMBER,
23 Item_Number VARCHAR2(40),
24 object_name_tbl DPP_PRICING_PVT.dpp_object_name_tbl_type,
25 New_Price NUMBER,
26 Currency_Code VARCHAR2(15)
27 );
28
29 g_dpp_pl_notify_line_rec dpp_pl_notify_line_rec_type;
30 TYPE dpp_pl_notify_line_tbl_type IS TABLE OF dpp_pl_notify_line_rec_type INDEX BY BINARY_INTEGER;
31 g_dpp_pl_notify_line_tbl dpp_pl_notify_line_tbl_type;
32
33 -- ==============================================================================
34 -- Start of Comments
35 -- ==============================================================================
36 -- API Name : Notify_OutboundPricelists
37 -- Type : Private
38 -- Pre-Req : None
39 -- Function : Derives outbound pricelists information for pricing notification
40 -- Parameters
41 --
42 -- IN
43 -- p_api_version_number IN NUMBER Required
44 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
45 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
46 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_NONE
47 -- p_pl_notify_line_tbl IN OUT dpp_pl_notify_line_tbl_type Required
48 --
49 -- OUT
50 -- x_return_status OUT VARCHAR2
51 -- x_msg_count OUT NUMBER
52 -- x_msg_data OUT VARCHAR2
53 -- Version : Current version 1.0
54 --
55 -- End of Comments
56 -- ==============================================================================
57
58
59 PROCEDURE Notify_OutboundPricelists(
60 p_api_version IN NUMBER
61 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
62 , p_commit IN VARCHAR2 := FND_API.G_FALSE
63 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE
64 , x_return_status OUT NOCOPY VARCHAR2
65 , x_msg_count OUT NOCOPY NUMBER
66 , x_msg_data OUT NOCOPY VARCHAR2
67 , p_pl_notify_hdr_rec IN OUT NOCOPY dpp_pl_notify_rec_type
68 , p_pl_notify_line_tbl IN OUT NOCOPY dpp_pl_notify_line_tbl_type
69 );
70 -- ==============================================================================
71 -- Start of Comments
72 -- ==============================================================================
73 -- API Name : Notify_InboundPricelists
74 -- Type : Private
75 -- Pre-Req : None
76 -- Function : Derives inbound pricelists information for pricing notification
77 -- Parameters
78 --
79 -- IN
80 -- p_api_version_number IN NUMBER Required
81 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
82 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
83 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_NONE
84 -- p_pl_notify_hdr_rec IN OUT dpp_pl_notify_rec_type Required
85 -- p_pl_notify_line_tbl IN OUT dpp_pl_notify_line_tbl_type Required
86 --
87 -- OUT
88 -- x_return_status OUT VARCHAR2
89 -- x_msg_count OUT NUMBER
90 -- x_msg_data OUT VARCHAR2
91 -- Version : Current version 1.0
92 --
93 -- End of Comments
94 -- ==============================================================================
95
96
97 PROCEDURE Notify_InboundPricelists(
98 p_api_version IN NUMBER
99 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
100 , p_commit IN VARCHAR2 := FND_API.G_FALSE
101 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE
102 , x_return_status OUT NOCOPY VARCHAR2
103 , x_msg_count OUT NOCOPY NUMBER
104 , x_msg_data OUT NOCOPY VARCHAR2
105 , p_pl_notify_hdr_rec IN OUT NOCOPY dpp_pl_notify_rec_type
106 , p_pl_notify_line_tbl IN OUT NOCOPY dpp_pl_notify_line_tbl_type
107 );
108
109 -- ==============================================================================
110 -- Start of Comments
111 -- ==============================================================================
112 -- API Name : Notify_Promotions
113 -- Type : Private
114 -- Pre-Req : None
115 -- Function : Derives information for promotions notification
116 -- Parameters
117 --
118 -- IN
119 -- p_api_version_number IN NUMBER Required
120 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
121 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
122 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_NONE
123 -- p_pl_notify_line_tbl IN OUT dpp_pl_notify_line_tbl_type Required
124 --
125 -- OUT
126 -- x_return_status OUT VARCHAR2
127 -- x_msg_count OUT NUMBER
128 -- x_msg_data OUT VARCHAR2
129 -- Version : Current version 1.0
130 --
131 -- End of Comments
132 -- ==============================================================================
133
134
135 PROCEDURE Notify_Promotions(
136 p_api_version IN NUMBER
137 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
138 , p_commit IN VARCHAR2 := FND_API.G_FALSE
139 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE
140 , x_return_status OUT NOCOPY VARCHAR2
141 , x_msg_count OUT NOCOPY NUMBER
142 , x_msg_data OUT NOCOPY VARCHAR2
143 , p_pl_notify_hdr_rec IN OUT NOCOPY dpp_pl_notify_rec_type
144 , p_pl_notify_line_tbl IN OUT NOCOPY dpp_pl_notify_line_tbl_type
145 );
146
147 END DPP_PRICING_PVT;