[Home] [Help]
PACKAGE: APPS.DPP_PURCHASEPRICE_PVT
Source
1 PACKAGE DPP_PURCHASEPRICE_PVT AUTHID CURRENT_USER AS
2 /* $Header: dppvpops.pls 120.3.12010000.3 2009/08/25 14:56:23 rvkondur ship $ */
3
4 TYPE dpp_txn_hdr_rec_type IS RECORD
5 (
6 Transaction_Header_ID NUMBER,
7 Transaction_Number VARCHAR2(40),
8 Org_ID NUMBER,
9 Vendor_ID NUMBER,
10 Execution_Detail_ID NUMBER,
11 Provider_Process_Id VARCHAR2(240),
12 Provider_Process_Instance_id VARCHAR2(240),
13 Last_Updated_By NUMBER,
14 Attribute_Category VARCHAR2(30),
15 Attribute1 VARCHAR2(150),
16 Attribute2 VARCHAR2(150),
17 Attribute3 VARCHAR2(150),
18 Attribute4 VARCHAR2(150),
19 Attribute5 VARCHAR2(150),
20 Attribute6 VARCHAR2(150),
21 Attribute7 VARCHAR2(150),
22 Attribute8 VARCHAR2(150),
23 Attribute9 VARCHAR2(150),
24 Attribute10 VARCHAR2(150),
25 Attribute11 VARCHAR2(150),
26 Attribute12 VARCHAR2(150),
27 Attribute13 VARCHAR2(150),
28 Attribute14 VARCHAR2(150),
29 Attribute15 VARCHAR2(150)
30 );
31 g_miss_dpp_item_price_rec dpp_txn_hdr_rec_type;
32 TYPE dpp_item_price_tbl_type IS TABLE OF dpp_txn_hdr_rec_type INDEX BY BINARY_INTEGER;
33 g_miss_dpp_item_price_tbl dpp_item_price_tbl_type;
34
35 TYPE dpp_item_cost_rec_type IS RECORD
36 (
37 Transaction_Line_Id NUMBER,
38 Inventory_Item_Id NUMBER,
39 Item_Number VARCHAR2(240),
40 New_Price NUMBER,
41 Currency VARCHAR2(15),
42 UOM VARCHAR2(15),
43 po_line_tbl DPP_PURCHASEPRICE_PVT.dpp_po_line_tbl_type,
44 Attribute_Category VARCHAR2(30),
45 Attribute1 VARCHAR2(150),
46 Attribute2 VARCHAR2(150),
47 Attribute3 VARCHAR2(150),
48 Attribute4 VARCHAR2(150),
49 Attribute5 VARCHAR2(150),
50 Attribute6 VARCHAR2(150),
51 Attribute7 VARCHAR2(150),
52 Attribute8 VARCHAR2(150),
53 Attribute9 VARCHAR2(150),
54 Attribute10 VARCHAR2(150),
55 Attribute11 VARCHAR2(150),
56 Attribute12 VARCHAR2(150),
57 Attribute13 VARCHAR2(150),
58 Attribute14 VARCHAR2(150),
59 Attribute15 VARCHAR2(150),
60 Update_Status VARCHAR2(30)
61 );
62 G_MISS_DPP_ITEM_COST_REC dpp_item_cost_rec_type;
63 TYPE dpp_item_cost_tbl_type IS TABLE OF dpp_item_cost_rec_type INDEX BY BINARY_INTEGER;
64 g_miss_dpp_item_cost_tbl dpp_item_cost_tbl_type;
65
66
67 TYPE dpp_po_line_rec_type IS RECORD
68 (
69 Document_Number VARCHAR2(30),
70 Document_Type VARCHAR2(30),
71 Line_Number NUMBER,
72 Reason_for_failure VARCHAR2(150)
73 );
74 G_MISS_DPP_PO_LINE_REC dpp_po_line_rec_type;
75 TYPE dpp_po_line_tbl_type IS TABLE OF dpp_po_line_rec_type INDEX BY BINARY_INTEGER;
76 G_MISS_DPP_PO_LINE_TBL dpp_po_line_tbl_type;
77
78
79 TYPE dpp_po_notify_rec_type IS RECORD
80 (
81 Org_ID NUMBER,
82 Vendor_ID NUMBER,
83 Vendor_Site_ID NUMBER,
84 Vendor_Number VARCHAR2(40),
85 Vendor_Name VARCHAR2(240),
86 Vendor_Site_Code VARCHAR2(15),
87 Operating_Unit VARCHAR2(240)
88 );
89
90 g_dpp_po_notify_rec dpp_po_notify_rec_type;
91
92 TYPE dpp_po_details_rec_type IS RECORD
93 (
94 Document_Number VARCHAR2(150),
95 Document_Type VARCHAR2(20),
96 PO_Line_NUmber NUMBER,
97 Authorization_Status VARCHAR2(25)
98 );
99
100 g_dpp_po_details_rec dpp_po_details_rec_type;
101 TYPE dpp_po_details_tbl_type IS TABLE OF dpp_po_details_rec_type INDEX BY BINARY_INTEGER;
102 g_dpp_po_details_tbl dpp_po_details_tbl_type;
103
104 TYPE dpp_po_notify_item_rec_type IS RECORD
105 (
106 Inventory_Item_ID NUMBER,
107 Item_Number VARCHAR2(240),
108 New_Price NUMBER,
109 Currency VARCHAR2(15),
110 po_details_tbl DPP_PURCHASEPRICE_PVT.dpp_po_details_tbl_type
111 );
112
113 g_dpp_po_notify_item_rec dpp_po_notify_item_rec_type;
114 TYPE dpp_po_notify_item_tbl_type IS TABLE OF dpp_po_notify_item_rec_type INDEX BY BINARY_INTEGER;
115 g_dpp_po_notify_item_tbl dpp_po_notify_item_tbl_type;
116
117
118 ---------------------------------------------------------------------
119 -- PROCEDURE
120 -- Update_PurchasePrice
121 --
122 -- PURPOSE
123 -- Update purchase price.
124 --
125 -- PARAMETERS
126 --
127 -- NOTES
128 -- 1.
129 -- 2.
130 ----------------------------------------------------------------------
131
132 PROCEDURE Update_PurchasePrice(
133 p_api_version IN NUMBER
134 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
135 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
136 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
137 ,x_return_status OUT NOCOPY VARCHAR2
138 ,x_msg_count OUT NOCOPY NUMBER
139 ,x_msg_data OUT NOCOPY VARCHAR2
140 ,p_item_price_rec IN dpp_txn_hdr_rec_type
141 ,p_item_cost_tbl IN dpp_item_cost_tbl_type
142 );
143 ---------------------------------------------------------------------
144 -- PROCEDURE
145 -- Notify_PO
146 --
147 -- PURPOSE
148 -- Notify_Partial Receipts
149 --
150 -- PARAMETERS
151 --
152 -- NOTES
153 -- 1.
154 -- 2.
155 ----------------------------------------------------------------------
156
157 PROCEDURE Notify_PO(
158 p_api_version IN NUMBER
159 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
160 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
161 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162 ,x_return_status OUT NOCOPY VARCHAR2
163 ,x_msg_count OUT NOCOPY NUMBER
164 ,x_msg_data OUT NOCOPY VARCHAR2
165 ,p_po_notify_hdr_rec IN OUT NOCOPY dpp_po_notify_rec_type
166 ,p_po_notify_item_tbl IN OUT NOCOPY dpp_po_notify_item_tbl_type
167 );
168
169
170 END DPP_PURCHASEPRICE_PVT;
171