APPS.BEN_TCS_STMT_VALID_HRCHY dependencies on BEN_TCS_CAT_ITEM_HRCHY

Line 64: FROM ben_tcs_cat_item_hrchy cat_item_hr

60:
61: CURSOR c_item_hrchy (v_cat_id IN NUMBER, v_stmt_id NUMBER, v_period_id NUMBER)
62: IS
63: SELECT item_id, lvl_num,cntr_cd,row_in_cat_id ,all_objects_in_cat_id
64: FROM ben_tcs_cat_item_hrchy cat_item_hr
65: WHERE cat_item_hr.cat_id = v_cat_id
66: AND cat_item_hr.stmt_id = v_stmt_id
67: AND cat_item_hr.stmt_perd_id = v_period_id ;
68:

Line 131: DELETE FROM ben_tcs_cat_item_hrchy

127:
128: WHILE (l_counter <= l_number_of_rows)
129: LOOP
130: l_cur_cat_id := stmt_obj_hrchy (l_counter);
131: DELETE FROM ben_tcs_cat_item_hrchy
132: WHERE cat_id = stmt_obj_hrchy (l_counter)
133: and stmt_id = p_stmt_id
134: and stmt_perd_id = p_period_id;
135: DELETE FROM ben_tcs_cat_subcat_hrchy

Line 185: INSERT INTO ben_tcs_cat_item_hrchy

181: item_hrchy_values(item_count +1 ).row_cat_id :=cat_item_rec.row_id;
182: item_hrchy_values(item_count +1 ).all_objects_id := cat_item_rec.obj_id;
183: item_hrchy_values(item_count +1 ).perd_id:= p_period_id;
184:
185: INSERT INTO ben_tcs_cat_item_hrchy
186: (stmt_id, cat_id, item_id, lvl_num,cntr_cd ,row_in_cat_id , all_objects_in_cat_id,stmt_perd_id
187: )
188: VALUES (p_stmt_id, l_cur_cat_id, cat_item_rec.item_id, 1,cat_item_rec.cntr_cd,
189: cat_item_rec.row_id ,cat_item_rec.obj_id , p_period_id);

Line 324: INSERT INTO ben_tcs_cat_item_hrchy

320: item_hrchy_values(item_count +1 ).row_cat_id := cat_parent_rec.row_in_cat_id;
321: item_hrchy_values(item_count +1 ).all_objects_id := cat_parent_rec.all_objects_in_cat_id;
322: item_hrchy_values(item_count +1 ).perd_id := p_period_id;
323:
324: INSERT INTO ben_tcs_cat_item_hrchy
325: (stmt_id, cat_id,
326: item_id,
327: lvl_num ,cntr_cd, row_in_cat_id ,all_objects_in_cat_id,stmt_perd_id
328: )

Line 353: INSERT INTO ben_tcs_cat_item_hrchy

349: ROLLBACK TO hrchy;
350: FOR i IN 1..item_table.COUNT
351: LOOP
352: WRITE(' in hierarchy items to be processed stmt id : '||p_stmt_id || 'item id is : '||item_table(i).item_id ) ;
353: INSERT INTO ben_tcs_cat_item_hrchy
354: (stmt_id, cat_id,
355: item_id,lvl_num,cntr_cd ,stmt_perd_id)
356: VALUES (p_stmt_id ,-999 ,item_table(i).item_id ,-1 ,item_table(i).cntr_cd ,item_table(i).subcat_id );
357: