1: PACKAGE BODY FND_OAM_DS_ALGOS_PKG as
2: /* $Header: AFOAMDSALGOB.pls 120.3 2006/01/17 11:43 ilawler noship $ */
3:
4: ----------------------------------------
5: -- Private Body Constants
271: X_DISPLAY_NAME IN VARCHAR2,
272: X_DESCRIPTION IN VARCHAR2) IS
273: begin
274:
275: FND_OAM_DS_ALGOS_PKG.LOAD_ROW (
276: X_ALGO_ID => X_ALGO_ID,
277: X_START_DATE => X_START_DATE,
278: X_END_DATE => X_END_DATE,
279: X_USE_ALGO_ID => X_USE_ALGO_ID,
326: where algo_id = to_number(X_ALGO_ID);
327:
328: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
329: db_ludate, X_CUSTOM_MODE)) then
330: FND_OAM_DS_ALGOS_PKG.UPDATE_ROW (
331: X_ALGO_ID => malgo_id,
332: X_START_DATE => X_START_DATE,
333: X_END_DATE => X_END_DATE,
334: X_USE_ALGO_ID => X_USE_ALGO_ID,
345: end if;
346: exception
347: when NO_DATA_FOUND then
348:
349: FND_OAM_DS_ALGOS_PKG.INSERT_ROW (
350: X_ROWID => row_id,
351: X_ALGO_ID => X_ALGO_ID,
352: X_START_DATE => X_START_DATE,
353: X_END_DATE => X_END_DATE,
376: X_OWNER in VARCHAR2)
377: is
378: begin
379:
380: FND_OAM_DS_ALGOS_PKG.translate_row(
381: X_ALGO_ID => X_ALGO_ID,
382: X_DISPLAY_NAME => X_DISPLAY_NAME,
383: X_DESCRIPTION => X_DESCRIPTION,
384: X_OWNER => X_OWNER,
790:
791: end TRANSLATE_ROW;
792: --END OF PROCEDURES REQUIRED BY FNDLOADER.
793:
794: END FND_OAM_DS_ALGOS_PKG;