1 PACKAGE GMF_LotCostAdjustment_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMFPLCAS.pls 120.4.12000000.1 2007/01/17 16:52:36 appldev ship $ */
3 /*#
4 * This is the public API for OPM Lot cost adjustments
5 * This API can be used to create, update and delete
6 * @rep:scope public
7 * @rep:product GMF
8 * @rep:displayname GMF Lot Cost Adjustment API
9 * @rep:lifecycle active
10 * @rep:category BUSINESS_ENTITY GMF_ITEM_COST
11 */
12
13 TYPE Lc_Adjustment_Header_Rec_Type
14 IS
15 RECORD
16 (
17 adjustment_id gmf_lot_cost_adjustments.adjustment_id%TYPE
18 , legal_entity_id gmf_fiscal_policies.legal_entity_id%TYPE
19 , cost_type_id cm_mthd_mst.cost_type_id%TYPE
20 , cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE
21 , item_id mtl_item_flexfields.inventory_item_id%TYPE
22 , item_number mtl_item_flexfields.item_number%TYPE
23 , organization_id mtl_parameters.organization_id%TYPE
24 , organization_code mtl_parameters.organization_code%TYPE
25 , lot_number mtl_lot_numbers.lot_number%TYPE
26 , adjustment_date DATE
27 , reason_code cm_reas_cds.reason_code%TYPE
28 , delete_mark gmf_lot_cost_adjustments.delete_mark%TYPE
29 , ATTRIBUTE1 VARCHAR2(240)
30 , ATTRIBUTE2 VARCHAR2(240)
31 , ATTRIBUTE3 VARCHAR2(240)
32 , ATTRIBUTE4 VARCHAR2(240)
33 , ATTRIBUTE5 VARCHAR2(240)
34 , ATTRIBUTE6 VARCHAR2(240)
35 , ATTRIBUTE7 VARCHAR2(240)
36 , ATTRIBUTE8 VARCHAR2(240)
37 , ATTRIBUTE9 VARCHAR2(240)
38 , ATTRIBUTE10 VARCHAR2(240)
39 , ATTRIBUTE11 VARCHAR2(240)
40 , ATTRIBUTE12 VARCHAR2(240)
41 , ATTRIBUTE13 VARCHAR2(240)
42 , ATTRIBUTE14 VARCHAR2(240)
43 , ATTRIBUTE15 VARCHAR2(240)
44 , ATTRIBUTE16 VARCHAR2(240)
45 , ATTRIBUTE17 VARCHAR2(240)
46 , ATTRIBUTE18 VARCHAR2(240)
47 , ATTRIBUTE19 VARCHAR2(240)
48 , ATTRIBUTE20 VARCHAR2(240)
49 , ATTRIBUTE21 VARCHAR2(240)
50 , ATTRIBUTE22 VARCHAR2(240)
51 , ATTRIBUTE23 VARCHAR2(240)
52 , ATTRIBUTE24 VARCHAR2(240)
53 , ATTRIBUTE25 VARCHAR2(240)
54 , ATTRIBUTE26 VARCHAR2(240)
55 , ATTRIBUTE27 VARCHAR2(240)
56 , ATTRIBUTE28 VARCHAR2(240)
57 , ATTRIBUTE29 VARCHAR2(240)
58 , ATTRIBUTE30 VARCHAR2(240)
59 , ATTRIBUTE_CATEGORY VARCHAR2(30)
60 , user_name fnd_user.user_name%TYPE
61 );
62
63 TYPE lc_adjustment_dtls_Rec_Type
64 IS
65 RECORD
66 (
67 adjustment_dtl_id gmf_lot_cost_adjustment_dtls.adjustment_dtl_id%TYPE
68 , adjustment_id gmf_lot_cost_adjustment_dtls.adjustment_id%TYPE
69 , cost_cmpntcls_id cm_cmpt_mst.cost_cmpntcls_id%TYPE
70 , cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE
71 , cost_analysis_code cm_alys_mst.cost_analysis_code%TYPE
72 , adjustment_cost gmf_lot_cost_adjustment_dtls.adjustment_cost%TYPE
73 , TEXT_CODE NUMBER(22)
74 );
75
76 TYPE lc_adjustment_dtls_Tbl_Type
77 IS
78 TABLE OF lc_adjustment_dtls_Rec_Type
79 INDEX BY BINARY_INTEGER;
80
81 /*#
82 * Lot cost adjustment Creation API
83 * This API Creates a Lot cost adjustments in lot cost adjustment Basis Table
84 * @param p_api_version Version Number of the API
85 * @param p_init_msg_list Flag for initializing message list
86 * @param p_commit Flag for commiting the data or not
87 * @param x_return_status Return status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
88 * @param x_msg_count Number of messages on message stack
89 * @param x_msg_data Actual message data from message stack
90 * @param p_header_rec Adjustment header record
91 * @param p_dtl_Tbl Adjustment details record
92 * @rep:scope public
93 * @rep:lifecycle active
94 * @rep:displayname Create Lot Cost Adjustment API
95 */
96 PROCEDURE Create_LotCost_Adjustment
97 (
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 , x_return_status OUT NOCOPY VARCHAR2
102 , x_msg_count OUT NOCOPY NUMBER
103 , x_msg_data OUT NOCOPY VARCHAR2
104 , p_header_rec IN OUT NOCOPY Lc_Adjustment_Header_Rec_Type
105 , p_dtl_Tbl IN OUT NOCOPY Lc_adjustment_dtls_Tbl_Type
106 );
107
108 /*#
109 * Lot cost adjustment Update API
110 * This API updates a Lot cost adjustments in lot cost adjustment Basis Table
111 * @param p_api_version Version Number of the API
112 * @param p_init_msg_list Flag for initializing message list
113 * @param p_commit Flag for commiting the data or not
114 * @param x_return_status Return status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
115 * @param x_msg_count Number of messages on message stack
116 * @param x_msg_data Actual message data from message stack
117 * @param p_header_rec Adjustment header record
118 * @param p_dtl_Tbl Adjustment details record
119 * @rep:scope public
120 * @rep:lifecycle active
121 * @rep:displayname Update Lot Cost Adjustment API
122 */
123 PROCEDURE Update_LotCost_Adjustment
124 (
125 p_api_version IN NUMBER
126 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
127 , p_commit IN VARCHAR2 := FND_API.G_FALSE
128 , x_return_status OUT NOCOPY VARCHAR2
129 , x_msg_count OUT NOCOPY NUMBER
130 , x_msg_data OUT NOCOPY VARCHAR2
131 , p_header_rec IN OUT NOCOPY Lc_Adjustment_Header_Rec_Type
132 , p_dtl_Tbl IN OUT NOCOPY lc_adjustment_dtls_Tbl_Type
133 );
134
135 /*#
136 * Lot cost adjustment API for delete
137 * This API deletes Lot cost adjustments from lot cost adjustment Basis Table
138 * @param p_api_version Version Number of the API
139 * @param p_init_msg_list Flag for initializing message list
140 * @param p_commit Flag for commiting the data or not
141 * @param x_return_status Return status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
142 * @param x_msg_count Number of messages on message stack
143 * @param x_msg_data Actual message data from message stack
144 * @param p_header_rec Adjustment header record
145 * @param p_dtl_Tbl Adjustment details record
146 * @rep:scope public
147 * @rep:lifecycle active
148 * @rep:displayname Delete Lot Cost Adjustment API
149 */
150 PROCEDURE Delete_LotCost_Adjustment
151 (
152 p_api_version IN NUMBER
153 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
154 , p_commit IN VARCHAR2 := FND_API.G_FALSE
155 , x_return_status OUT NOCOPY VARCHAR2
156 , x_msg_count OUT NOCOPY NUMBER
157 , x_msg_data OUT NOCOPY VARCHAR2
158 , p_header_rec IN OUT NOCOPY Lc_Adjustment_Header_Rec_Type
159 , p_dtl_Tbl IN OUT NOCOPY lc_adjustment_dtls_Tbl_Type
160 );
161
162 /*#
163 * Get Lot cost adjustment API
164 * This API get the Lot cost adjustment details
165 * @param p_api_version Version Number of the API
166 * @param p_init_msg_list Flag for initializing message list
167 * @param x_return_status Return status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
168 * @param x_msg_count Number of messages on message stack
169 * @param x_msg_data Actual message data from message stack
170 * @param p_header_rec Adjustment header record
171 * @param p_dtl_Tbl Adjustment details record
172 * @rep:scope public
173 * @rep:lifecycle active
174 * @rep:displayname Get Lot Cost Adjustment API
175 */
176 PROCEDURE Get_LotCost_Adjustment
177 (
178 p_api_version IN NUMBER
179 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
180 , x_return_status OUT NOCOPY VARCHAR2
181 , x_msg_count OUT NOCOPY NUMBER
182 , x_msg_data OUT NOCOPY VARCHAR2
183 , p_header_rec IN OUT NOCOPY Lc_Adjustment_Header_Rec_Type
184 , p_dtl_Tbl OUT NOCOPY lc_adjustment_dtls_Tbl_Type
185 );
186
187 END GMF_LotCostAdjustment_PUB ;