APPS.ZX_HR_LOCATIONS_REPORTING_HOOK dependencies on ZX_REPORTING_CODES_B

Line 40: FROM zx_reporting_codes_b

36: l_cnt_reporting_code := 0;
37:
38: SELECT count(reporting_code_char_value)
39: INTO l_cnt_reporting_code
40: FROM zx_reporting_codes_b
41: WHERE reporting_code_char_value = p_location_code;
42:
43: IF l_cnt_reporting_code = 0 THEN
44: SELECT reporting_type_id

Line 52: SELECT zx_reporting_codes_b_s.nextval

48:
49: IF l_reporting_type_id IS NOT NULL
50: THEN
51: FOR i in Nvl(l_reporting_type_id.first,1)..Nvl(l_reporting_type_id.last,0) LOOP
52: SELECT zx_reporting_codes_b_s.nextval
53: INTO l_reporting_code_id
54: FROM dual;
55:
56:

Line 189: FROM zx_reporting_codes_b

185: FOR k in Nvl(l_reporting_type_id.first,1)..Nvl(l_reporting_type_id.last,0) LOOP
186:
187: SELECT count(reporting_code_char_value)
188: INTO l_cnt_rep_codes
189: FROM zx_reporting_codes_b
190: WHERE reporting_code_char_value = p_location_code
191: AND reporting_type_id = l_reporting_type_id(k);
192:
193: IF l_cnt_rep_codes = 0 THEN

Line 204: SELECT zx_reporting_codes_b_s.nextval

200: AND reporting_type_id = l_reporting_type_id(k);
201:
202: IF l_cnt_assoc_rep_codes = 0 THEN
203: -- CASE 1 : Insert and delete
204: SELECT zx_reporting_codes_b_s.nextval
205: INTO l_reporting_code_id
206: FROM dual;
207:
208: ZX_REPORTING_CODES_PKG.INSERT_ROW (

Line 234: FROM zx_reporting_codes_b

230:
231: SELECT reporting_code_id
232: BULK COLLECT INTO
233: l_reporting_code_id_tbl
234: FROM zx_reporting_codes_b
235: WHERE reporting_code_char_value = p_location_code_o --NOTE
236: AND reporting_type_id = l_reporting_type_id(k);
237:
238: FORALL i IN 1..l_reporting_code_id_tbl.count

Line 243: DELETE FROM zx_reporting_codes_b

239: DELETE FROM zx_reporting_codes_tl
240: WHERE reporting_code_id = l_reporting_code_id_tbl(i);
241:
242: FORALL j IN 1..l_reporting_code_id_tbl.count
243: DELETE FROM zx_reporting_codes_b
244: WHERE reporting_code_id = l_reporting_code_id_tbl(j);
245: ELSE
246: -- CASE 2 : Raise an error
247: fnd_message.set_name('ZX', 'ZX_HR_KR_LOC_UPD_NOT_ALLOWED');

Line 264: FROM zx_reporting_codes_b

260: -- CASE 3 : Delete old reporting_code
261: SELECT reporting_code_id
262: BULK COLLECT INTO
263: l_reporting_code_id_tbl
264: FROM zx_reporting_codes_b
265: WHERE reporting_code_char_value = p_location_code_o
266: AND reporting_type_id = l_reporting_type_id(k);
267:
268: FORALL i IN 1..l_reporting_code_id_tbl.count

Line 273: DELETE FROM zx_reporting_codes_b

269: DELETE FROM zx_reporting_codes_tl
270: WHERE reporting_code_id = l_reporting_code_id_tbl(i);
271:
272: FORALL j IN 1..l_reporting_code_id_tbl.count
273: DELETE FROM zx_reporting_codes_b
274: WHERE reporting_code_id = l_reporting_code_id_tbl(j);
275: ELSE
276: -- CASE 4 : Raise an error
277: fnd_message.set_name('ZX', 'ZX_HR_KR_LOC_UPD_NOT_ALLOWED');

Line 329: FROM zx_reporting_codes_b

325: IF l_cnt_assoc_rep_codes = 0 THEN
326: SELECT reporting_code_id
327: BULK COLLECT INTO
328: l_reporting_code_id_tbl
329: FROM zx_reporting_codes_b
330: WHERE reporting_code_char_value = p_location_code_o;
331: IF l_reporting_code_id_tbl IS NOT NULL
332: THEN
333: FORALL i IN 1..l_reporting_code_id_tbl.count

Line 338: DELETE FROM zx_reporting_codes_b

334: DELETE FROM zx_reporting_codes_tl
335: WHERE reporting_code_id = l_reporting_code_id_tbl(i);
336:
337: FORALL j IN 1..l_reporting_code_id_tbl.count
338: DELETE FROM zx_reporting_codes_b
339: WHERE reporting_code_id = l_reporting_code_id_tbl(j);
340: ELSE
341: fnd_message.set_name('ZX', 'ZX_HR_KR_LOC_DEL_NOT_ALLOWED');
342: app_exception.raise_exception;