DBA Data[Home] [Help]

APPS.FND_OAM_DOC_CATEGORY_TYPE_PKG dependencies on FND_OAM_DOC_CATEGORY_TYPE_PKG

Line 1: PACKAGE BODY fnd_oam_doc_category_type_pkg AS

1: PACKAGE BODY fnd_oam_doc_category_type_pkg AS
2: /* $Header: AFOAMDCTB.pls 120.2 2005/10/19 10:40:56 ilawler noship $ */
3: procedure LOAD_ROW (
4: X_CATEGORY_TYPE in VARCHAR2,
5: X_CATEGORY_TYPE_NAME in VARCHAR2,

Line 10: fnd_oam_doc_category_type_pkg.LOAD_ROW (

6: X_CATALOG_DOC_ID in VARCHAR2,
7: X_CATALOG_ATTCH_ID in VARCHAR2,
8: X_OWNER in VARCHAR2) is
9: begin
10: fnd_oam_doc_category_type_pkg.LOAD_ROW (
11: X_CATEGORY_TYPE => X_CATEGORY_TYPE,
12: X_CATEGORY_TYPE_NAME => X_CATEGORY_TYPE_NAME,
13: X_CATALOG_DOC_ID => X_CATALOG_DOC_ID,
14: X_CATALOG_ATTCH_ID => X_CATALOG_ATTCH_ID,

Line 57: fnd_oam_doc_category_type_pkg.UPDATE_ROW (

53: where category_type = X_CATEGORY_TYPE;
54:
55: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
56: db_ludate, X_CUSTOM_MODE)) then
57: fnd_oam_doc_category_type_pkg.UPDATE_ROW (
58: X_CATEGORY_TYPE => v_category_type,
59: X_CATEGORY_TYPE_NAME => X_CATEGORY_TYPE_NAME,
60: X_CATALOG_DOC_ID => X_CATALOG_DOC_ID,
61: X_CATALOG_ATTCH_ID => X_CATALOG_ATTCH_ID,

Line 69: fnd_oam_doc_category_type_pkg.INSERT_ROW (

65: end if;
66: exception
67: when NO_DATA_FOUND then
68:
69: fnd_oam_doc_category_type_pkg.INSERT_ROW (
70: X_ROWID => row_id,
71: X_CATEGORY_TYPE => X_CATEGORY_TYPE,
72: X_CATEGORY_TYPE_NAME => X_CATEGORY_TYPE_NAME,
73: X_CATALOG_DOC_ID => X_CATALOG_DOC_ID,

Line 162: END fnd_oam_doc_category_type_pkg;

158: raise no_data_found;
159: end if;
160: end DELETE_ROW;
161:
162: END fnd_oam_doc_category_type_pkg;