APPS.CS_CF_FLOWS_PKG dependencies on CS_CF_FLOWS_TL

Line 91: insert into CS_CF_FLOWS_TL (

87: X_ATTRIBUTE15,
88: X_SEEDED_FLAG
89: );
90:
91: insert into CS_CF_FLOWS_TL (
92: CREATED_BY,
93: CREATION_DATE,
94: LAST_UPDATED_BY,
95: LAST_UPDATE_DATE,

Line 115: from CS_CF_FLOWS_TL T

111: from FND_LANGUAGES L
112: where L.INSTALLED_FLAG in ('I', 'B')
113: and not exists
114: (select NULL
115: from CS_CF_FLOWS_TL T
116: where T.FLOW_ID = X_FLOW_ID
117: and T.LANGUAGE = L.LANGUAGE_CODE);
118:
119: open c;

Line 181: from CS_CF_FLOWS_TL

177:
178: cursor c1 is select
179: FLOW_DISPLAY_NAME,
180: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
181: from CS_CF_FLOWS_TL
182: where FLOW_ID = X_FLOW_ID
183: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
184: for update of FLOW_ID nowait;
185: begin

Line 311: update CS_CF_FLOWS_TL set

307: if (sql%notfound) then
308: raise no_data_found;
309: end if;
310:
311: update CS_CF_FLOWS_TL set
312: FLOW_DISPLAY_NAME = X_FLOW_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 329: delete from CS_CF_FLOWS_TL

325: procedure DELETE_ROW (
326: X_FLOW_ID in NUMBER
327: ) is
328: begin
329: delete from CS_CF_FLOWS_TL
330: where FLOW_ID = X_FLOW_ID;
331:
332: if (sql%notfound) then
333: raise no_data_found;

Line 347: delete from CS_CF_FLOWS_TL T

343:
344: procedure ADD_LANGUAGE
345: is
346: begin
347: delete from CS_CF_FLOWS_TL T
348: where not exists
349: (select NULL
350: from CS_CF_FLOWS_B B
351: where B.FLOW_ID = T.FLOW_ID

Line 354: update CS_CF_FLOWS_TL T set (

350: from CS_CF_FLOWS_B B
351: where B.FLOW_ID = T.FLOW_ID
352: );
353:
354: update CS_CF_FLOWS_TL T set (
355: FLOW_DISPLAY_NAME
356: ) = (select
357: B.FLOW_DISPLAY_NAME
358: from CS_CF_FLOWS_TL B

Line 358: from CS_CF_FLOWS_TL B

354: update CS_CF_FLOWS_TL T set (
355: FLOW_DISPLAY_NAME
356: ) = (select
357: B.FLOW_DISPLAY_NAME
358: from CS_CF_FLOWS_TL B
359: where B.FLOW_ID = T.FLOW_ID
360: and B.LANGUAGE = T.SOURCE_LANG)
361: where (
362: T.FLOW_ID,

Line 367: from CS_CF_FLOWS_TL SUBB, CS_CF_FLOWS_TL SUBT

363: T.LANGUAGE
364: ) in (select
365: SUBT.FLOW_ID,
366: SUBT.LANGUAGE
367: from CS_CF_FLOWS_TL SUBB, CS_CF_FLOWS_TL SUBT
368: where SUBB.FLOW_ID = SUBT.FLOW_ID
369: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
370: and (SUBB.FLOW_DISPLAY_NAME <> SUBT.FLOW_DISPLAY_NAME
371: or (SUBB.FLOW_DISPLAY_NAME is null and SUBT.FLOW_DISPLAY_NAME is not null)

Line 375: insert into CS_CF_FLOWS_TL (

371: or (SUBB.FLOW_DISPLAY_NAME is null and SUBT.FLOW_DISPLAY_NAME is not null)
372: or (SUBB.FLOW_DISPLAY_NAME is not null and SUBT.FLOW_DISPLAY_NAME is null)
373: ));
374:
375: insert into CS_CF_FLOWS_TL (
376: CREATED_BY,
377: CREATION_DATE,
378: LAST_UPDATED_BY,
379: LAST_UPDATE_DATE,

Line 395: from CS_CF_FLOWS_TL B, FND_LANGUAGES L

391: B.FLOW_ID,
392: B.FLOW_DISPLAY_NAME,
393: L.LANGUAGE_CODE,
394: B.SOURCE_LANG
395: from CS_CF_FLOWS_TL B, FND_LANGUAGES L
396: where L.INSTALLED_FLAG in ('I', 'B')
397: and B.LANGUAGE = userenv('LANG')
398: and not exists
399: (select NULL

Line 400: from CS_CF_FLOWS_TL T

396: where L.INSTALLED_FLAG in ('I', 'B')
397: and B.LANGUAGE = userenv('LANG')
398: and not exists
399: (select NULL
400: from CS_CF_FLOWS_TL T
401: where T.FLOW_ID = B.FLOW_ID
402: and T.LANGUAGE = L.LANGUAGE_CODE);
403: end ADD_LANGUAGE;
404:

Line 577: from CS_CF_FLOWS_TL

573: f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate) ;
574:
575: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
576: into db_luby, db_ludate
577: from CS_CF_FLOWS_TL
578: where flow_id = X_FLOW_ID
579: and language = userenv('LANG');
580:
581: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then

Line 582: update CS_CF_FLOWS_TL set

578: where flow_id = X_FLOW_ID
579: and language = userenv('LANG');
580:
581: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
582: update CS_CF_FLOWS_TL set
583: FLOW_DISPLAY_NAME = nvl(X_FLOW_DISPLAY_NAME, FLOW_DISPLAY_NAME),
584: LAST_UPDATE_DATE = f_ludate,
585: LAST_UPDATED_BY = f_luby,
586: LAST_UPDATE_LOGIN = 0,