APPS.CS_CF_FLOW_PAGES_PKG dependencies on CS_CF_FLOW_PAGES_TL

Line 91: insert into CS_CF_FLOW_PAGES_TL (

87: X_LAST_UPDATED_BY,
88: X_LAST_UPDATE_LOGIN
89: );
90:
91: insert into CS_CF_FLOW_PAGES_TL (
92: FLOW_ID,
93: FLOW_TYPE_PAGE_ID,
94: PAGE_DISPLAY_NAME,
95: CREATED_BY,

Line 117: from CS_CF_FLOW_PAGES_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from CS_CF_FLOW_PAGES_TL T
118: where T.FLOW_ID = X_FLOW_ID
119: and T.FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID
120: and T.LANGUAGE = L.LANGUAGE_CODE);
121:

Line 183: from CS_CF_FLOW_PAGES_TL

179:
180: cursor c1 is select
181: PAGE_DISPLAY_NAME,
182: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
183: from CS_CF_FLOW_PAGES_TL
184: where FLOW_ID = X_FLOW_ID
185: and FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID
186: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
187: for update of FLOW_ID nowait;

Line 311: update CS_CF_FLOW_PAGES_TL set

307: if (sql%notfound) then
308: raise no_data_found;
309: end if;
310:
311: update CS_CF_FLOW_PAGES_TL set
312: PAGE_DISPLAY_NAME = X_PAGE_DISPLAY_NAME,
313: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
314: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
315: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 331: delete from CS_CF_FLOW_PAGES_TL

327: X_FLOW_ID in NUMBER,
328: X_FLOW_TYPE_PAGE_ID in NUMBER
329: ) is
330: begin
331: delete from CS_CF_FLOW_PAGES_TL
332: where FLOW_ID = X_FLOW_ID
333: and FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID;
334:
335: if (sql%notfound) then

Line 351: delete from CS_CF_FLOW_PAGES_TL T

347:
348: procedure ADD_LANGUAGE
349: is
350: begin
351: delete from CS_CF_FLOW_PAGES_TL T
352: where not exists
353: (select NULL
354: from CS_CF_FLOW_PAGES_B B
355: where B.FLOW_ID = T.FLOW_ID

Line 359: update CS_CF_FLOW_PAGES_TL T set (

355: where B.FLOW_ID = T.FLOW_ID
356: and B.FLOW_TYPE_PAGE_ID = T.FLOW_TYPE_PAGE_ID
357: );
358:
359: update CS_CF_FLOW_PAGES_TL T set (
360: PAGE_DISPLAY_NAME
361: ) = (select
362: B.PAGE_DISPLAY_NAME
363: from CS_CF_FLOW_PAGES_TL B

Line 363: from CS_CF_FLOW_PAGES_TL B

359: update CS_CF_FLOW_PAGES_TL T set (
360: PAGE_DISPLAY_NAME
361: ) = (select
362: B.PAGE_DISPLAY_NAME
363: from CS_CF_FLOW_PAGES_TL B
364: where B.FLOW_ID = T.FLOW_ID
365: and B.FLOW_TYPE_PAGE_ID = T.FLOW_TYPE_PAGE_ID
366: and B.LANGUAGE = T.SOURCE_LANG)
367: where (

Line 375: from CS_CF_FLOW_PAGES_TL SUBB, CS_CF_FLOW_PAGES_TL SUBT

371: ) in (select
372: SUBT.FLOW_ID,
373: SUBT.FLOW_TYPE_PAGE_ID,
374: SUBT.LANGUAGE
375: from CS_CF_FLOW_PAGES_TL SUBB, CS_CF_FLOW_PAGES_TL SUBT
376: where SUBB.FLOW_ID = SUBT.FLOW_ID
377: and SUBB.FLOW_TYPE_PAGE_ID = SUBT.FLOW_TYPE_PAGE_ID
378: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
379: and (SUBB.PAGE_DISPLAY_NAME <> SUBT.PAGE_DISPLAY_NAME

Line 384: insert into CS_CF_FLOW_PAGES_TL (

380: or (SUBB.PAGE_DISPLAY_NAME is null and SUBT.PAGE_DISPLAY_NAME is not null)
381: or (SUBB.PAGE_DISPLAY_NAME is not null and SUBT.PAGE_DISPLAY_NAME is null)
382: ));
383:
384: insert into CS_CF_FLOW_PAGES_TL (
385: FLOW_ID,
386: FLOW_TYPE_PAGE_ID,
387: PAGE_DISPLAY_NAME,
388: CREATED_BY,

Line 406: from CS_CF_FLOW_PAGES_TL B, FND_LANGUAGES L

402: B.LAST_UPDATE_DATE,
403: B.LAST_UPDATE_LOGIN,
404: L.LANGUAGE_CODE,
405: B.SOURCE_LANG
406: from CS_CF_FLOW_PAGES_TL B, FND_LANGUAGES L
407: where L.INSTALLED_FLAG in ('I', 'B')
408: and B.LANGUAGE = userenv('LANG')
409: and not exists
410: (select NULL

Line 411: from CS_CF_FLOW_PAGES_TL T

407: where L.INSTALLED_FLAG in ('I', 'B')
408: and B.LANGUAGE = userenv('LANG')
409: and not exists
410: (select NULL
411: from CS_CF_FLOW_PAGES_TL T
412: where T.FLOW_ID = B.FLOW_ID
413: and T.FLOW_TYPE_PAGE_ID = B.FLOW_TYPE_PAGE_ID
414: and T.LANGUAGE = L.LANGUAGE_CODE);
415: end ADD_LANGUAGE;

Line 590: from CS_CF_FLOW_PAGES_TL

586: f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);
587:
588: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
589: into db_luby, db_ludate
590: from CS_CF_FLOW_PAGES_TL
591: where flow_id = X_FLOW_ID
592: and flow_type_page_id = X_FLOW_TYPE_PAGE_ID
593: and language = userenv('LANG');
594:

Line 596: update CS_CF_FLOW_PAGES_TL set

592: and flow_type_page_id = X_FLOW_TYPE_PAGE_ID
593: and language = userenv('LANG');
594:
595: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
596: update CS_CF_FLOW_PAGES_TL set
597: PAGE_DISPLAY_NAME = nvl(X_PAGE_DISPLAY_NAME, PAGE_DISPLAY_NAME),
598: LAST_UPDATE_DATE = f_ludate,
599: LAST_UPDATED_BY = f_luby,
600: LAST_UPDATE_LOGIN = 0,