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.EDW_VBH_SETUP dependencies on EDW_VBH_ROOTS

Line 44: delete from edw_vbh_roots;

40: execute immediate l_stmt;
41: delete from edw_set_of_books;
42: delete from edw_cons_set_of_books;
43: delete from edw_equi_set_of_books;
44: delete from edw_vbh_roots;
45: delete from edw_segment_classes;
46: open l_source_instances_cur;
47: loop
48: fetch l_source_instances_cur into l_instance_code,l_instance_link;

Line 558: cursor l_cur_edw_vbh_roots is

554: l_root_value3 varchar2(240);
555: l_root_value4 varchar2(240);
556: l_instance varchar2(30);
557:
558: cursor l_cur_edw_vbh_roots is
559: select edw_set_of_books_id,segment_name,
560: root_value1,root_value2,root_value3,root_value4
561: from edw_vbh_roots;
562: begin

Line 561: from edw_vbh_roots;

557:
558: cursor l_cur_edw_vbh_roots is
559: select edw_set_of_books_id,segment_name,
560: root_value1,root_value2,root_value3,root_value4
561: from edw_vbh_roots;
562: begin
563: open l_cur_edw_vbh_roots;
564: loop
565: fetch l_cur_edw_vbh_roots into l_edw_sob_id,l_segment_name,

Line 563: open l_cur_edw_vbh_roots;

559: select edw_set_of_books_id,segment_name,
560: root_value1,root_value2,root_value3,root_value4
561: from edw_vbh_roots;
562: begin
563: open l_cur_edw_vbh_roots;
564: loop
565: fetch l_cur_edw_vbh_roots into l_edw_sob_id,l_segment_name,
566: l_root_value1,l_root_value2,l_root_value3,l_root_value4;
567: exit when l_cur_edw_vbh_roots%NOTFOUND;

Line 565: fetch l_cur_edw_vbh_roots into l_edw_sob_id,l_segment_name,

561: from edw_vbh_roots;
562: begin
563: open l_cur_edw_vbh_roots;
564: loop
565: fetch l_cur_edw_vbh_roots into l_edw_sob_id,l_segment_name,
566: l_root_value1,l_root_value2,l_root_value3,l_root_value4;
567: exit when l_cur_edw_vbh_roots%NOTFOUND;
568: select instance into l_instance
569: from edw_set_of_books

Line 567: exit when l_cur_edw_vbh_roots%NOTFOUND;

563: open l_cur_edw_vbh_roots;
564: loop
565: fetch l_cur_edw_vbh_roots into l_edw_sob_id,l_segment_name,
566: l_root_value1,l_root_value2,l_root_value3,l_root_value4;
567: exit when l_cur_edw_vbh_roots%NOTFOUND;
568: select instance into l_instance
569: from edw_set_of_books
570: where edw_set_of_books_id= l_edw_sob_id;
571: p_problem_sob_id2:=l_edw_sob_id;

Line 607: close l_cur_edw_vbh_roots;

603: end if;
604: end if;
605: p_status:=true;
606: end loop;
607: close l_cur_edw_vbh_roots;
608:
609: exception
610: when others then
611: close l_cur_edw_vbh_roots;

Line 611: close l_cur_edw_vbh_roots;

607: close l_cur_edw_vbh_roots;
608:
609: exception
610: when others then
611: close l_cur_edw_vbh_roots;
612: p_status:=false;
613: p_problem_sob_id := null;
614: p_problem_sob_id2 := null;
615: p_hierarchy_no := null;

Line 652: in (select edw_set_of_books_id from edw_vbh_roots where segment_name=p_segment_name)

648: select parent_edw_set_of_books_id, child_edw_set_of_books_id,
649: consolidation_id
650: from edw_cons_set_of_books
651: where child_edw_set_of_books_id
652: in (select edw_set_of_books_id from edw_vbh_roots where segment_name=p_segment_name)
653: and parent_edw_set_of_books_id=p_edw_sob_id;
654:
655: loop
656: fetch l_cur_edw_cons into l_parent_edw_sob_id,l_child_edw_sob_id,l_consolidation_id;

Line 692: l_select_stmt:='select count(*) from edw_vbh_roots where edw_set_of_books_id=:b_problem_sob_id and root_value'||p_hierarchy_no||' is not null and segment_name =:b_segment_name';

688: dbms_sql.close_cursor(l_cursor_id);
689:
690: if l_result<>0 then
691: l_cursor_id:=dbms_sql.open_cursor;
692: l_select_stmt:='select count(*) from edw_vbh_roots where edw_set_of_books_id=:b_problem_sob_id and root_value'||p_hierarchy_no||' is not null and segment_name =:b_segment_name';
693:
694: dbms_sql.parse(l_cursor_id, l_select_stmt,dbms_sql.v7);
695: dbms_sql.bind_variable(l_cursor_id,':b_problem_sob_id',l_child_edw_sob_id);
696: dbms_sql.bind_variable(l_cursor_id,':b_segment_name',p_segment_name);

Line 716: where parent_edw_set_of_books_id in (select edw_set_of_books_id from edw_vbh_roots where segment_name=p_segment_name)

712:
713: open l_cur_edw_cons for
714: select parent_edw_set_of_books_id,child_edw_set_of_books_id,consolidation_id
715: from edw_cons_set_of_books
716: where parent_edw_set_of_books_id in (select edw_set_of_books_id from edw_vbh_roots where segment_name=p_segment_name)
717: and child_edw_set_of_books_id =p_edw_sob_id;
718: loop
719: fetch l_cur_edw_cons into l_parent_edw_sob_id,l_child_edw_sob_id,l_consolidation_id;
720: exit when l_cur_edw_cons%NOTFOUND;

Line 754: l_select_stmt:='select count(*) from edw_vbh_roots where edw_set_of_books_id=:b_problem_sob_id and root_value'||p_hierarchy_no||' is not null and segment_name=:b_segment_name';

750: dbms_sql.close_cursor(l_cursor_id);
751: if l_result<>0 then
752:
753: l_cursor_id:=dbms_sql.open_cursor;
754: l_select_stmt:='select count(*) from edw_vbh_roots where edw_set_of_books_id=:b_problem_sob_id and root_value'||p_hierarchy_no||' is not null and segment_name=:b_segment_name';
755:
756: dbms_sql.parse(l_cursor_id, l_select_stmt,dbms_sql.v7);
757: dbms_sql.bind_variable(l_cursor_id,':b_problem_sob_id',l_parent_edw_sob_id);
758: dbms_sql.bind_variable(l_cursor_id,':b_segment_name',p_segment_name);