12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: X_ROWID ROWID;
16: cursor C is select ROWID from QP_UI_QUERIES_TL
17: where QUERY_ID = X_QUERY_ID
18: and LANGUAGE = userenv('LANG')
19: ;
20: begin
17: where QUERY_ID = X_QUERY_ID
18: and LANGUAGE = userenv('LANG')
19: ;
20: begin
21: insert into QP_UI_QUERIES_TL (
22: CREATION_DATE,
23: CREATED_BY,
24: LAST_UPDATE_DATE,
25: LAST_UPDATED_BY,
47: from FND_LANGUAGES L
48: where L.INSTALLED_FLAG in ('I', 'B')
49: and not exists
50: (select NULL
51: from QP_UI_QUERIES_TL T
52: where T.QUERY_ID = X_QUERY_ID
53: and T.LANGUAGE = L.LANGUAGE_CODE);
54:
55: open c;
70: cursor c1 is select
71: PUBLIC_FLAG,
72: NAME,
73: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
74: from QP_UI_QUERIES_TL
75: where QUERY_ID = X_QUERY_ID
76: for update of QUERY_ID nowait;
77: begin
78: for tlinfo in c1 loop
101: X_LAST_UPDATED_BY in NUMBER,
102: X_LAST_UPDATE_LOGIN in NUMBER
103: ) is
104: begin
105: update QP_UI_QUERIES_TL set
106: DELETE_FLAG = X_DELETE_FLAG,
107: PUBLIC_FLAG = X_PUBLIC_FLAG,
108: NAME = X_NAME,
109: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
121: procedure DELETE_ROW (
122: X_QUERY_ID in NUMBER
123: ) is
124: begin
125: delete from QP_UI_QUERIES_TL
126: where QUERY_ID = X_QUERY_ID;
127:
128: if (sql%notfound) then
129: raise no_data_found;
208: procedure ADD_LANGUAGE
209: is
210: begin
211:
212: update QP_UI_QUERIES_TL T set (
213: NAME
214: ) = (select
215: B.NAME
216: from QP_UI_QUERIES_TL B
212: update QP_UI_QUERIES_TL T set (
213: NAME
214: ) = (select
215: B.NAME
216: from QP_UI_QUERIES_TL B
217: where B.QUERY_ID = T.QUERY_ID
218: and B.LANGUAGE = T.SOURCE_LANG)
219: where (
220: T.QUERY_ID,
221: T.LANGUAGE
222: ) in (select
223: SUBT.QUERY_ID,
224: SUBT.LANGUAGE
225: from QP_UI_QUERIES_TL SUBB, QP_UI_QUERIES_TL SUBT
226: where SUBB.QUERY_ID = SUBT.QUERY_ID
227: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
228: and (SUBB.NAME <> SUBT.NAME
229: ));
227: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
228: and (SUBB.NAME <> SUBT.NAME
229: ));
230:
231: insert into QP_UI_QUERIES_TL (
232: CREATION_DATE,
233: CREATED_BY,
234: LAST_UPDATE_DATE,
235: LAST_UPDATED_BY,
253: B.NAME,
254: B.HEADER_WHERE,
255: L.LANGUAGE_CODE,
256: B.SOURCE_LANG
257: from QP_UI_QUERIES_TL B, FND_LANGUAGES L
258: where L.INSTALLED_FLAG in ('I', 'B')
259: and B.LANGUAGE = userenv('LANG')
260: and not exists
261: (select NULL
258: where L.INSTALLED_FLAG in ('I', 'B')
259: and B.LANGUAGE = userenv('LANG')
260: and not exists
261: (select NULL
262: from QP_UI_QUERIES_TL T
263: where T.QUERY_ID = B.QUERY_ID
264: and T.LANGUAGE = L.LANGUAGE_CODE);
265:
266: end ADD_LANGUAGE;