eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_OAM_BF_CUST_PKG dependencies on FND_OAM_BF_CUST

Line 1: package body FND_OAM_BF_CUST_PKG as

1: package body FND_OAM_BF_CUST_PKG as
2: /* $Header: AFOAMFCB.pls 115.0 2003/10/31 03:56:58 ppradhan noship $ */
3: procedure LOAD_ROW (
4: X_BIZ_FLOW_KEY in VARCHAR2,
5: X_MONITORED_FLAG in VARCHAR2,

Line 12: fnd_oam_bf_cust_pkg.LOAD_ROW (

8: X_FLOW_DISPLAY_NAME in VARCHAR2,
9: X_DESCRIPTION in VARCHAR2) is
10: begin
11:
12: fnd_oam_bf_cust_pkg.LOAD_ROW (
13: X_BIZ_FLOW_KEY => X_BIZ_FLOW_KEY,
14: X_MONITORED_FLAG => X_MONITORED_FLAG,
15: X_IS_TOP_LEVEL => X_IS_TOP_LEVEL,
16: X_OWNER => X_OWNER,

Line 52: from fnd_oam_bf_cust

48:
49:
50: select LAST_UPDATED_BY, LAST_UPDATE_DATE
51: into db_luby, db_ludate
52: from fnd_oam_bf_cust
53: where biz_flow_key = X_BIZ_FLOW_KEY;
54:
55: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
56: db_ludate, X_CUSTOM_MODE)) then

Line 57: fnd_oam_bf_cust_pkg.UPDATE_ROW (

53: where biz_flow_key = X_BIZ_FLOW_KEY;
54:
55: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
56: db_ludate, X_CUSTOM_MODE)) then
57: fnd_oam_bf_cust_pkg.UPDATE_ROW (
58: X_BIZ_FLOW_KEY => X_BIZ_FLOW_KEY,
59: X_MONITORED_FLAG => X_MONITORED_FLAG,
60: X_IS_TOP_LEVEL => X_IS_TOP_LEVEL,
61: X_FLOW_DISPLAY_NAME => X_FLOW_DISPLAY_NAME,

Line 70: fnd_oam_bf_cust_pkg.INSERT_ROW (

66: end if;
67: exception
68: when NO_DATA_FOUND then
69:
70: fnd_oam_bf_cust_pkg.INSERT_ROW (
71: X_ROWID => row_id,
72: X_BIZ_FLOW_KEY => X_BIZ_FLOW_KEY,
73: X_MONITORED_FLAG => X_MONITORED_FLAG,
74: X_IS_TOP_LEVEL => X_IS_TOP_LEVEL,

Line 92: FND_OAM_BF_CUST_PKG.translate_row(

88: X_FLOW_DISPLAY_NAME in VARCHAR2,
89: X_DESCRIPTION in VARCHAR2) is
90: begin
91:
92: FND_OAM_BF_CUST_PKG.translate_row(
93: x_biz_flow_key => x_biz_flow_key,
94: x_owner => x_owner,
95: x_flow_display_name => x_flow_display_name,
96: x_description => x_description,

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 163: cursor C is select ROWID from FND_OAM_BF_CUST

159: X_LAST_UPDATE_DATE in DATE,
160: X_LAST_UPDATED_BY in NUMBER,
161: X_LAST_UPDATE_LOGIN in NUMBER
162: ) is
163: cursor C is select ROWID from FND_OAM_BF_CUST
164: where BIZ_FLOW_KEY = X_BIZ_FLOW_KEY
165: ;
166: begin
167: insert into FND_OAM_BF_CUST (

Line 167: insert into FND_OAM_BF_CUST (

163: cursor C is select ROWID from FND_OAM_BF_CUST
164: where BIZ_FLOW_KEY = X_BIZ_FLOW_KEY
165: ;
166: begin
167: insert into FND_OAM_BF_CUST (
168: BIZ_FLOW_KEY,
169: MONITORED_FLAG,
170: IS_TOP_LEVEL,
171: CREATION_DATE,

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 237: from FND_OAM_BF_CUST

233: ) is
234: cursor c is select
235: MONITORED_FLAG,
236: IS_TOP_LEVEL
237: from FND_OAM_BF_CUST
238: where BIZ_FLOW_KEY = X_BIZ_FLOW_KEY
239: for update of BIZ_FLOW_KEY nowait;
240: recinfo c%rowtype;
241:

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 295: update FND_OAM_BF_CUST set

291: X_LAST_UPDATED_BY in NUMBER,
292: X_LAST_UPDATE_LOGIN in NUMBER
293: ) is
294: begin
295: update FND_OAM_BF_CUST set
296: MONITORED_FLAG = X_MONITORED_FLAG,
297: IS_TOP_LEVEL = X_IS_TOP_LEVEL,
298: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
299: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

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 333: delete from FND_OAM_BF_CUST

329: if (sql%notfound) then
330: raise no_data_found;
331: end if;
332:
333: delete from FND_OAM_BF_CUST
334: where BIZ_FLOW_KEY = X_BIZ_FLOW_KEY;
335:
336: if (sql%notfound) then
337: 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 347: from FND_OAM_BF_CUST B

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
349: );
350:
351: update FND_OAM_BF_CUST_TL T set (

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:

Line 407: end FND_OAM_BF_CUST_PKG;

403: where T.BIZ_FLOW_KEY = B.BIZ_FLOW_KEY
404: and T.LANGUAGE = L.LANGUAGE_CODE);
405: end ADD_LANGUAGE;
406:
407: end FND_OAM_BF_CUST_PKG;