eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_TCS_STMT_VALID_HRCHY dependencies on BEN_TCS_CAT

Line 56: FROM ben_tcs_cat_subcat_hrchy cat_subcat_hr

52:
53: CURSOR c_cat_hrchy (v_cat_id IN NUMBER, v_stmt_id NUMBER , v_period_id NUMBER)
54: IS
55: SELECT sub_cat_id, lvl_num
56: FROM ben_tcs_cat_subcat_hrchy cat_subcat_hr
57: WHERE cat_subcat_hr.cat_id = v_cat_id
58: AND cat_subcat_hr.stmt_id = v_stmt_id
59: ANd cat_subcat_hr.stmt_perd_id = v_period_id ;
60:

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 135: DELETE FROM ben_tcs_cat_subcat_hrchy

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
136: WHERE cat_id = stmt_obj_hrchy (l_counter)
137: and stmt_id = p_stmt_id
138: and stmt_perd_id = p_period_id;
139: OPEN c_cat_subcat (l_cur_cat_id);

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 242: INSERT INTO ben_tcs_cat_subcat_hrchy

238: subcat_hrchy_values(subcat_count +1 ).subcat_id:=l_cur_cat_id;
239: subcat_hrchy_values(subcat_count +1 ).lvl_num:=1;
240: subcat_hrchy_values(subcat_count +1 ).row_cat_id:=cat_parent_rec.row_in_cat_id;
241: subcat_hrchy_values(subcat_count +1 ).perd_id:= p_period_id;
242: INSERT INTO ben_tcs_cat_subcat_hrchy
243: (stmt_id, cat_id, sub_cat_id, lvl_num,row_in_cat_id,stmt_perd_id
244: )
245: VALUES (p_stmt_id, cat_parent_rec.cat_id, l_cur_cat_id, 1 ,cat_parent_rec.row_in_cat_id , p_period_id);
246:

Line 251: FROM BEN_TCS_CAT

247: --Added For Stk Ext
248: distinct_item := 0;
249: SELECT cat_type_cd
250: INTO cat_type
251: FROM BEN_TCS_CAT
252: WHERE cat_id = l_cur_cat_id ;
253: IF ( cat_type = 'STKOPTEXT' ) THEN
254: for i in 1..item_table.count
255: loop

Line 287: INSERT INTO ben_tcs_cat_subcat_hrchy

283: subcat_hrchy_values(subcat_count +1 ).lvl_num:=cat_hrchy_rec.lvl_num + 1;
284: subcat_hrchy_values(subcat_count +1 ).row_cat_id:=cat_parent_rec.row_in_cat_id;
285: subcat_hrchy_values(subcat_count +1 ).perd_id:=p_period_id;
286:
287: INSERT INTO ben_tcs_cat_subcat_hrchy
288: (stmt_id, cat_id,
289: sub_cat_id,
290: lvl_num,
291: row_in_cat_id ,stmt_perd_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: