APPS.FND_OAM_BF_CUST_PKG dependencies on FND_OAM_BF_CUST_TL

Line 127: from fnd_oam_bf_cust_tl

123:
124: begin
125: select LAST_UPDATED_BY, LAST_UPDATE_DATE
126: into db_luby, db_ludate
127: from fnd_oam_bf_cust_tl
128: where biz_flow_key = X_BIZ_FLOW_KEY
129: and LANGUAGE = userenv('LANG');
130:
131: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 133: update fnd_oam_bf_cust_tl set

129: and LANGUAGE = userenv('LANG');
130:
131: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
132: db_ludate, X_CUSTOM_MODE)) then
133: update fnd_oam_bf_cust_tl set
134: flow_display_name = nvl(X_FLOW_DISPLAY_NAME, flow_display_name),
135: description = nvl(X_DESCRIPTION, description),
136: source_lang = userenv('LANG'),
137: last_update_date = f_ludate,

Line 187: insert into FND_OAM_BF_CUST_TL (

183: X_LAST_UPDATED_BY,
184: X_LAST_UPDATE_LOGIN
185: );
186:
187: insert into FND_OAM_BF_CUST_TL (
188: BIZ_FLOW_KEY,
189: FLOW_DISPLAY_NAME,
190: DESCRIPTION,
191: CREATED_BY,

Line 213: from FND_OAM_BF_CUST_TL T

209: from FND_LANGUAGES L
210: where L.INSTALLED_FLAG in ('I', 'B')
211: and not exists
212: (select NULL
213: from FND_OAM_BF_CUST_TL T
214: where T.BIZ_FLOW_KEY = X_BIZ_FLOW_KEY
215: and T.LANGUAGE = L.LANGUAGE_CODE);
216:
217: open c;

Line 246: from FND_OAM_BF_CUST_TL

242: cursor c1 is select
243: FLOW_DISPLAY_NAME,
244: DESCRIPTION,
245: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
246: from FND_OAM_BF_CUST_TL
247: where BIZ_FLOW_KEY = X_BIZ_FLOW_KEY
248: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
249: for update of BIZ_FLOW_KEY nowait;
250: begin

Line 307: update FND_OAM_BF_CUST_TL set

303: if (sql%notfound) then
304: raise no_data_found;
305: end if;
306:
307: update FND_OAM_BF_CUST_TL set
308: FLOW_DISPLAY_NAME = X_FLOW_DISPLAY_NAME,
309: DESCRIPTION = X_DESCRIPTION,
310: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
311: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 326: delete from FND_OAM_BF_CUST_TL

322: procedure DELETE_ROW (
323: X_BIZ_FLOW_KEY in VARCHAR2
324: ) is
325: begin
326: delete from FND_OAM_BF_CUST_TL
327: where BIZ_FLOW_KEY = X_BIZ_FLOW_KEY;
328:
329: if (sql%notfound) then
330: raise no_data_found;

Line 344: delete from FND_OAM_BF_CUST_TL T

340:
341: procedure ADD_LANGUAGE
342: is
343: begin
344: delete from FND_OAM_BF_CUST_TL T
345: where not exists
346: (select NULL
347: from FND_OAM_BF_CUST B
348: where B.BIZ_FLOW_KEY = T.BIZ_FLOW_KEY

Line 351: update FND_OAM_BF_CUST_TL T set (

347: from FND_OAM_BF_CUST B
348: where B.BIZ_FLOW_KEY = T.BIZ_FLOW_KEY
349: );
350:
351: update FND_OAM_BF_CUST_TL T set (
352: FLOW_DISPLAY_NAME,
353: DESCRIPTION
354: ) = (select
355: B.FLOW_DISPLAY_NAME,

Line 357: from FND_OAM_BF_CUST_TL B

353: DESCRIPTION
354: ) = (select
355: B.FLOW_DISPLAY_NAME,
356: B.DESCRIPTION
357: from FND_OAM_BF_CUST_TL B
358: where B.BIZ_FLOW_KEY = T.BIZ_FLOW_KEY
359: and B.LANGUAGE = T.SOURCE_LANG)
360: where (
361: T.BIZ_FLOW_KEY,

Line 366: from FND_OAM_BF_CUST_TL SUBB, FND_OAM_BF_CUST_TL SUBT

362: T.LANGUAGE
363: ) in (select
364: SUBT.BIZ_FLOW_KEY,
365: SUBT.LANGUAGE
366: from FND_OAM_BF_CUST_TL SUBB, FND_OAM_BF_CUST_TL SUBT
367: where SUBB.BIZ_FLOW_KEY = SUBT.BIZ_FLOW_KEY
368: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
369: and (SUBB.FLOW_DISPLAY_NAME <> SUBT.FLOW_DISPLAY_NAME
370: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 375: insert into FND_OAM_BF_CUST_TL (

371: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
372: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
373: ));
374:
375: insert into FND_OAM_BF_CUST_TL (
376: BIZ_FLOW_KEY,
377: FLOW_DISPLAY_NAME,
378: DESCRIPTION,
379: CREATED_BY,

Line 397: from FND_OAM_BF_CUST_TL B, FND_LANGUAGES L

393: B.LAST_UPDATE_DATE,
394: B.LAST_UPDATE_LOGIN,
395: L.LANGUAGE_CODE,
396: B.SOURCE_LANG
397: from FND_OAM_BF_CUST_TL B, FND_LANGUAGES L
398: where L.INSTALLED_FLAG in ('I', 'B')
399: and B.LANGUAGE = userenv('LANG')
400: and not exists
401: (select NULL

Line 402: from FND_OAM_BF_CUST_TL T

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