APPS.CS_SR_UWQ_NODES_PKG dependencies on CS_SR_UWQ_NODES_TL

Line 76: insert into CS_SR_UWQ_NODES_TL (

72: X_LAST_UPDATED_BY,
73: X_LAST_UPDATE_LOGIN
74: );
75:
76: insert into CS_SR_UWQ_NODES_TL (
77: NODE_ID,
78: NODE_LABEL,
79: CREATION_DATE,
80: CREATED_BY,

Line 100: from CS_SR_UWQ_NODES_TL T

96: from FND_LANGUAGES L
97: where L.INSTALLED_FLAG in ('I', 'B')
98: and not exists
99: (select NULL
100: from CS_SR_UWQ_NODES_TL T
101: where T.NODE_ID = X_NODE_ID
102: and T.LANGUAGE = L.LANGUAGE_CODE);
103:
104: open c;

Line 157: from CS_SR_UWQ_NODES_TL

153:
154: cursor c1 is select
155: NODE_LABEL,
156: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
157: from CS_SR_UWQ_NODES_TL
158: where NODE_ID = X_NODE_ID
159: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
160: for update of NODE_ID nowait;
161: begin

Line 270: update CS_SR_UWQ_NODES_TL set

266: if (sql%notfound) then
267: raise no_data_found;
268: end if;
269:
270: update CS_SR_UWQ_NODES_TL set
271: NODE_LABEL = X_NODE_LABEL,
272: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
273: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
274: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 289: delete from CS_SR_UWQ_NODES_TL

285: procedure DELETE_ROW (
286: X_NODE_ID in NUMBER
287: ) is
288: begin
289: delete from CS_SR_UWQ_NODES_TL
290: where NODE_ID = X_NODE_ID;
291:
292: if (sql%notfound) then
293: raise no_data_found;

Line 307: delete from CS_SR_UWQ_NODES_TL T

303:
304: procedure ADD_LANGUAGE
305: is
306: begin
307: delete from CS_SR_UWQ_NODES_TL T
308: where not exists
309: (select NULL
310: from CS_SR_UWQ_NODES_B B
311: where B.NODE_ID = T.NODE_ID

Line 314: update CS_SR_UWQ_NODES_TL T set (

310: from CS_SR_UWQ_NODES_B B
311: where B.NODE_ID = T.NODE_ID
312: );
313:
314: update CS_SR_UWQ_NODES_TL T set (
315: NODE_LABEL
316: ) = (select
317: B.NODE_LABEL
318: from CS_SR_UWQ_NODES_TL B

Line 318: from CS_SR_UWQ_NODES_TL B

314: update CS_SR_UWQ_NODES_TL T set (
315: NODE_LABEL
316: ) = (select
317: B.NODE_LABEL
318: from CS_SR_UWQ_NODES_TL B
319: where B.NODE_ID = T.NODE_ID
320: and B.LANGUAGE = T.SOURCE_LANG)
321: where (
322: T.NODE_ID,

Line 327: from CS_SR_UWQ_NODES_TL SUBB, CS_SR_UWQ_NODES_TL SUBT

323: T.LANGUAGE
324: ) in (select
325: SUBT.NODE_ID,
326: SUBT.LANGUAGE
327: from CS_SR_UWQ_NODES_TL SUBB, CS_SR_UWQ_NODES_TL SUBT
328: where SUBB.NODE_ID = SUBT.NODE_ID
329: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
330: and (SUBB.NODE_LABEL <> SUBT.NODE_LABEL
331: ));

Line 333: insert into CS_SR_UWQ_NODES_TL (

329: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
330: and (SUBB.NODE_LABEL <> SUBT.NODE_LABEL
331: ));
332:
333: insert into CS_SR_UWQ_NODES_TL (
334: NODE_ID,
335: NODE_LABEL,
336: CREATION_DATE,
337: CREATED_BY,

Line 353: from CS_SR_UWQ_NODES_TL B, FND_LANGUAGES L

349: B.LAST_UPDATED_BY,
350: B.LAST_UPDATE_LOGIN,
351: L.LANGUAGE_CODE,
352: B.SOURCE_LANG
353: from CS_SR_UWQ_NODES_TL B, FND_LANGUAGES L
354: where L.INSTALLED_FLAG in ('I', 'B')
355: and B.LANGUAGE = userenv('LANG')
356: and not exists
357: (select NULL

Line 358: from CS_SR_UWQ_NODES_TL T

354: where L.INSTALLED_FLAG in ('I', 'B')
355: and B.LANGUAGE = userenv('LANG')
356: and not exists
357: (select NULL
358: from CS_SR_UWQ_NODES_TL T
359: where T.NODE_ID = B.NODE_ID
360: and T.LANGUAGE = L.LANGUAGE_CODE);
361: end ADD_LANGUAGE;
362:

Line 369: UPDATE CS_SR_UWQ_NODES_TL

365: x_node_label IN VARCHAR2,
366: x_owner IN VARCHAR2)
367: is
368: Begin
369: UPDATE CS_SR_UWQ_NODES_TL
370: set
371: NODE_LABEL = X_NODE_LABEL,
372: LAST_UPDATE_DATE = SYSDATE,
373: LAST_UPDATED_BY = decode(X_OWNER,'SEED',1,0),