APPS.FND_OAM_DOC_CATEGORY_ASSOC_PKG dependencies on FND_OAM_DOC_CATEGORY_ASSOC

Line 1: package body FND_OAM_DOC_CATEGORY_ASSOC_PKG as

1: package body FND_OAM_DOC_CATEGORY_ASSOC_PKG as
2: /* $Header: AFOAMDCAB.pls 120.0 2005/08/05 01:05:16 appldev noship $ */
3: procedure LOAD_ROW(
4: X_CATEGORY_KEY in VARCHAR2,
5: X_CATEGORY_TYPE in VARCHAR2,

Line 14: fnd_oam_doc_category_assoc_pkg.UPDATE_ROW(

10: X_LAST_UPDATE_LOGIN in NUMBER) is
11: begin
12:
13: begin
14: fnd_oam_doc_category_assoc_pkg.UPDATE_ROW(
15: X_CATEGORY_KEY => X_CATEGORY_KEY,
16: X_CATEGORY_TYPE => X_CATEGORY_TYPE,
17: X_PARENT_CATEGORY_KEY => X_PARENT_CATEGORY_KEY,
18: X_PARENT_CATEGORY_TYPE => X_PARENT_CATEGORY_TYPE,

Line 26: fnd_oam_doc_category_assoc_pkg.INSERT_ROW(

22:
23: exception
24: when NO_DATA_FOUND then
25:
26: fnd_oam_doc_category_assoc_pkg.INSERT_ROW(
27: X_CATEGORY_KEY => X_CATEGORY_KEY,
28: X_CATEGORY_TYPE => X_CATEGORY_TYPE,
29: X_PARENT_CATEGORY_KEY => X_PARENT_CATEGORY_KEY,
30: X_PARENT_CATEGORY_TYPE => X_PARENT_CATEGORY_TYPE,

Line 56: select category_key into db_key from FND_OAM_DOC_CATEGORY_ASSOC

52:
53: db_key varchar2(40);
54: begin
55:
56: select category_key into db_key from FND_OAM_DOC_CATEGORY_ASSOC
57: where category_key = X_CATEGORY_KEY
58: and category_type = X_CATEGORY_TYPE
59: and parent_category_key = X_PARENT_CATEGORY_KEY
60: and parent_category_type = X_PARENT_CATEGORY_TYPE;

Line 63: update FND_OAM_DOC_CATEGORY_ASSOC SET

59: and parent_category_key = X_PARENT_CATEGORY_KEY
60: and parent_category_type = X_PARENT_CATEGORY_TYPE;
61:
62:
63: update FND_OAM_DOC_CATEGORY_ASSOC SET
64: category_key = X_CATEGORY_KEY,
65: category_type = X_CATEGORY_TYPE ,
66: parent_category_key = X_PARENT_CATEGORY_KEY,
67: parent_category_type = X_PARENT_CATEGORY_TYPE ,

Line 90: insert into FND_OAM_DOC_CATEGORY_ASSOC(

86: X_LAST_UPDATED_BY in NUMBER,
87: X_LAST_UPDATE_LOGIN in NUMBER) is
88:
89: begin
90: insert into FND_OAM_DOC_CATEGORY_ASSOC(
91: category_key,
92: category_type,
93: parent_category_key,
94: parent_category_type,

Line 114: end FND_OAM_DOC_CATEGORY_ASSOC_PKG;

110:
111: end INSERT_ROW;
112:
113:
114: end FND_OAM_DOC_CATEGORY_ASSOC_PKG;