APPS.WSH_SAVED_QUERIES_PKG dependencies on WSH_SAVED_QUERIES_TL

Line 163: insert into wsh_saved_queries_tl (

159: X_program_update_date,
160: X_request_id
161: );
162:
163: insert into wsh_saved_queries_tl (
164:
165: query_id,
166: name,
167: description,

Line 195: from wsh_saved_queries_tl t

191: where
192: l.installed_flag in ('I', 'B')
193: and not exists
194: (select null
195: from wsh_saved_queries_tl t
196: where t.query_id = x_query_id
197: and t.language = l.language_code);
198:
199: open row_id;

Line 300: from wsh_saved_queries_tl

296: select
297: name,
298: description,
299: decode(language, userenv('LANG'), 'Y', 'N') baselang
300: from wsh_saved_queries_tl
301: where query_id = x_query_id
302: and userenv('LANG') in (language, source_lang)
303: for update of query_id nowait;
304:

Line 632: update WSH_SAVED_QUERIES_TL set

628: END IF;
629: raise NO_DATA_FOUND;
630: end if;
631:
632: update WSH_SAVED_QUERIES_TL set
633: NAME = X_NAME,
634: DESCRIPTION = X_DESCRIPTION,
635: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
636: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 712: delete from WSH_SAVED_QUERIES_TL

708: IF l_debug_on THEN
709: WSH_DEBUG_SV.push(l_module_name);
710: END IF;
711: --
712: delete from WSH_SAVED_QUERIES_TL
713: where QUERY_ID = X_QUERY_ID;
714:
715: IF l_debug_on THEN
716: WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);

Line 766: delete from WSH_SAVED_QUERIES_TL T

762: IF l_debug_on THEN
763: WSH_DEBUG_SV.push(l_module_name);
764: END IF;
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

Line 776: update WSH_SAVED_QUERIES_TL T set (

772: IF l_debug_on THEN
773: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
774: END IF;
775:
776: update WSH_SAVED_QUERIES_TL T set (
777: NAME,
778: DESCRIPTION
779: ) = (select
780: B.NAME,

Line 782: from WSH_SAVED_QUERIES_TL B

778: DESCRIPTION
779: ) = (select
780: B.NAME,
781: B.DESCRIPTION
782: from WSH_SAVED_QUERIES_TL B
783: where B.QUERY_ID = T.QUERY_ID
784: and B.LANGUAGE = T.SOURCE_LANG)
785: where (
786: T.QUERY_ID,

Line 791: from WSH_SAVED_QUERIES_TL SUBB, WSH_SAVED_QUERIES_TL SUBT

787: T.LANGUAGE
788: ) in (select
789: SUBT.QUERY_ID,
790: SUBT.LANGUAGE
791: from WSH_SAVED_QUERIES_TL SUBB, WSH_SAVED_QUERIES_TL SUBT
792: where SUBB.QUERY_ID = SUBT.QUERY_ID
793: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
794: and (SUBB.NAME <> SUBT.NAME
795: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 804: insert into WSH_SAVED_QUERIES_TL (

800: ));
801: IF l_debug_on THEN
802: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);
803: END IF;
804: insert into WSH_SAVED_QUERIES_TL (
805: QUERY_ID,
806: NAME,
807: DESCRIPTION,
808: CREATION_DATE,

Line 826: from WSH_SAVED_QUERIES_TL B, FND_LANGUAGES L

822: B.LAST_UPDATED_BY,
823: B.LAST_UPDATE_LOGIN,
824: L.LANGUAGE_CODE,
825: B.SOURCE_LANG
826: from WSH_SAVED_QUERIES_TL B, FND_LANGUAGES L
827: where L.INSTALLED_FLAG in ('I', 'B')
828: and B.LANGUAGE = userenv('LANG')
829: and not exists
830: (select NULL

Line 831: from WSH_SAVED_QUERIES_TL T

827: where L.INSTALLED_FLAG in ('I', 'B')
828: and B.LANGUAGE = userenv('LANG')
829: and not exists
830: (select NULL
831: from WSH_SAVED_QUERIES_TL T
832: where T.QUERY_ID = B.QUERY_ID
833: and T.LANGUAGE = L.LANGUAGE_CODE);
834:
835: IF l_debug_on THEN