[Home] [Help]
PACKAGE: APPS.DPP_LISTPRICE_PVT
Source
1 PACKAGE DPP_LISTPRICE_PVT AS
2 /* $Header: dppvlprs.pls 120.2 2007/11/27 08:56:11 sdasan noship $ */
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
32 TYPE dpp_txn_line_rec_type IS RECORD
33 (
34 Transaction_Line_ID NUMBER,
35 Inventory_Item_Id NUMBER,
36 Item_Number VARCHAR2(40),
37 New_Price NUMBER,
38 Currency VARCHAR2(30),
39 UOM VARCHAR2(30),
40 Attribute_Category VARCHAR2(30),
41 Attribute1 VARCHAR2(150),
42 Attribute2 VARCHAR2(150),
43 Attribute3 VARCHAR2(150),
44 Attribute4 VARCHAR2(150),
45 Attribute5 VARCHAR2(150),
46 Attribute6 VARCHAR2(150),
47 Attribute7 VARCHAR2(150),
48 Attribute8 VARCHAR2(150),
49 Attribute9 VARCHAR2(150),
50 Attribute10 VARCHAR2(150),
51 Attribute11 VARCHAR2(150),
52 Attribute12 VARCHAR2(150),
53 Attribute13 VARCHAR2(150),
54 Attribute14 VARCHAR2(150),
55 Attribute15 VARCHAR2(150),
56 Update_Status VARCHAR2(30),
57 Reason_For_Failure VARCHAR2(240)
58 );
59 G_dpp_txn_line_rec dpp_txn_line_rec_type;
60 TYPE dpp_txn_line_tbl_type IS TABLE OF dpp_txn_line_rec_type INDEX BY BINARY_INTEGER;
61 g_dpp_txn_line_tbl dpp_txn_line_tbl_type;
62
63
64 ---------------------------------------------------------------------
65 -- PROCEDURE
66 -- Update_ItemCost
67 --
68 -- PURPOSE
69 -- Update item cost.
70 --
71 -- PARAMETERS
72 --
73 -- NOTES
74 -- 1.
75 -- 2.
76 ----------------------------------------------------------------------
77
78 PROCEDURE Update_ListPrice(
79 p_api_version IN NUMBER
80 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
81 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
82 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
83 ,x_return_status OUT NOCOPY VARCHAR2
84 ,x_msg_count OUT NOCOPY NUMBER
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 ,p_txn_hdr_rec IN dpp_txn_hdr_rec_type
87 ,p_item_cost_tbl IN dpp_txn_line_tbl_type
88 );
89
90 END DPP_LISTPRICE_PVT;