DBA Data[Home] [Help]

APPS.HR_ITEM_PROPERTIES_PKG dependencies on FND_LOAD_UTIL

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

1803: end;
1804:
1805: begin
1806: -- Translate owner to file_last_updated_by
1807: f_luby := fnd_load_util.owner_id(X_OWNER);
1808: -- Translate char last_update_date to date
1809: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
1810:
1811: select LAST_UPDATED_BY, LAST_UPDATE_DATE

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

1813: from HR_ITEM_PROPERTIES_TL
1814: where item_property_id = x_item_property_id
1815: and LANGUAGE=userenv('LANG');
1816:
1817: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1818: db_ludate,X_CUSTOM_MODE)) then
1819: UPDATE_COPIES (
1820: X_ITEM_PROPERTY_ID,
1821: X_FORM_ITEM_ID,

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

2315: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2316: */
2317:
2318: -- Translate owner to file_last_updated_by
2319: f_luby := fnd_load_util.owner_id(X_OWNER);
2320: -- Translate char last_update_date to date
2321: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
2322:
2323: select LAST_UPDATED_BY, LAST_UPDATE_DATE

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

2325: from HR_ITEM_PROPERTIES_TL
2326: where item_property_id = x_item_property_id
2327: and LANGUAGE=userenv('LANG');
2328:
2329: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2330: db_ludate,X_CUSTOM_MODE)) then
2331:
2332: update HR_ITEM_PROPERTIES_TL set
2333: DEFAULT_VALUE = X_DEFAULT_VALUE,

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

2603: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2604: */
2605:
2606: -- Translate owner to file_last_updated_by
2607: f_luby := fnd_load_util.owner_id(X_OWNER);
2608: -- Translate char last_update_date to date
2609: -- f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate); -- Bug 5571335
2610: f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);
2611:

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

2614: from HR_ITEM_PROPERTIES_TL
2615: where item_property_id = x_item_property_id
2616: and LANGUAGE=userenv('LANG');
2617:
2618: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2619: db_ludate,X_CUSTOM_MODE)) then
2620:
2621: update HR_ITEM_PROPERTIES_TL set
2622: DEFAULT_VALUE = X_DEFAULT_VALUE,