DBA Data[Home] [Help]

APPS.WMS_OP_PLANS_PKG dependencies on FND_LOAD_UTIL

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

292: db_luby number; -- entity owner in db
293: db_ludate date; -- entity update date in db
294: BEGIN
295: -- Translate owner to file_last_updated_by
296: f_luby := fnd_load_util.owner_id(X_OWNER);
297:
298: -- Translate char last_update_date to date
299: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
300: BEGIN

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

303: INTO db_luby,db_ludate
304: from wms_op_plans_B where
305: operation_plan_id = l_operation_plan_id ;
306: -- Test for customization and version
307: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
308: db_ludate, X_CUSTOM_MODE)) then
309: -- Update existing row
310: WMS_OP_PLANS_PKG.update_row (
311: x_operation_plan_id => l_operation_plan_id

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

634: db_luby number; -- entity owner in db
635: db_ludate date; -- entity update date in db
636: BEGIN
637: -- Translate owner to file_last_updated_by
638: f_luby := fnd_load_util.owner_id(X_OWNER);
639:
640: -- Translate char last_update_date to date
641: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
642: /*

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

651: select LAST_UPDATED_BY,LAST_UPDATE_DATE
652: INTO db_luby,db_ludate
653: from wms_op_plans_B where
654: operation_plan_id = fnd_number.canonical_to_number(x_operation_plan_id);
655: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
656: db_ludate, x_custom_mode)) then
657:
658: -- Update translations for this language
659: UPDATE wms_op_plans_tl SET