DBA Data[Home] [Help]

APPS.HR_ITEM_PROPERTIES_PKG dependencies on FND_LOAD_UTIL

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

1889: end;
1890:
1891: begin
1892: -- Translate owner to file_last_updated_by
1893: f_luby := fnd_load_util.owner_id(X_OWNER);
1894: -- Translate char last_update_date to date
1895: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
1896:
1897: select LAST_UPDATED_BY, LAST_UPDATE_DATE

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

1899: from HR_ITEM_PROPERTIES_TL
1900: where item_property_id = x_item_property_id
1901: and LANGUAGE=userenv('LANG');
1902:
1903: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1904: db_ludate,X_CUSTOM_MODE)) then
1905: UPDATE_COPIES (
1906: X_ITEM_PROPERTY_ID,
1907: X_FORM_ITEM_ID,

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

2401: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2402: */
2403:
2404: -- Translate owner to file_last_updated_by
2405: f_luby := fnd_load_util.owner_id(X_OWNER);
2406: -- Translate char last_update_date to date
2407: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
2408:
2409: select LAST_UPDATED_BY, LAST_UPDATE_DATE

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

2411: from HR_ITEM_PROPERTIES_TL
2412: where item_property_id = x_item_property_id
2413: and LANGUAGE=userenv('LANG');
2414:
2415: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2416: db_ludate,X_CUSTOM_MODE)) then
2417:
2418: update HR_ITEM_PROPERTIES_TL set
2419: DEFAULT_VALUE = X_DEFAULT_VALUE,

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

2689: and nvl(template_item_context_id,hr_api.g_number) = nvl(x_template_item_context_id,hr_api.g_number);
2690: */
2691:
2692: -- Translate owner to file_last_updated_by
2693: f_luby := fnd_load_util.owner_id(X_OWNER);
2694: -- Translate char last_update_date to date
2695: -- f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate); -- Bug 5571335
2696: f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);
2697:

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

2700: from HR_ITEM_PROPERTIES_TL
2701: where item_property_id = x_item_property_id
2702: and LANGUAGE=userenv('LANG');
2703:
2704: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2705: db_ludate,X_CUSTOM_MODE)) then
2706:
2707: update HR_ITEM_PROPERTIES_TL set
2708: DEFAULT_VALUE = X_DEFAULT_VALUE,