APPS.HR_KI_HRC_LOAD_API dependencies on FND_LOAD_UTIL

Line 191: --selecting fnd_load_util.null_value for Global Node,Here we need

187: begin
188:
189: --For Global hierarchy_node parent_hierarchy_key will be null
190: --Hence at the time of downloading,we will be
191: --selecting fnd_load_util.null_value for Global Node,Here we need
192: --to ignore validation for this value
193:
194: if (X_PARENT_HIERARCHY_KEY <> substrb(fnd_load_util.null_value,1,30) ) then
195: open C_VAL;

Line 194: if (X_PARENT_HIERARCHY_KEY <> substrb(fnd_load_util.null_value,1,30) ) then

190: --Hence at the time of downloading,we will be
191: --selecting fnd_load_util.null_value for Global Node,Here we need
192: --to ignore validation for this value
193:
194: if (X_PARENT_HIERARCHY_KEY <> substrb(fnd_load_util.null_value,1,30) ) then
195: open C_VAL;
196: fetch C_VAL into X_PARENT_HIERARCHY_ID;
197:
198: If C_VAL%NOTFOUND then

Line 255: l_last_updated_by := fnd_load_util.owner_id(X_OWNER);

251: ,X_PARENT_HIERARCHY_ID => l_parent_hierarchy_id
252: );
253:
254: -- Translate owner to file_last_updated_by
255: l_last_updated_by := fnd_load_util.owner_id(X_OWNER);
256: l_created_by := fnd_load_util.owner_id(X_OWNER);
257:
258: -- Translate char last_update_date to date
259: l_last_update_date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD hh24:mi:ss'), sysdate);

Line 256: l_created_by := fnd_load_util.owner_id(X_OWNER);

252: );
253:
254: -- Translate owner to file_last_updated_by
255: l_last_updated_by := fnd_load_util.owner_id(X_OWNER);
256: l_created_by := fnd_load_util.owner_id(X_OWNER);
257:
258: -- Translate char last_update_date to date
259: l_last_update_date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD hh24:mi:ss'), sysdate);
260:

Line 295: if (fnd_load_util.upload_test(l_last_updated_by, l_last_update_date, db_luby,

291: from HR_KI_HIERARCHIES
292: where hierarchy_id = l_hierarchy_id;
293:
294:
295: if (fnd_load_util.upload_test(l_last_updated_by, l_last_update_date, db_luby,
296: db_ludate, X_CUSTOM_MODE)) then
297:
298: UPDATE_ROW
299: (

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

342: where upper(hierarchy_key) = upper(X_HIERARCHY_KEY);
343:
344:
345: -- Translate owner to file_last_updated_by
346: f_luby := fnd_load_util.owner_id(X_OWNER);
347:
348: -- Translate char last_update_date to date
349: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD hh24:mi:ss'), sysdate);
350:

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

356: LANGUAGE = userenv('LANG')
357: and hierarchy_id = l_hierarchy_id;
358:
359: -- Test for customization and version
360: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
361: db_ludate,X_CUSTOM_MODE)) then
362:
363: UPDATE HR_KI_HIERARCHIES_TL
364: SET