APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_CAT_ITEM_HRCHY

Line 343: FROM ben_tcs_cat_item_hrchy

339:
340: CURSOR c_item_hrchy_val(v_period_id IN NUMBER)
341: IS
342: SELECT row_in_cat_id , all_objects_in_cat_id
343: FROM ben_tcs_cat_item_hrchy
344: WHERE stmt_perd_id = v_period_id
345: AND lvl_num = 1;
346:
347: item_hrchy_val_rec c_item_hrchy_val%ROWTYPE;

Line 361: FROM ben_tcs_cat_item_hrchy item ,ben_tcs_cat_subcat_hrchy cat

357:
358: CURSOR c_row_cat_id( row_id IN NUMBER , v_period_id IN NUMBER)
359: IS
360: SELECT distinct nvl(item.stmt_perd_id,cat.stmt_perd_id )row_cat_id
361: FROM ben_tcs_cat_item_hrchy item ,ben_tcs_cat_subcat_hrchy cat
362: WHERE (item.row_in_cat_id =row_id
363: AND item.lvl_num =1
364: AND item.stmt_perd_id <> v_period_id )
365: OR( cat.row_in_cat_id =row_id

Line 372: FROM ben_tcs_cat_item_hrchy item

368:
369: CURSOR c_obj_cat_id( obj_id IN NUMBER , v_period_id IN NUMBER)
370: IS
371: SELECT all_objects_in_cat_id
372: FROM ben_tcs_cat_item_hrchy item
373: WHERE item.all_objects_in_cat_id =obj_id
374: AND item.lvl_num =1
375: AND item.stmt_perd_id <> v_period_id;
376:

Line 431: FROM ben_tcs_cat_item_hrchy

427: FETCH c_get_item
428: INTO item_id_found ;
429: IF ( c_get_item%FOUND) THEN
430: DELETE
431: FROM ben_tcs_cat_item_hrchy
432: WHERE item_id = item_hrchy_values(i).item_id
433: AND stmt_perd_id = item_hrchy_values(i).perd_id ;
434: END IF;
435: CLOSE c_get_item ;

Line 445: INSERT INTO ben_tcs_cat_item_hrchy

441: OPEN c_get_item (item_hrchy_values(i).item_id, item_hrchy_values(i).perd_id );
442: FETCH c_get_item
443: INTO item_id_found ;
444: IF ( c_get_item%FOUND) THEN
445: INSERT INTO ben_tcs_cat_item_hrchy
446: (stmt_id, cat_id,
447: item_id,
448: lvl_num ,cntr_cd, row_in_cat_id , all_objects_in_cat_id, stmt_perd_id
449: )

Line 594: FROM ben_tcs_cat_item_hrchy

590: CLOSE c_cat_hrchy_val;
591:
592: hr_utility.set_location('Deleting Item Hrchy for period' || l_rep_rec(i).PERIOD_ID ,63);
593: DELETE
594: FROM ben_tcs_cat_item_hrchy
595: WHERE stmt_perd_id = l_rep_rec(i).PERIOD_ID;
596:
597: hr_utility.set_location('Deleting Subcat Hrchy for period' || l_rep_rec(i).PERIOD_ID ,64);
598: DELETE

Line 654: DELETE FROM ben_tcs_cat_item_hrchy

650:
651: PROCEDURE delete_hrchy
652: IS
653: BEGIN
654: DELETE FROM ben_tcs_cat_item_hrchy
655: WHERE cat_id = -999 and lvl_num = -1;
656:
657: END delete_hrchy;
658:

Line 966: FROM ben_tcs_cat_item_hrchy

962: person_created_now VARCHAR(1) := 'N';
963:
964: CURSOR c_item (v_stmt_id IN NUMBER) IS
965: SELECT item_id,cntr_cd
966: FROM ben_tcs_cat_item_hrchy
967: WHERE cat_id = -999
968: AND stmt_id = v_stmt_id;
969:
970: item_id_process c_item%ROWTYPE;