APPS.WSH_SAVED_QUERIES_PKG dependencies on WSH_SAVED_QUERIES_B

Line 65: from wsh_saved_queries_b

61: from sys.dual;
62:
63: cursor row_id is
64: select rowid
65: from wsh_saved_queries_b
66: where query_id = X_query_id;
67:
68: --
69: l_debug_on BOOLEAN;

Line 98: insert into wsh_saved_queries_b(

94: open id_sequence;
95: fetch id_sequence into X_query_id;
96: close id_sequence;
97:
98: insert into wsh_saved_queries_b(
99:
100: query_id,
101: entity_type,
102: shared_flag,

Line 289: from wsh_saved_queries_b

285: is
286:
287: cursor lock_record is
288: select *
289: from wsh_saved_queries_b
290: where query_id = X_query_id
291: for update nowait;
292:
293: rec_info lock_record%ROWTYPE;

Line 591: update wsh_saved_queries_b set

587: WSH_DEBUG_SV.log(l_module_name,'X_SHARED_FLAG',X_SHARED_FLAG);
588: WSH_DEBUG_SV.log(l_module_name,'X_REQUEST_ID',X_REQUEST_ID);
589: END IF;
590: --
591: update wsh_saved_queries_b set
592:
593: entity_type = X_entity_type,
594: shared_flag = X_shared_flag,
595: pseudo_query = X_pseudo_query,

Line 691: procedure delete_row(X_query_id wsh_saved_queries_b.query_id%type)

687: -- WSH_SAVED_QUERIES table.
688: --
689: -- ===========================================================================
690:
691: procedure delete_row(X_query_id wsh_saved_queries_b.query_id%type)
692: is
693: --
694: l_debug_on BOOLEAN;
695: --

Line 725: delete from wsh_saved_queries_b

721: END IF;
722: raise no_data_found;
723: end if;
724:
725: delete from wsh_saved_queries_b
726: where query_id = X_query_id;
727:
728: IF l_debug_on THEN
729: WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);

Line 769: from WSH_SAVED_QUERIES_B B

765: --
766: delete from WSH_SAVED_QUERIES_TL T
767: where not exists
768: (select NULL
769: from WSH_SAVED_QUERIES_B B
770: where B.QUERY_ID = T.QUERY_ID
771: );
772: IF l_debug_on THEN
773: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);