[Home] [Help]
PACKAGE: APPS.CS_COST_DETAILS_PUB
Source
1 PACKAGE CS_COST_DETAILS_PUB AS
2 /* $Header: csxpcsts.pls 120.1 2008/01/18 07:01:59 bkanimoz noship $ */
3
4 --cost record structure
5
6 TYPE COST_REC_TYPE IS RECORD
7 (
8 cost_id NUMBER := FND_API.G_MISS_NUM ,
9 incident_id NUMBER := FND_API.G_MISS_NUM ,
10 estimate_Detail_id NUMBER := FND_API.G_MISS_NUM ,
11 charge_line_type VARCHAR(30) := FND_API.G_MISS_CHAR ,
12 transaction_type_id NUMBER := FND_API.G_MISS_NUM ,
13 txn_billing_type_id NUMBER := FND_API.G_MISS_NUM ,
14 inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
15 quantity NUMBER := FND_API.G_MISS_NUM ,
16 unit_of_measure_code VARCHAR2(3):= FND_API.G_MISS_CHAR ,
17 currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR ,
18 source_id NUMBER := FND_API.G_MISS_NUM ,
19 source_code VARCHAR2(10) := FND_API.G_MISS_CHAR ,
20 org_id NUMBER := FND_API.G_MISS_NUM ,
21 inventory_org_id NUMBER := FND_API.G_MISS_NUM ,
22 transaction_date DATE := FND_API.G_MISS_DATE ,
23 extended_cost NUMBER := FND_API.G_MISS_NUM ,
24 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
25 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
26 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
27 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
28 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
29 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
30 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
31 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
32 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
33 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
34 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
35 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
36 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
37 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR ,
38 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
39 ) ;
40
41
42 G_MISS_COST_REC Cost_Rec_Type ;
43
44 /*=========================================
45 Procedure Create_cost_details
46 ===========================================
47 */
48 -- Start of comments
49 -- API name : Create_Cost_Details
50 -- Type : Public
51 -- Function :
52 -- Pre-reqs : None.
53 -- Parameters :
54 --
55 -- IN : p_api_version: Standard Version of API Required
56 -- p_init_msg_list: Optional
57 -- p_commit: Indicates whether API should commit Optional
58 -- p_validation_level: Optional
59 -- p_resp_appl_id:
60 -- p_resp_id:
61 -- p_user_id:
62 -- p_login_id:
63 -- p_transaction_control:
64 -- p_cost_Rec: Cost_Rec_Type
65 -- Following passed using RECORD Cost_Rec_Type are required
66 -- or conditionally required.
67 -- incident_id: Required
68 -- Transaction_Type_Id: Required
69 -- Inventory_item_id: Required
70 -- Source_id: Required
71 -- Source_code: Required
72 -- (or)
73 -- Estimate_Detail_Id Required
74 -- If Estimate_Detail_Id is passed then, all the information
75 -- for costing will be taken from the Charges table and the Costing Private API is called with No validation
76 -- If estimate_Detail_id not passed ,then the costing private api is called with full validation by passing the values
77
78 -- OUT : x_return_status:
79 -- x_msg_count:
80 -- x_object_version_number:
81 -- x_msg_data:
82 -- x_estimate_detail_id:
83 -- x_line_number:
84 --
85 -- Version : Current version 12.1
86 -- Notes : This API is a public API to Create Cost Details
87 --
88 -- End of comments
89
90 /*#
91 * Create a cost line associated with a service request. This procedure creates one cost line
92 * at a time.
93 */
94
95 PROCEDURE Create_cost_details
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 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_object_version_number OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 x_cost_id OUT NOCOPY NUMBER,
106 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
107 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
108 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
109 p_login_id IN NUMBER := NULL,
110 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
111 p_Cost_Rec IN Cost_Rec_Type :=G_MISS_COST_REC
112
113 );
114
115 /*=========================================
116 Procedure Update_Cost_details
117 ===========================================
118 */
119
120 -- Start of comments
121 -- API name : Update_Cost_Details
122 -- Type : Public
123 -- Function :
124 -- Pre-reqs : None.
125
126
127 PROCEDURE Update_Cost_details
128 (
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
131 p_commit IN VARCHAR2 := FND_API.G_FALSE,
132 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_object_version_number OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_resp_appl_id IN NUMBER := FND_GLOBAL.RESP_APPL_ID,
138 p_resp_id IN NUMBER := FND_GLOBAL.RESP_ID,
139 p_user_id IN NUMBER := FND_GLOBAL.USER_ID,
140 p_login_id IN NUMBER := NULL,
141 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
142 p_Cost_Rec IN Cost_Rec_Type := G_MISS_COST_REC
143 ) ;
144
145 /*=========================================
146 Procedure Delete_Cost_details
147 ===========================================
148 */
149 -- Start of comments
150 -- API name : Delere_Cost_Details
151 -- Type : Public
152 -- Function :
153 -- Pre-reqs : None.
154
155 PROCEDURE Delete_Cost_details
156 (
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159 p_commit IN VARCHAR2 := FND_API.G_FALSE,
160 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
165 p_cost_id IN NUMBER := NULL
166 ) ;
167
168 /*=========================================
169 Procedure Log_Cost_Rec_Parameters
170 ===========================================
171 */
172 --This procedure is for logging the cost record parameters passed into the FND_LOG_MESSAGES table
173
174 PROCEDURE Log_Cost_Rec_Parameters
175 (
176 p_Cost_Rec_in IN Cost_Rec_Type
177 );
178
179 END CS_Cost_Details_PUB ;