DBA Data[Home] [Help]

APPS.PER_CAGR_ENTITLEMENT_ITEMS_PKG dependencies on FND_LOAD_UTIL

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

321: X_BENEFICIAL_RULE_VALUE_SET_ID
322: );
323:
324: -- Translate owner to file_last_updated_by
325: f_luby := fnd_load_util.owner_id(x_owner);
326:
327: -- Translate char last_update_date to date
328: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
329: select LAST_UPDATED_BY, LAST_UPDATE_DATE

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

330: into db_luby, db_ludate
331: from PER_CAGR_ENTITLEMENT_ITEMS_TL
332: where CAGR_ENTITLEMENT_ITEM_ID = TO_NUMBER(X_CAGR_ENTITLEMENT_ITEM_ID)
333: and LANGUAGE=userenv('LANG');
334: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
335: db_ludate,X_CUSTOM_MODE)) then
336: update per_cagr_entitlement_items_tl set
337: item_name = X_ITEM_NAME,
338: last_update_date = f_ludate,

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

410: else
411: user_id := 0;
412: end if;
413:
414: f_luby := fnd_load_util.owner_id(X_OWNER);
415: -- Translate char last_update_date to date
416: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
417: select LAST_UPDATED_BY, LAST_UPDATE_DATE
418: into db_luby, db_ludate

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

419: from PER_CAGR_ENTITLEMENT_ITEMS
420: where CAGR_ENTITLEMENT_ITEM_ID = TO_NUMBER(X_CAGR_ENTITLEMENT_ITEM_ID);
421:
422: -- Test for customization and version
423: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
424: db_ludate, X_CUSTOM_MODE)) then
425: PER_CAGR_ENTITLEMENT_ITEMS_PKG.UPDATE_ROW (
426: X_CAGR_ENTITLEMENT_ITEM_ID => X_CAGR_ENTITLEMENT_ITEM_ID,
427: X_BUSINESS_GROUP_ID => X_BUSINESS_GROUP_ID,