APPS.FND_OAM_DOC_CATEGORY_PKG dependencies on FND_OAM_DOC_CATEGORY

Line 1: package body FND_OAM_DOC_CATEGORY_PKG as

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

Line 12: fnd_oam_doc_category_pkg.UPDATE_ROW(

8: X_LAST_UPDATED_BY in NUMBER,
9: X_LAST_UPDATE_LOGIN in NUMBER) is
10: begin
11: begin
12: fnd_oam_doc_category_pkg.UPDATE_ROW(
13: X_CATEGORY_KEY => X_CATEGORY_KEY,
14: X_CATEGORY_TYPE => X_CATEGORY_TYPE,
15: X_CATEGORY_NAME => X_CATEGORY_NAME,
16: X_CREATED_BY => X_CREATED_BY,

Line 23: fnd_oam_doc_category_pkg.INSERT_ROW(

19:
20: exception
21: when NO_DATA_FOUND then
22:
23: fnd_oam_doc_category_pkg.INSERT_ROW(
24: X_CATEGORY_KEY => X_CATEGORY_KEY,
25: X_CATEGORY_TYPE => X_CATEGORY_TYPE,
26: X_CATEGORY_NAME => X_CATEGORY_NAME,
27: X_CREATED_BY => X_CREATED_BY,

Line 49: select category_key into db_key from FND_OAM_DOC_CATEGORY

45:
46: db_key varchar2(40);
47: begin
48:
49: select category_key into db_key from FND_OAM_DOC_CATEGORY
50: where category_key = X_CATEGORY_KEY
51: and category_type = X_CATEGORY_TYPE ;
52:
53: update FND_OAM_DOC_CATEGORY SET

Line 53: update FND_OAM_DOC_CATEGORY SET

49: select category_key into db_key from FND_OAM_DOC_CATEGORY
50: where category_key = X_CATEGORY_KEY
51: and category_type = X_CATEGORY_TYPE ;
52:
53: update FND_OAM_DOC_CATEGORY SET
54: category_key = X_CATEGORY_KEY,
55: category_type = X_CATEGORY_TYPE ,
56: category_name = X_CATEGORY_NAME,
57: created_by = X_CREATED_BY,

Line 75: insert into FND_OAM_DOC_CATEGORY(

71: X_LAST_UPDATED_BY in NUMBER,
72: X_LAST_UPDATE_LOGIN in NUMBER) is
73:
74: begin
75: insert into FND_OAM_DOC_CATEGORY(
76: category_key,
77: category_type,
78: category_name,
79: created_by,

Line 97: end FND_OAM_DOC_CATEGORY_PKG;

93:
94: end INSERT_ROW;
95:
96:
97: end FND_OAM_DOC_CATEGORY_PKG;