[Home] [Help]
Skip to content
PACKAGE: APPS.DPP_ITEMCOST_PVT
Source
1 PACKAGE DPP_ITEMCOST_PVT AUTHID CURRENT_USER AS
2 /* $Header: dppvcsts.pls 120.2.12010000.3 2009/08/25 14:52:48 rvkondur ship $ */
3
4 TYPE dpp_cst_hdr_rec_type IS RECORD
5 (
6 Transaction_Header_ID NUMBER,
7 Transaction_Number VARCHAR2(40),
8 Org_ID NUMBER,
9 Execution_Detail_ID NUMBER,
10 Provider_Process_Id VARCHAR2(240),
11 Provider_Process_Instance_id VARCHAR2(240),
12 Last_Updated_By NUMBER,
13 Cost_Adjustment_Account 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(240),
37 New_Price NUMBER,
38 Currency VARCHAR2(30),
39 UOM VARCHAR2(30),
40 price_change NUMBER,
41 Attribute_Category VARCHAR2(30),
42 Attribute1 VARCHAR2(150),
43 Attribute2 VARCHAR2(150),
44 Attribute3 VARCHAR2(150),
45 Attribute4 VARCHAR2(150),
46 Attribute5 VARCHAR2(150),
47 Attribute6 VARCHAR2(150),
48 Attribute7 VARCHAR2(150),
49 Attribute8 VARCHAR2(150),
50 Attribute9 VARCHAR2(150),
51 Attribute10 VARCHAR2(150),
52 Attribute11 VARCHAR2(150),
53 Attribute12 VARCHAR2(150),
54 Attribute13 VARCHAR2(150),
55 Attribute14 VARCHAR2(150),
56 Attribute15 VARCHAR2(150),
57 Update_Status VARCHAR2(30),
58 Reason_For_Failure VARCHAR2(240),
59 inv_org_details_tbl DPP_ITEMCOST_PVT.inv_org_details_tbl_type
60 );
61 G_dpp_txn_line_rec dpp_txn_line_rec_type;
62 TYPE dpp_txn_line_tbl_type IS TABLE OF dpp_txn_line_rec_type INDEX BY BINARY_INTEGER;
63 g_dpp_txn_line_tbl dpp_txn_line_tbl_type;
64
65 TYPE inv_org_details_rec_type IS RECORD
66 (
67 Inventory_Org_Name VARCHAR2(240),
68 Prior_Cost NUMBER
69 );
70
71 TYPE inv_org_details_tbl_type IS TABLE OF inv_org_details_rec_type INDEX BY BINARY_INTEGER;
72
73 ---------------------------------------------------------------------
74 -- PROCEDURE
75 -- Update_ItemCost
76 --
77 -- PURPOSE
78 -- Update item cost.
79 --
80 -- PARAMETERS
81 --
82 -- NOTES
83 -- 1.
84 -- 2.
85 ----------------------------------------------------------------------
86
87 PROCEDURE Update_ItemCost(
88 p_api_version IN NUMBER
89 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
90 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
91 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
92 ,x_return_status OUT NOCOPY VARCHAR2
93 ,x_msg_count OUT NOCOPY NUMBER
94 ,x_msg_data OUT NOCOPY VARCHAR2
95 ,p_txn_hdr_rec IN dpp_cst_hdr_rec_type
96 ,p_item_cost_tbl IN dpp_txn_line_tbl_type
97 );
98
99 END DPP_ITEMCOST_PVT;