DBA Data[Home] [Help]

APPS.MTL_CATEGORY_SETS_PKG dependencies on FND_LOAD_UTIL

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

394:
395: BEGIN
396:
397: -- Translate owner to file_last_updated_by
398: f_luby := fnd_load_util.owner_id(x_owner);
399:
400: -- Translate char last_update_date to date
401: f_ludate := nvl(to_date(to_char(x_lud,'YYYY/MM/DD'), 'YYYY/MM/DD'), sysdate);
402:

Line 411: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

407: WHERE category_set_id = x_category_set_id
408: AND userenv('LANG') IN (language, source_lang)
409: AND ROWNUM = 1;
410:
411: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
412: db_ludate, x_custom_mode)) THEN
413:
414: UPDATE mtl_category_sets_tl
415: SET category_set_name = NVL(x_category_set_name, category_set_name)

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

483:
484: BEGIN
485:
486: -- Translate owner to file_last_updated_by
487: f_luby := fnd_load_util.owner_id(x_owner);
488:
489: -- Translate char last_update_date to date
490: f_ludate := nvl(to_date(to_char(x_lud,'YYYY/MM/DD'), 'YYYY/MM/DD'), sysdate);
491:

Line 539: IF (fnd_load_util.upload_test(f_luby,

535: OR (db_validate_updteable_flag <> 'N' AND X_VALIDATE_FLAG_UPDT_FLAG ='N')
536: OR (db_validate_updteable_flag = 'N' AND X_VALIDATE_FLAG_UPDT_FLAG <>'N') THEN
537: l_validate_flag_changed := true;
538: END IF;
539: IF (fnd_load_util.upload_test(f_luby,
540: f_ludate,
541: db_luby,
542: db_ludate,
543: x_custom_mode)) THEN

Line 727: X_LAST_UPDATED_BY => fnd_load_util.owner_id(X_OWNER),

723: X_HIERARCHY_ENABLED => X_HIERARCHY_ENABLED,
724: X_CONTROL_LEVEL => X_CONTROL_LEVEL,
725: X_DEFAULT_CATEGORY_ID => l_default_category_id,
726: X_LAST_UPDATE_DATE => SYSDATE,
727: X_LAST_UPDATED_BY => fnd_load_util.owner_id(X_OWNER),
728: X_LAST_UPDATE_LOGIN => 0
729: );
730:
731:

Line 775: , X_CREATED_BY => fnd_load_util.owner_id(X_OWNER)

771: , X_HIERARCHY_ENABLED => X_HIERARCHY_ENABLED
772: , X_CONTROL_LEVEL => X_CONTROL_LEVEL
773: , X_DEFAULT_CATEGORY_ID => l_default_category_id
774: , X_CREATION_DATE => SYSDATE
775: , X_CREATED_BY => fnd_load_util.owner_id(X_OWNER)
776: , X_LAST_UPDATE_DATE => SYSDATE
777: , X_LAST_UPDATED_BY => fnd_load_util.owner_id(X_OWNER)
778: , X_LAST_UPDATE_LOGIN => 0
779: );

Line 777: , X_LAST_UPDATED_BY => fnd_load_util.owner_id(X_OWNER)

773: , X_DEFAULT_CATEGORY_ID => l_default_category_id
774: , X_CREATION_DATE => SYSDATE
775: , X_CREATED_BY => fnd_load_util.owner_id(X_OWNER)
776: , X_LAST_UPDATE_DATE => SYSDATE
777: , X_LAST_UPDATED_BY => fnd_load_util.owner_id(X_OWNER)
778: , X_LAST_UPDATE_LOGIN => 0
779: );
780: end;
781: end;