[Home] [Help]
PACKAGE: APPS.IEX_COSTS_PVT
Source
1 PACKAGE IEX_COSTS_PVT as
2 /* $Header: iexvcoss.pls 120.0 2004/01/24 03:25:08 appldev noship $ */
3 -- Start of Comments
4 -- Package name : IEX_COSTS_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:costs_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- COST_ID
19 -- CASE_ID
20 -- DELINQUENCY_ID
21 -- COST_TYPE_CODE
22 -- COST_ITEM_TYPE_CODE
23 -- COST_ITEM_TYPE_DESC
24 -- COST_ITEM_AMOUNT
25 -- COST_ITEM_CURRENCY_CODE
26 -- COST_ITEM_QTY
27 -- COST_ITEM_DATE
28 -- FUNCTIONAL_AMOUNT
29 -- EXCHANGE_TYPE
30 -- EXCHANGE_RATE
31 -- EXCHANGE_DATE
32 -- COST_ITEM_APPROVED
33 -- ACTIVE_FLAG
34 -- OBJECT_VERSION_NUMBER
35 -- CREATED_BY
36 -- CREATION_DATE
37 -- LAST_UPDATED_BY
38 -- LAST_UPDATE_DATE
39 -- REQUEST_ID
40 -- PROGRAM_APPLICATION_ID
41 -- PROGRAM_ID
42 -- PROGRAM_UPDATE_DATE
43 -- ATTRIBUTE_CATEGORY
44 -- ATTRIBUTE1
45 -- ATTRIBUTE2
46 -- ATTRIBUTE3
47 -- ATTRIBUTE4
48 -- ATTRIBUTE5
49 -- ATTRIBUTE6
50 -- ATTRIBUTE7
51 -- ATTRIBUTE8
52 -- ATTRIBUTE9
53 -- ATTRIBUTE10
54 -- ATTRIBUTE11
55 -- ATTRIBUTE12
56 -- ATTRIBUTE13
57 -- ATTRIBUTE14
58 -- ATTRIBUTE15
59 -- LAST_UPDATE_LOGIN
60 --
61 --
62 -- End of Comments
63
64 TYPE costs_Rec_Type IS RECORD
65 (
66 COST_ID NUMBER := FND_API.G_MISS_NUM,
67 CASE_ID NUMBER := FND_API.G_MISS_NUM,
68 DELINQUENCY_ID NUMBER := FND_API.G_MISS_NUM,
69 COST_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70 COST_ITEM_TYPE_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
71 COST_ITEM_TYPE_DESC VARCHAR2(240) := FND_API.G_MISS_CHAR,
72 COST_ITEM_AMOUNT NUMBER := FND_API.G_MISS_NUM,
73 COST_ITEM_CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
74 COST_ITEM_QTY NUMBER := FND_API.G_MISS_NUM,
75 COST_ITEM_DATE DATE := FND_API.G_MISS_DATE,
76 FUNCTIONAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
77 EXCHANGE_TYPE VARCHAR2(15) := FND_API.G_MISS_CHAR,
78 EXCHANGE_RATE NUMBER := FND_API.G_MISS_NUM,
79 EXCHANGE_DATE DATE := FND_API.G_MISS_DATE,
80 COST_ITEM_APPROVED VARCHAR2(240) := FND_API.G_MISS_CHAR,
81 ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
82 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
83 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
84 CREATION_DATE DATE := FND_API.G_MISS_DATE,
85 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
86 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
87 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
88 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
89 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
90 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91 ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
92 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
98 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
99 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
100 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
101 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
105 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
106 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
107 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
108 );
109
110 G_MISS_costs_REC costs_Rec_Type;
111 TYPE costs_Tbl_Type IS TABLE OF costs_Rec_Type
112 INDEX BY BINARY_INTEGER;
113 G_MISS_costs_TBL costs_Tbl_Type;
114
115 -- *******************************************************
116 -- Start of Comments
117 -- *******************************************************
118 -- API Name: Create_costs
119 -- Type : Private
120 -- Pre-Req :
121 -- Parameters:
122 -- IN
123 -- p_api_version_number IN NUMBER Required
124 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
125 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127 -- P_costs_Rec IN costs_Rec_Type Required
128 --
129 -- OUT:
130 -- x_return_status OUT NOCOPY VARCHAR2
131 -- x_msg_count OUT NOCOPY NUMBER
132 -- x_msg_data OUT NOCOPY VARCHAR2
133 -- End of Comments
134 --
135 PROCEDURE Create_costs(
136 P_Api_Version_Number IN NUMBER,
137 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
138 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
139 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140 P_costs_Rec IN costs_Rec_Type := G_MISS_costs_REC,
141 X_COST_ID OUT NOCOPY NUMBER,
142 X_Return_Status OUT NOCOPY VARCHAR2,
143 X_Msg_Count OUT NOCOPY NUMBER,
144 X_Msg_Data OUT NOCOPY VARCHAR2
145 );
146
147 -- *******************************************************
148 -- Start of Comments
149 -- *******************************************************
150 -- API Name: Update_costs
151 -- Type : Private
152 -- Pre-Req :
153 -- Parameters:
154 -- IN
155 -- p_api_version_number IN NUMBER Required
156 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
157 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
158 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
159 -- P_costs_Rec IN costs_Rec_Type Required
160 --
161 -- OUT:
162 -- x_return_status OUT NOCOPY VARCHAR2
163 -- x_msg_count OUT NOCOPY NUMBER
164 -- x_msg_data OUT NOCOPY VARCHAR2
165 -- Version : Current version 2.0
166 --
167 -- End of Comments
168 --
169 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
170 PROCEDURE Update_costs(
171 P_Api_Version_Number IN NUMBER,
172 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
173 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
174 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175 P_costs_Rec IN costs_Rec_Type,
176 X_Return_Status OUT NOCOPY VARCHAR2,
177 X_Msg_Count OUT NOCOPY NUMBER,
178 X_Msg_Data OUT NOCOPY VARCHAR2,
179 xo_object_version_number OUT NOCOPY NUMBER
180 );
181
182 -- *******************************************************
183 -- Start of Comments
184 -- *******************************************************
185 -- API Name: Delete_costs
186 -- Type : Private
187 -- Pre-Req :
188 -- Parameters:
189 -- IN
190 -- p_api_version_number IN NUMBER Required
191 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194 -- P_cost_ID IN NUMBER Required
195 --
196 -- OUT:
197 -- x_return_status OUT NOCOPY VARCHAR2
198 -- x_msg_count OUT NOCOPY NUMBER
199 -- x_msg_data OUT NOCOPY VARCHAR2
200 -- Version : Current version 2.0
201 -- End of Comments
202 --
203 PROCEDURE Delete_costs(
204 P_Api_Version_Number IN NUMBER,
205 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
206 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
207 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
208 P_cost_ID IN NUMBER,
209 X_Return_Status OUT NOCOPY VARCHAR2,
210 X_Msg_Count OUT NOCOPY NUMBER,
211 X_Msg_Data OUT NOCOPY VARCHAR2
212 );
213 End IEX_costs_PVT;