DBA Data[Home] [Help]

APPS.WMS_PAGE_TEMPLATES_PKG dependencies on FND_LOAD_UTIL

Line 387: f_luby := fnd_load_util.owner_id(X_OWNER);

383: db_luby number; -- entity owner in db
384: db_ludate date; -- entity update date in db
385: begin
386: -- Translate owner to file_last_updated_by
387: f_luby := fnd_load_util.owner_id(X_OWNER);
388:
389: -- Translate char last_update_date to date
390: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
391:

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

398: where PAGE_ID = X_PAGE_ID
399: and TEMPLATE_NAME = X_TEMPLATE_NAME;
400:
401: -- Test for customization and version
402: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
403: db_ludate, x_custom_mode)) then
404: -- Update translations for this language
405: update WMS_PAGE_TEMPLATES_TL set
406: USER_TEMPLATE_NAME = X_USER_TEMPLATE_NAME,

Line 465: if (X_TEMPLATE_DESCRIPTION = fnd_load_util.null_value) then

461:
462: -- Translate a true null value to fnd_api.g_miss_char
463: -- Note table handler apis should be coded to treat
464: -- fnd_api.g_miss_* as true nulls, and not as no-change.
465: if (X_TEMPLATE_DESCRIPTION = fnd_load_util.null_value) then
466: l_TEMPLATE_DESCRIPTION := fnd_api.g_miss_char;
467: else
468: l_TEMPLATE_DESCRIPTION := X_TEMPLATE_DESCRIPTION;
469: end if;

Line 472: f_luby := fnd_load_util.owner_id(X_OWNER);

468: l_TEMPLATE_DESCRIPTION := X_TEMPLATE_DESCRIPTION;
469: end if;
470:
471: -- Translate owner to file_last_updated_by
472: f_luby := fnd_load_util.owner_id(X_OWNER);
473:
474: -- Translate char last_update_date to date
475: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
476:

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

482: where PAGE_ID = X_PAGE_ID
483: and TEMPLATE_NAME = X_TEMPLATE_NAME;
484:
485: -- Test for customization and version
486: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
487: db_ludate, X_CUSTOM_MODE)) then
488: -- Update existing row
489: WMS_PAGE_TEMPLATES_PKG.UPDATE_ROW(
490: X_PAGE_ID => X_PAGE_ID,