APPS.FND_OAM_METALINK_DOCS_PKG dependencies on FND_OAM_METALINK_DOCS

Line 1: Package body FND_OAM_METALINK_DOCS_PKG as

1: Package body FND_OAM_METALINK_DOCS_PKG as
2: /* $Header: AFOAMMDB.pls 120.0 2005/08/05 01:05:37 appldev noship $ */
3: procedure LOAD_ROW(
4: X_DOC_ID in VARCHAR2,
5: X_TITLE in VARCHAR2,

Line 16: fnd_oam_metalink_docs_pkg.UPDATE_ROW(

12:
13: begin
14:
15:
16: fnd_oam_metalink_docs_pkg.UPDATE_ROW(
17: X_DOC_ID => X_DOC_ID,
18: X_TITLE => X_TITLE,
19: X_DOC_LAST_UPDATE_DATE => X_DOC_LAST_UPDATE_DATE,
20: X_CREATED_BY => X_CREATED_BY,

Line 28: fnd_oam_metalink_docs_pkg.INSERT_ROW(

24:
25: exception
26: when NO_DATA_FOUND then
27:
28: fnd_oam_metalink_docs_pkg.INSERT_ROW(
29: X_DOC_ID => X_DOC_ID,
30: X_TITLE => X_TITLE,
31: X_DOC_LAST_UPDATE_DATE => X_DOC_LAST_UPDATE_DATE,
32: X_CREATED_BY => X_CREATED_BY,

Line 55: select doc_id into db_id from FND_OAM_METALINK_DOCS

51:
52: db_id varchar2(40);
53: begin
54:
55: select doc_id into db_id from FND_OAM_METALINK_DOCS
56: where doc_id = X_DOC_ID;
57:
58: update FND_OAM_METALINK_DOCS SET
59: doc_id = X_DOC_ID,

Line 58: update FND_OAM_METALINK_DOCS SET

54:
55: select doc_id into db_id from FND_OAM_METALINK_DOCS
56: where doc_id = X_DOC_ID;
57:
58: update FND_OAM_METALINK_DOCS SET
59: doc_id = X_DOC_ID,
60: title = X_TITLE,
61: doc_last_update_date = X_DOC_LAST_UPDATE_DATE,
62: created_by = X_CREATED_BY,

Line 83: insert into FND_OAM_METALINK_DOCS (

79: X_LAST_UPDATE_LOGIN in NUMBER,
80: X_UPDATE_SUMMARY in CLOB) is
81:
82: begin
83: insert into FND_OAM_METALINK_DOCS (
84: doc_id,
85: title,
86: doc_last_update_date,
87: created_by,

Line 109: end FND_OAM_METALINK_DOCS_PKG;

105:
106: end INSERT_ROW;
107:
108:
109: end FND_OAM_METALINK_DOCS_PKG;