APPS.FND_OAM_DS_ALGOS_PKG dependencies on FND_OAM_DS_ALGOS_B

Line 149: FROM fnd_oam_ds_algos_b

145: --fetch attributes corresponding to the current algo id
146: BEGIN
147: SELECT use_algo_id, datatype, algo_text, weight_modifier
148: INTO l_use_algo_id, l_datatype, l_raw_algo_text, l_weight_modifier
149: FROM fnd_oam_ds_algos_b
150: WHERE algo_id = l_current_algo_id
151: AND SYSDATE BETWEEN NVL(START_DATE, SYSDATE) AND NVL(END_DATE, SYSDATE);
152: EXCEPTION
153: WHEN NO_DATA_FOUND THEN

Line 227: FROM fnd_oam_ds_algos_b

223: --do the query, automatically throws NO_DATA_FOUND/TOO_MANY_ROWS if less than or greater than one row
224: BEGIN
225: SELECT algo_id
226: INTO l_id
227: FROM fnd_oam_ds_algos_b
228: WHERE datatype = p_datatype
229: AND default_for_datatype_flag = FND_API.G_TRUE;
230:
231: --cache the result

Line 325: from fnd_oam_ds_algos_b

321: begin
322: -- check if this algorithm id already exists.
323: select algo_id, LAST_UPDATED_BY, LAST_UPDATE_DATE
324: into malgo_id, db_luby, db_ludate
325: from fnd_oam_ds_algos_b
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

Line 458: cursor C is select ROWID from FND_OAM_DS_ALGOS_B

454: X_LAST_UPDATED_BY in NUMBER,
455: X_LAST_UPDATE_DATE in DATE,
456: X_LAST_UPDATE_LOGIN in NUMBER)
457: is
458: cursor C is select ROWID from FND_OAM_DS_ALGOS_B
459: where ALGO_ID = X_ALGO_ID;
460: begin
461: insert into FND_OAM_DS_ALGOS_B (
462: ALGO_ID,

Line 461: insert into FND_OAM_DS_ALGOS_B (

457: is
458: cursor C is select ROWID from FND_OAM_DS_ALGOS_B
459: where ALGO_ID = X_ALGO_ID;
460: begin
461: insert into FND_OAM_DS_ALGOS_B (
462: ALGO_ID,
463: START_DATE,
464: END_DATE,
465: USE_ALGO_ID,

Line 565: from FND_OAM_DS_ALGOS_B

561: CREATION_DATE,
562: LAST_UPDATED_BY,
563: LAST_UPDATE_DATE,
564: LAST_UPDATE_LOGIN
565: from FND_OAM_DS_ALGOS_B
566: where ALGO_ID = X_ALGO_ID
567: for update of ALGO_ID nowait;
568: recinfo c%rowtype;
569:

Line 642: update FND_OAM_DS_ALGOS_B set

638: X_LAST_UPDATE_DATE in DATE,
639: X_LAST_UPDATE_LOGIN in NUMBER
640: ) is
641: begin
642: update FND_OAM_DS_ALGOS_B set
643: START_DATE = X_START_DATE,
644: END_DATE = X_END_DATE,
645: USE_ALGO_ID = X_USE_ALGO_ID,
646: DEFAULT_FOR_DATATYPE_FLAG = X_DEFAULT_FOR_DATATYPE_FLAG,

Line 688: delete from FND_OAM_DS_ALGOS_B

684: if (sql%notfound) then
685: raise no_data_found;
686: end if;
687:
688: delete from FND_OAM_DS_ALGOS_B
689: where ALGO_ID = X_ALGO_ID;
690:
691: if (sql%notfound) then
692: raise no_data_found;

Line 705: from FND_OAM_DS_ALGOS_B B

701: begin
702: delete from FND_OAM_DS_ALGOS_TL T
703: where not exists
704: (select NULL
705: from FND_OAM_DS_ALGOS_B B
706: where B.ALGO_ID = T.ALGO_ID
707: );
708:
709: update FND_OAM_DS_ALGOS_TL T set (