APPS.BIS_BIA_RSG_LOG_MGMNT dependencies on ALL_OBJECTS

Line 126: FROM all_objects

122:
123: function get_mv_creation_date_dd (p_base_object_name in varchar2,p_base_object_type in varchar2,p_base_object_schema in varchar2) return date is
124: cursor c_mv_creation_date_in_DD is
125: SELECT created mv_creation_date_dd
126: FROM all_objects
127: WHERE owner=p_base_object_schema
128: and object_name = p_base_object_name
129: and object_type=decode(p_base_object_type,'TABLE','TABLE','MV','MATERIALIZED VIEW') ;
130: l_date date;

Line 879: l_object_owner all_objects.owner%type;

875: ';
876:
877: l_object_name bis_obj_properties.object_name%type;
878: l_object_type bis_obj_properties.object_type%type;
879: l_object_owner all_objects.owner%type;
880: BEGIN
881: errbuf := NULL;
882: retcode := '0';
883: IF (Not BIS_COLLECTION_UTILITIES.setup(p_request_set_name)) THEN

Line 953: l_object_owner all_objects.owner%type;

949: order by object_type, object_name';
950:
951: l_object_name bis_obj_properties.object_name%type;
952: l_object_type bis_obj_properties.object_type%type;
953: l_object_owner all_objects.owner%type;
954: BEGIN
955: --OPEN c_all_log_base_obj(p_request_set_name);
956: WRITELOG('Executing the following: ' || l_stmt || '; using ' || p_request_set_name);
957: OPEN c_all_log_base_obj for l_stmt using p_request_set_name;