APPS.FND_OAM_DSCFG_PROCS_PKG dependencies on FND_OAM_DSCFG_PROCS

Line 1: PACKAGE BODY FND_OAM_DSCFG_PROCS_PKG as

1: PACKAGE BODY FND_OAM_DSCFG_PROCS_PKG as
2: /* $Header: AFOAMDSCPROCB.pls 120.1 2005/11/23 17:03 yawu noship $ */
3:
4: ----------------------------------------
5: -- Private Body Constants

Line 14: FROM fnd_oam_dscfg_procs P

10: -- cause both to fail iteration.
11: CURSOR B_PROCS(p_stage VARCHAR2)
12: IS
13: SELECT /*+ FIRST_ROWS(1) */ P.proc_id, P.proc_type, P.error_is_fatal_flag, P.location, P.executable
14: FROM fnd_oam_dscfg_procs P
15: WHERE P.STAGE = p_stage
16: AND SYSDATE BETWEEN NVL(P.START_DATE, SYSDATE) and NVL(P.END_DATE, SYSDATE)
17: ORDER BY P.priority ASC, P.proc_id ASC;
18:

Line 210: FROM fnd_oam_dscfg_procs

206:
207: --query out the import proc attributes
208: SELECT proc_id, proc_type, error_is_fatal_flag, location, executable
209: INTO l_proc_id, l_proc_type, l_error_is_fatal_flag, l_location, l_executable
210: FROM fnd_oam_dscfg_procs
211: WHERE proc_id = p_proc_id
212: AND SYSDATE BETWEEN NVL(START_DATE, SYSDATE) and NVL(END_DATE, SYSDATE);
213:
214: --set the state

Line 267: from fnd_oam_dscfg_procs

263: begin
264: -- check if this PROCS id already exists.
265: select proc_id, LAST_UPDATED_BY, LAST_UPDATE_DATE
266: into mproc_id, db_luby, db_ludate
267: from fnd_oam_dscfg_procs
268: where proc_id = to_number(X_PROC_ID);
269:
270: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
271: db_ludate, X_CUSTOM_MODE)) then

Line 272: FND_OAM_DSCFG_PROCS_PKG.UPDATE_ROW (

268: where proc_id = to_number(X_PROC_ID);
269:
270: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
271: db_ludate, X_CUSTOM_MODE)) then
272: FND_OAM_DSCFG_PROCS_PKG.UPDATE_ROW (
273: X_PROC_ID => mproc_id,
274: X_PROC_TYPE => X_PROC_TYPE,
275: X_STAGE => X_STAGE,
276: X_START_DATE => X_START_DATE,

Line 290: FND_OAM_DSCFG_PROCS_PKG.INSERT_ROW (

286: end if;
287: exception
288: when NO_DATA_FOUND then
289:
290: FND_OAM_DSCFG_PROCS_PKG.INSERT_ROW (
291: X_ROWID => row_id,
292: X_PROC_ID => X_PROC_ID,
293: X_PROC_TYPE => X_PROC_TYPE,
294: X_STAGE => X_STAGE,

Line 328: cursor C is select ROWID from FND_OAM_DSCFG_PROCS

324: X_LAST_UPDATED_BY in NUMBER,
325: X_LAST_UPDATE_DATE in DATE,
326: X_LAST_UPDATE_LOGIN in NUMBER)
327: is
328: cursor C is select ROWID from FND_OAM_DSCFG_PROCS
329: where PROC_ID = X_PROC_ID;
330: begin
331: insert into FND_OAM_DSCFG_PROCS (
332: PROC_ID,

Line 331: insert into FND_OAM_DSCFG_PROCS (

327: is
328: cursor C is select ROWID from FND_OAM_DSCFG_PROCS
329: where PROC_ID = X_PROC_ID;
330: begin
331: insert into FND_OAM_DSCFG_PROCS (
332: PROC_ID,
333: PROC_TYPE,
334: STAGE,
335: START_DATE,

Line 407: from FND_OAM_DSCFG_PROCS

403: CREATION_DATE,
404: LAST_UPDATED_BY,
405: LAST_UPDATE_DATE,
406: LAST_UPDATE_LOGIN
407: from FND_OAM_DSCFG_PROCS
408: where PROC_ID = X_PROC_ID
409: for update of PROC_ID nowait;
410: recinfo c%rowtype;
411:

Line 464: update FND_OAM_DSCFG_PROCS set

460: X_LAST_UPDATE_DATE in DATE,
461: X_LAST_UPDATE_LOGIN in NUMBER
462: ) is
463: begin
464: update FND_OAM_DSCFG_PROCS set
465: PROC_TYPE = X_PROC_TYPE,
466: STAGE = X_STAGE,
467: START_DATE = X_START_DATE,
468: END_DATE = X_END_DATE,

Line 488: delete from FND_OAM_DSCFG_PROCS

484: procedure DELETE_ROW (
485: X_PROC_ID in NUMBER
486: ) is
487: begin
488: delete from FND_OAM_DSCFG_PROCS
489: where PROC_ID = X_PROC_ID;
490:
491: if (sql%notfound) then
492: raise no_data_found;

Line 499: END FND_OAM_DSCFG_PROCS_PKG;

495: end DELETE_ROW;
496:
497:
498:
499: END FND_OAM_DSCFG_PROCS_PKG;