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