DBA Data[Home] [Help]

APPS.BIS_COLL_RS_HISTORY dependencies on BIS_CREATE_REQUESTSET

Line 621: and OWNER = BIS_CREATE_REQUESTSET.get_object_owner(p_object_name,l_object_type);

617: CURSOR cObjInfo_table IS
618: SELECT TABLESPACE_NAME Tblsp
619: FROM all_tables
620: WHERE TABLE_NAME = p_object_name
621: and OWNER = BIS_CREATE_REQUESTSET.get_object_owner(p_object_name,l_object_type);
622:
623: /* Moving the code to find out the free tablespace out of this api
624: CURSOR cFreeTableSpace IS
625: SELECT SUM(bytes) FreeTablespace

Line 633: and table_owner = BIS_CREATE_REQUESTSET.get_object_owner(p_object_name,l_object_type);

629: CURSOR cObjInfo_part IS
630: select PARTITION_NAME , TABLESPACE_NAME
631: from all_tab_partitions
632: where table_name = p_object_name
633: and table_owner = BIS_CREATE_REQUESTSET.get_object_owner(p_object_name,l_object_type);
634:
635: TYPE curType IS REF CURSOR;
636: cRowCount curType;
637:

Line 678: dbms_space.unused_space (BIS_CREATE_REQUESTSET.get_object_owner(p_object_name,l_object_type),

674: BIS_COLLECTION_UTILITIES.put_line(p_object_name ||' is a partitioned object');
675: for cObjInfo_part_rec in cObjInfo_part loop
676: p_Tablespace_name := cObjInfo_part_rec.TABLESPACE_NAME;
677:
678: dbms_space.unused_space (BIS_CREATE_REQUESTSET.get_object_owner(p_object_name,l_object_type),
679: p_object_name,
680: 'TABLE PARTITION',
681: p_total_blocks,
682: p_total_bytes,

Line 696: dbms_space.unused_space (BIS_CREATE_REQUESTSET.get_object_owner(p_object_name,l_object_type),

692:
693:
694: else
695: -- get object free space
696: dbms_space.unused_space (BIS_CREATE_REQUESTSET.get_object_owner(p_object_name,l_object_type),
697: p_object_name,
698: 'TABLE',
699: p_total_blocks,
700: p_total_bytes,