[Home] [Help]
PACKAGE: APPS.GMF_ACTUAL_COST_ADJUSTMENT_PUB
Source
1 PACKAGE GMF_ACTUAL_COST_ADJUSTMENT_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMFPACAS.pls 120.3.12000000.1 2007/01/17 16:52:13 appldev ship $ */
3 /*#
4 * This is the Actual cost adjustment public user interface for costing
5 * It is used to create, update, delete the Actual cost adjustment related costs
6 * @rep:scope public
7 * @rep:product GMF
8 * @rep:displayname GMF Actual Cost Adjustment API
9 * @rep:lifecycle active
10 * @rep:category BUSINESS_ENTITY GMF_ITEM_COST
11 */
12 TYPE ADJUSTMENT_REC_TYPE IS RECORD
13 (
14 organization_id CM_ADJS_DTL.ORGANIZATION_ID%TYPE,
15 organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE,
16 inventory_item_id CM_ADJS_DTL.INVENTORY_ITEM_ID%TYPE,
17 item_number MTL_ITEM_FLEXFIELDS.ITEM_NUMBER%TYPE,
18 cost_type_id CM_ADJS_DTL.COST_TYPE_ID%TYPE,
19 cost_mthd_code CM_MTHD_MST.COST_MTHD_CODE%TYPE,
20 period_id CM_ADJS_DTL.PERIOD_ID%TYPE,
21 calendar_code CM_CLDR_HDR_B.CALENDAR_CODE%TYPE,
22 period_code CM_CLDR_DTL.PERIOD_CODE%TYPE,
23 cost_cmpntcls_id CM_ADJS_DTL.COST_CMPNTCLS_ID%TYPE,
24 cost_cmpntcls_code CM_CMPT_MST.COST_CMPNTCLS_CODE%TYPE,
25 cost_analysis_code CM_ADJS_DTL.COST_ANALYSIS_CODE%TYPE,
26 cost_adjust_id CM_ADJS_DTL.COST_ADJUST_ID%TYPE,
27 adjust_qty CM_ADJS_DTL.ADJUST_QTY%TYPE,
28 adjust_qty_uom CM_ADJS_DTL.ADJUST_QTY_UOM%TYPE,
29 adjust_cost CM_ADJS_DTL.ADJUST_COST%TYPE,
30 reason_code CM_ADJS_DTL.REASON_CODE%TYPE,
31 adjust_status CM_ADJS_DTL.ADJUST_STATUS%TYPE,
32 creation_date CM_ADJS_DTL.CREATION_DATE%TYPE,
33 last_update_login CM_ADJS_DTL.LAST_UPDATE_LOGIN%TYPE,
34 created_by CM_ADJS_DTL.CREATED_BY%TYPE,
35 last_update_date CM_ADJS_DTL.LAST_UPDATE_DATE%TYPE,
36 last_updated_by CM_ADJS_DTL.LAST_UPDATED_BY%TYPE,
37 text_code CM_ADJS_DTL.TEXT_CODE%TYPE,
38 trans_cnt CM_ADJS_DTL.TRANS_CNT%TYPE,
39 delete_mark CM_ADJS_DTL.DELETE_MARK%TYPE,
40 request_id CM_ADJS_DTL.REQUEST_ID%TYPE,
41 program_application_id CM_ADJS_DTL.PROGRAM_APPLICATION_ID%TYPE,
42 program_id CM_ADJS_DTL.PROGRAM_ID%TYPE,
43 program_update_date CM_ADJS_DTL.PROGRAM_UPDATE_DATE%TYPE,
44 attribute_category CM_ADJS_DTL.ATTRIBUTE_CATEGORY%TYPE,
45 attribute1 CM_ADJS_DTL.ATTRIBUTE1%TYPE,
46 attribute2 CM_ADJS_DTL.ATTRIBUTE2%TYPE,
47 attribute3 CM_ADJS_DTL.ATTRIBUTE3%TYPE,
48 attribute4 CM_ADJS_DTL.ATTRIBUTE4%TYPE,
49 attribute5 CM_ADJS_DTL.ATTRIBUTE5%TYPE,
50 attribute6 CM_ADJS_DTL.ATTRIBUTE6%TYPE,
51 attribute7 CM_ADJS_DTL.ATTRIBUTE7%TYPE,
52 attribute8 CM_ADJS_DTL.ATTRIBUTE8%TYPE,
53 attribute9 CM_ADJS_DTL.ATTRIBUTE9%TYPE,
54 attribute10 CM_ADJS_DTL.ATTRIBUTE10%TYPE,
55 attribute11 CM_ADJS_DTL.ATTRIBUTE11%TYPE,
56 attribute12 CM_ADJS_DTL.ATTRIBUTE12%TYPE,
57 attribute13 CM_ADJS_DTL.ATTRIBUTE13%TYPE,
58 attribute14 CM_ADJS_DTL.ATTRIBUTE14%TYPE,
59 attribute15 CM_ADJS_DTL.ATTRIBUTE15%TYPE,
60 attribute16 CM_ADJS_DTL.ATTRIBUTE16%TYPE,
61 attribute17 CM_ADJS_DTL.ATTRIBUTE17%TYPE,
62 attribute18 CM_ADJS_DTL.ATTRIBUTE18%TYPE,
63 attribute19 CM_ADJS_DTL.ATTRIBUTE19%TYPE,
64 attribute20 CM_ADJS_DTL.ATTRIBUTE20%TYPE,
65 attribute21 CM_ADJS_DTL.ATTRIBUTE21%TYPE,
66 attribute22 CM_ADJS_DTL.ATTRIBUTE22%TYPE,
67 attribute23 CM_ADJS_DTL.ATTRIBUTE23%TYPE,
68 attribute24 CM_ADJS_DTL.ATTRIBUTE24%TYPE,
69 attribute25 CM_ADJS_DTL.ATTRIBUTE25%TYPE,
70 attribute26 CM_ADJS_DTL.ATTRIBUTE26%TYPE,
71 attribute27 CM_ADJS_DTL.ATTRIBUTE27%TYPE,
72 attribute28 CM_ADJS_DTL.ATTRIBUTE28%TYPE,
73 attribute29 CM_ADJS_DTL.ATTRIBUTE29%TYPE,
74 attribute30 CM_ADJS_DTL.ATTRIBUTE30%TYPE,
75 adjustment_ind CM_ADJS_DTL.ADJUSTMENT_IND%TYPE,
76 subledger_ind CM_ADJS_DTL.SUBLEDGER_IND%TYPE,
77 adjustment_date CM_ADJS_DTL.ADJUSTMENT_DATE%TYPE,
78 user_name FND_USER.USER_NAME%TYPE
79 );
80
81 /*#
82 * This procedure validates the input parameters and invokes the private
83 * actual cost adjustment procedure for creating a actual cost adjustment.
84 * @param p_api_version indicates api version
85 * @param p_init_msg_list initial message list
86 * @param p_commit commit parameter
87 * @param x_return_status return status
88 * @param x_msg_count message count
89 * @param x_msg_data message data
90 * @param p_adjustment_rec actual cost adjustment record
91 * @rep:scope public
92 * @rep:lifecycle active
93 * @rep:displayname Create Actual Cost Adjustment API
94 */
95 PROCEDURE CREATE_ACTUAL_COST_ADJUSTMENT
96 (
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
99 p_commit IN VARCHAR2 := FND_API.G_FALSE,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_adjustment_rec IN OUT NOCOPY GMF_ACTUAL_COST_ADJUSTMENT_PUB.ADJUSTMENT_REC_TYPE
104 );
105
106 /*#
107 * Update Actaul cost adjustment
108 * This is a PL/SQL procedure for update_actual_cost_adjustment API
109 * This procedure validates the input parameters and invokes the private
110 * actual cost adjustment procedure for update actual cost adjustment.
111 * @param p_api_version indicates api version
112 * @param p_init_msg_list initial message list
113 * @param p_commit commit parameter
114 * @param x_return_status return status
115 * @param x_msg_count message count
116 * @param x_msg_data message data
117 * @param p_adjustment_rec actual cost adjustment record
118 * @rep:scope public
119 * @rep:lifecycle active
120 * @rep:displayname Update Actual Cost Adjustment API
121 */
122 PROCEDURE UPDATE_ACTUAL_COST_ADJUSTMENT
123 (
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126 p_commit IN VARCHAR2 := FND_API.G_FALSE,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_adjustment_rec IN OUT NOCOPY GMF_ACTUAL_COST_ADJUSTMENT_PUB.ADJUSTMENT_REC_TYPE
131 );
132 /*#
133 * Delete Actaul cost adjustment
134 * This is a PL/SQL procedure for delete_actual_cost_adjustment API
135 * This procedure validates the input parameters and invokes the private
136 * actual cost adjustment procedure for delete actual cost adjustment.
137 * @param p_api_version indicates api version
138 * @param p_init_msg_list initial message list
139 * @param p_commit commit parameter
140 * @param x_return_status return status
141 * @param x_msg_count message count
142 * @param x_msg_data message data
143 * @param p_adjustment_rec actual cost adjustment record
144 * @rep:scope public
145 * @rep:lifecycle active
146 * @rep:displayname Delete Actual Cost Adjustment API
147 */
148 PROCEDURE DELETE_ACTUAL_COST_ADJUSTMENT
149 (
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152 p_commit IN VARCHAR2 := FND_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_adjustment_rec IN OUT NOCOPY GMF_ACTUAL_COST_ADJUSTMENT_PUB.ADJUSTMENT_REC_TYPE
157 );
158 /*#
159 * Get the Actaul cost adjustment
160 * This is a PL/SQL procedure for get_actual_cost_adjustment API
161 * This procedure validates the input parameters and invokes the private
162 * actual cost adjustment procedure to get actual cost adjustment.
163 * @param p_api_version indicates api version
164 * @param p_init_msg_list initial message list
165 * @param x_return_status return status
166 * @param x_msg_count message count
167 * @param x_msg_data message data
168 * @param p_adjustment_rec actual cost adjustment record
169 * @rep:scope public
170 * @rep:lifecycle active
171 * @rep:displayname Get Actual Cost Adjustment API
172 */
173 PROCEDURE GET_ACTUAL_COST_ADJUSTMENT
174 (
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_adjustment_rec IN OUT NOCOPY GMF_ACTUAL_COST_ADJUSTMENT_PUB.ADJUSTMENT_REC_TYPE
181 );
182
183 END GMF_ACTUAL_COST_ADJUSTMENT_PUB ;