[Home] [Help]
PACKAGE: APPS.OKL_RAS_PVT
Source
1 Package OKL_RAS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSRASS.pls 115.5 2002/12/20 00:06:43 gkadarka noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ras_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 ist_id NUMBER := OKC_API.G_MISS_NUM,
9 pac_id NUMBER := OKC_API.G_MISS_NUM,
10 art_id NUMBER := OKC_API.G_MISS_NUM,
11 object_version_number NUMBER := OKC_API.G_MISS_NUM,
12 date_shipping_instructions_sen OKL_RELOCATE_ASSETS_B.DATE_SHIPPING_INSTRUCTIONS_SEN%TYPE := OKC_API.G_MISS_DATE,
13 org_id NUMBER := OKC_API.G_MISS_NUM,
14 request_id NUMBER := OKC_API.G_MISS_NUM,
15 program_application_id NUMBER := OKC_API.G_MISS_NUM,
16 program_id NUMBER := OKC_API.G_MISS_NUM,
17 program_update_date OKL_RELOCATE_ASSETS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18 trans_option_accepted_yn OKL_RELOCATE_ASSETS_B.TRANS_OPTION_ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
19 insurance_amount NUMBER := OKC_API.G_MISS_NUM,
20 attribute_category OKL_RELOCATE_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
21 attribute1 OKL_RELOCATE_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
22 attribute2 OKL_RELOCATE_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
23 attribute3 OKL_RELOCATE_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24 attribute4 OKL_RELOCATE_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25 attribute5 OKL_RELOCATE_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26 attribute6 OKL_RELOCATE_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27 attribute7 OKL_RELOCATE_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28 attribute8 OKL_RELOCATE_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29 attribute9 OKL_RELOCATE_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30 attribute10 OKL_RELOCATE_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31 attribute11 OKL_RELOCATE_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32 attribute12 OKL_RELOCATE_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
33 attribute13 OKL_RELOCATE_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
34 attribute14 OKL_RELOCATE_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
35 attribute15 OKL_RELOCATE_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
36 created_by NUMBER := OKC_API.G_MISS_NUM,
37 creation_date OKL_RELOCATE_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
38 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
39 last_update_date OKL_RELOCATE_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
40 last_update_login NUMBER := OKC_API.G_MISS_NUM,
41 -- RABHUPAT - 2667636 - Start
42 currency_code OKL_RELOCATE_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
43 currency_conversion_code OKL_RELOCATE_ASSETS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
44 currency_conversion_type OKL_RELOCATE_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
45 currency_conversion_rate OKL_RELOCATE_ASSETS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
46 currency_conversion_date OKL_RELOCATE_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
47 --RABHUPAT - 2667636 - End
48 g_miss_ras_rec ras_rec_type;
49 TYPE ras_tbl_type IS TABLE OF ras_rec_type
50 INDEX BY BINARY_INTEGER;
51 TYPE OklRelocateAssetsTlRecType IS RECORD (
52 id NUMBER := OKC_API.G_MISS_NUM,
53 language OKL_RELOCATE_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
54 source_lang OKL_RELOCATE_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
55 sfwt_flag OKL_RELOCATE_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56 comments OKL_RELOCATE_ASSETS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
57 created_by NUMBER := OKC_API.G_MISS_NUM,
58 creation_date OKL_RELOCATE_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
59 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
60 last_update_date OKL_RELOCATE_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
61 last_update_login NUMBER := OKC_API.G_MISS_NUM);
62 GMissOklRelocateAssetsTlRec OklRelocateAssetsTlRecType;
63 TYPE OklRelocateAssetsTlTblType IS TABLE OF OklRelocateAssetsTlRecType
64 INDEX BY BINARY_INTEGER;
65 TYPE rasv_rec_type IS RECORD (
66 id NUMBER := OKC_API.G_MISS_NUM,
67 object_version_number NUMBER := OKC_API.G_MISS_NUM,
68 sfwt_flag OKL_RELOCATE_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
69 art_id NUMBER := OKC_API.G_MISS_NUM,
70 pac_id NUMBER := OKC_API.G_MISS_NUM,
71 ist_id NUMBER := OKC_API.G_MISS_NUM,
72 date_shipping_instructions_sen OKL_RELOCATE_ASSETS_V.DATE_SHIPPING_INSTRUCTIONS_SEN%TYPE := OKC_API.G_MISS_DATE,
73 comments OKL_RELOCATE_ASSETS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
74 trans_option_accepted_yn OKL_RELOCATE_ASSETS_V.TRANS_OPTION_ACCEPTED_YN%TYPE := OKC_API.G_MISS_CHAR,
75 insurance_amount NUMBER := OKC_API.G_MISS_NUM,
76 attribute_category OKL_RELOCATE_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
77 attribute1 OKL_RELOCATE_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
78 attribute2 OKL_RELOCATE_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
79 attribute3 OKL_RELOCATE_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
80 attribute4 OKL_RELOCATE_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
81 attribute5 OKL_RELOCATE_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
82 attribute6 OKL_RELOCATE_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
83 attribute7 OKL_RELOCATE_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
84 attribute8 OKL_RELOCATE_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
85 attribute9 OKL_RELOCATE_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
86 attribute10 OKL_RELOCATE_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
87 attribute11 OKL_RELOCATE_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
88 attribute12 OKL_RELOCATE_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
89 attribute13 OKL_RELOCATE_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
90 attribute14 OKL_RELOCATE_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
91 attribute15 OKL_RELOCATE_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
92 org_id NUMBER := OKC_API.G_MISS_NUM,
93 request_id NUMBER := OKC_API.G_MISS_NUM,
94 program_application_id NUMBER := OKC_API.G_MISS_NUM,
95 program_id NUMBER := OKC_API.G_MISS_NUM,
96 program_update_date OKL_RELOCATE_ASSETS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97 created_by NUMBER := OKC_API.G_MISS_NUM,
98 creation_date OKL_RELOCATE_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
99 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
100 last_update_login NUMBER := OKC_API.G_MISS_NUM,
101 last_update_date OKL_RELOCATE_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
102 -- RABHUPAT - 2667636 - Start
103 currency_code OKL_RELOCATE_ASSETS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
104 currency_conversion_code OKL_RELOCATE_ASSETS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
105 currency_conversion_type OKL_RELOCATE_ASSETS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
106 currency_conversion_rate OKL_RELOCATE_ASSETS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
107 currency_conversion_date OKL_RELOCATE_ASSETS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
108 -- RABHUPAT - 2667636 - End
109 g_miss_rasv_rec rasv_rec_type;
110 TYPE rasv_tbl_type IS TABLE OF rasv_rec_type
111 INDEX BY BINARY_INTEGER;
112 ---------------------------------------------------------------------------
113 -- GLOBAL MESSAGE CONSTANTS
114 ---------------------------------------------------------------------------
115 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
116 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
117 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
118 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
119 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
120 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
121 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
122 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
123 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
124 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
125 ---------------------------------------------------------------------------
126 -- GLOBAL VARIABLES
127 ---------------------------------------------------------------------------
128 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RAS_PVT';
129 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
130 ---------------------------------------------------------------------------
131 -- Procedures and Functions
132 ---------------------------------------------------------------------------
133
134 PROCEDURE qc;
135 PROCEDURE change_version;
136 PROCEDURE api_copy;
137 PROCEDURE add_language;
138 PROCEDURE insert_row(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_rasv_rec IN rasv_rec_type,
145 x_rasv_rec OUT NOCOPY rasv_rec_type);
146
147 PROCEDURE insert_row(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_rasv_tbl IN rasv_tbl_type,
154 x_rasv_tbl OUT NOCOPY rasv_tbl_type);
155
156 PROCEDURE lock_row(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_rasv_rec IN rasv_rec_type);
163
164 PROCEDURE lock_row(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_rasv_tbl IN rasv_tbl_type);
171
172 PROCEDURE update_row(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_rasv_rec IN rasv_rec_type,
179 x_rasv_rec OUT NOCOPY rasv_rec_type);
180
181 PROCEDURE update_row(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_rasv_tbl IN rasv_tbl_type,
188 x_rasv_tbl OUT NOCOPY rasv_tbl_type);
189
190 PROCEDURE delete_row(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_rasv_rec IN rasv_rec_type);
197
198 PROCEDURE delete_row(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_rasv_tbl IN rasv_tbl_type);
205
206 PROCEDURE validate_row(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_rasv_rec IN rasv_rec_type);
213
214 PROCEDURE validate_row(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_rasv_tbl IN rasv_tbl_type);
221
222 END OKL_RAS_PVT;