APPS.FND_OAM_METALINK_DOC_ASSOC_PKG dependencies on FND_OAM_METALINK_DOC_ASSOC

Line 1: package body FND_OAM_METALINK_DOC_ASSOC_PKG as

1: package body FND_OAM_METALINK_DOC_ASSOC_PKG as
2: /* $Header: AFOAMMDAB.pls 120.0 2005/08/05 01:05:30 appldev noship $ */
3: procedure LOAD_ROW(
4: X_DOC_ID in VARCHAR2,
5: X_CATEGORY_KEY in VARCHAR2,

Line 14: fnd_oam_metalink_doc_assoc_pkg.UPDATE_ROW(

10: X_ANCHOR in VARCHAR2) is
11: begin
12:
13: begin
14: fnd_oam_metalink_doc_assoc_pkg.UPDATE_ROW(
15: X_DOC_ID => X_DOC_ID,
16: X_CATEGORY_KEY => X_CATEGORY_KEY,
17: X_CATEGORY_TYPE => X_CATEGORY_TYPE,
18: X_CREATED_BY => X_CREATED_BY,

Line 26: fnd_oam_metalink_doc_assoc_pkg.INSERT_ROW(

22:
23: exception
24: when NO_DATA_FOUND then
25:
26: fnd_oam_metalink_doc_assoc_pkg.INSERT_ROW(
27: X_DOC_ID => X_DOC_ID,
28: X_CATEGORY_KEY => X_CATEGORY_KEY,
29: X_CATEGORY_TYPE => X_CATEGORY_TYPE,
30: X_CREATED_BY => X_CREATED_BY,

Line 56: select doc_id into db_id from FND_OAM_METALINK_DOC_ASSOC

52:
53: db_id varchar2(40);
54: begin
55:
56: select doc_id into db_id from FND_OAM_METALINK_DOC_ASSOC
57: where doc_id = X_DOC_ID
58: and category_key = X_CATEGORY_KEY
59: and category_type = X_CATEGORY_TYPE ;
60:

Line 61: update FND_OAM_METALINK_DOC_ASSOC SET

57: where doc_id = X_DOC_ID
58: and category_key = X_CATEGORY_KEY
59: and category_type = X_CATEGORY_TYPE ;
60:
61: update FND_OAM_METALINK_DOC_ASSOC SET
62: doc_id = X_DOC_ID,
63: category_key = X_CATEGORY_KEY,
64: category_TYPE = X_CATEGORY_TYPE,
65: created_by = X_CREATED_BY,

Line 87: insert into FND_OAM_METALINK_DOC_ASSOC (

83: X_LAST_UPDATE_LOGIN in NUMBER,
84: X_ANCHOR in VARCHAR2 ) is
85:
86: begin
87: insert into FND_OAM_METALINK_DOC_ASSOC (
88: doc_id,
89: category_key,
90: category_type,
91: created_by,

Line 110: end FND_OAM_METALINK_DOC_ASSOC_PKG;

106: X_ANCHOR);
107:
108: end INSERT_ROW;
109:
110: end FND_OAM_METALINK_DOC_ASSOC_PKG;