DBA Data[Home] [Help]

APPS.FND_APPLICATION_PKG dependencies on FND_LOAD_UTIL

Line 61: fnd_load_util.null_value,

57: ) select
58: X_APPLICATION_ID,
59: X_APPLICATION_NAME,
60: decode(X_DESCRIPTION,
61: fnd_load_util.null_value,
62: null,
63: decode(instr(X_DESCRIPTION,fnd_load_util.null_value), 0,X_DESCRIPTION,
64: null)
65: ),

Line 63: decode(instr(X_DESCRIPTION,fnd_load_util.null_value), 0,X_DESCRIPTION,

59: X_APPLICATION_NAME,
60: decode(X_DESCRIPTION,
61: fnd_load_util.null_value,
62: null,
63: decode(instr(X_DESCRIPTION,fnd_load_util.null_value), 0,X_DESCRIPTION,
64: null)
65: ),
66: X_CREATED_BY,
67: X_CREATION_DATE,

Line 226: fnd_load_util.null_value,

222:
223: update FND_APPLICATION_TL set
224: APPLICATION_NAME = X_APPLICATION_NAME,
225: DESCRIPTION = decode(X_DESCRIPTION,
226: fnd_load_util.null_value,
227: null,
228: null,
229: description,
230: decode(instr(X_DESCRIPTION,fnd_load_util.null_value),

Line 230: decode(instr(X_DESCRIPTION,fnd_load_util.null_value),

226: fnd_load_util.null_value,
227: null,
228: null,
229: description,
230: decode(instr(X_DESCRIPTION,fnd_load_util.null_value),
231: 0,
232: X_DESCRIPTION,
233: null)
234: ),

Line 340: f_luby := fnd_load_util.owner_id(x_owner);

336:
337: begin
338:
339: -- Translate owner to file_last_updated_by
340: f_luby := fnd_load_util.owner_id(x_owner);
341:
342: -- Translate char last_update_date to date
343: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
344:

Line 354: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

350: FROM FND_APPLICATION
351: where application_short_name = X_APPLICATION_SHORT_NAME
352: and application_id = X_APPLICATION_ID;
353:
354: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
355: db_ludate, X_CUSTOM_MODE)) then
356: fnd_application_pkg.UPDATE_ROW (
357: X_APPLICATION_ID => X_APPLICATION_ID,
358: X_APPLICATION_SHORT_NAME => X_APPLICATION_SHORT_NAME,

Line 442: f_luby := fnd_load_util.owner_id(x_owner);

438:
439: begin
440:
441: -- Translate owner to file_last_updated_by
442: f_luby := fnd_load_util.owner_id(x_owner);
443:
444: -- Translate char last_update_date to date
445: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
446:

Line 457: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

453: from fnd_application
454: where application_short_name = X_APPLICATION_SHORT_NAME)
455: and LANGUAGE = userenv('LANG');
456:
457: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
458: db_ludate, X_CUSTOM_MODE)) then
459: update fnd_application_tl set
460: application_name = nvl(X_APPLICATION_NAME, application_name),
461: description = decode(X_DESCRIPTION,

Line 462: fnd_load_util.null_value,

458: db_ludate, X_CUSTOM_MODE)) then
459: update fnd_application_tl set
460: application_name = nvl(X_APPLICATION_NAME, application_name),
461: description = decode(X_DESCRIPTION,
462: fnd_load_util.null_value,
463: null,
464: null,
465: description,
466: decode(instr(X_DESCRIPTION,fnd_load_util.null_value),

Line 466: decode(instr(X_DESCRIPTION,fnd_load_util.null_value),

462: fnd_load_util.null_value,
463: null,
464: null,
465: description,
466: decode(instr(X_DESCRIPTION,fnd_load_util.null_value),
467: 0,
468: X_DESCRIPTION,
469: null)
470: ),