[Home] [Help]
PACKAGE: APPS.BNE_CONTENT_UTILS
Source
1 PACKAGE BNE_CONTENT_UTILS AUTHID CURRENT_USER AS
2 /* $Header: bneconts.pls 120.3 2005/07/27 03:17:23 dagroves noship $ */
3 --------------------------------------------------------------------------------
4 -- PACKAGE: BNE_CONTENT_UTILS --
5 -- --
6 -- DESCRIPTION: --
7 -- --
8 -- MODIFICATION HISTORY --
9 -- Date Username Description --
10 -- 05-JUN-2002 KPEET Created. --
11 -- 04-NOV-2002 KPEET Added procedure ASSIGN_PARAM_LIST_TO_CONTENT --
12 -- 11-NOV-2002 KPEET Removed parameters P_PARAM_LIST_APP_ID and --
13 -- P_PARAM_LIST_CODE from procedure --
14 -- CREATE_CONTENT_TEXT. --
15 -- 27-JUL-2004 DAGROVES Added P_READ_ONLY_FLAG --
16 --------------------------------------------------------------------------------
17 PROCEDURE UPSERT_CONTENT_COL
18 (P_APPLICATION_ID IN NUMBER,
19 P_CONTENT_CODE IN VARCHAR2,
20 P_SEQUENCE_NUM IN NUMBER,
21 P_COL_NAME IN VARCHAR2,
22 P_LANGUAGE IN VARCHAR2,
23 P_SOURCE_LANGUAGE IN VARCHAR2,
24 P_DESCRIPTION IN VARCHAR2,
25 P_USER_ID IN NUMBER,
26 P_READ_ONLY_FLAG IN VARCHAR2 DEFAULT 'N');
27
28 PROCEDURE CREATE_CONTENT
29 (P_APPLICATION_ID IN NUMBER,
30 P_OBJECT_CODE IN VARCHAR2,
31 P_INTEGRATOR_CODE IN VARCHAR2,
32 P_DESCRIPTION IN VARCHAR2,
33 P_LANGUAGE IN VARCHAR2,
34 P_SOURCE_LANGUAGE IN VARCHAR2,
35 P_CONTENT_CLASS IN VARCHAR2,
36 P_USER_ID IN NUMBER,
37 P_CONTENT_CODE OUT NOCOPY VARCHAR2,
38 P_ONCE_ONLY_DOWNLOAD_FLAG IN VARCHAR2 DEFAULT 'N');
39
40 PROCEDURE CREATE_CONTENT_TEXT
41 (P_APPLICATION_ID IN NUMBER,
42 P_OBJECT_CODE IN VARCHAR2,
43 P_INTEGRATOR_CODE IN VARCHAR2,
44 P_CONTENT_DESC IN VARCHAR2,
45 P_NO_OF_COLS IN NUMBER,
46 P_COL_PREFIX IN VARCHAR2,
47 P_LANGUAGE IN VARCHAR2,
48 P_SOURCE_LANGUAGE IN VARCHAR2,
49 P_USER_ID IN NUMBER,
50 P_CONTENT_CODE OUT NOCOPY VARCHAR2);
51
52 PROCEDURE CREATE_CONTENT_STORED_SQL
53 (P_APPLICATION_ID IN NUMBER,
54 P_OBJECT_CODE IN VARCHAR2,
55 P_INTEGRATOR_CODE IN VARCHAR2,
56 P_CONTENT_DESC IN VARCHAR2,
57 P_COL_LIST IN VARCHAR2,
58 P_QUERY IN VARCHAR2,
59 P_LANGUAGE IN VARCHAR2,
60 P_SOURCE_LANGUAGE IN VARCHAR2,
61 P_USER_ID IN NUMBER,
62 P_CONTENT_CODE OUT NOCOPY VARCHAR2,
63 P_ONCE_ONLY_DOWNLOAD_FLAG IN VARCHAR2 DEFAULT 'N');
64
65 PROCEDURE CREATE_CONTENT_PASSED_SQL
66 (P_APPLICATION_ID IN NUMBER,
67 P_OBJECT_CODE IN VARCHAR2,
68 P_INTEGRATOR_CODE IN VARCHAR2,
69 P_CONTENT_DESC IN VARCHAR2,
70 P_COL_LIST IN VARCHAR2,
71 P_LANGUAGE IN VARCHAR2,
72 P_SOURCE_LANGUAGE IN VARCHAR2,
73 P_USER_ID IN NUMBER,
74 P_CONTENT_CODE OUT NOCOPY VARCHAR2,
75 P_ONCE_ONLY_DOWNLOAD_FLAG IN VARCHAR2 DEFAULT 'N');
76
77 PROCEDURE CREATE_CONTENT_DYNAMIC_SQL
78 (P_APPLICATION_ID IN NUMBER,
79 P_OBJECT_CODE IN VARCHAR2,
80 P_INTEGRATOR_CODE IN VARCHAR2,
81 P_CONTENT_DESC IN VARCHAR2,
82 P_CONTENT_CLASS IN VARCHAR2,
83 P_COL_LIST IN VARCHAR2,
84 P_LANGUAGE IN VARCHAR2,
85 P_SOURCE_LANGUAGE IN VARCHAR2,
86 P_USER_ID IN NUMBER,
87 P_CONTENT_CODE OUT NOCOPY VARCHAR2,
88 P_ONCE_ONLY_DOWNLOAD_FLAG IN VARCHAR2 DEFAULT 'N');
89
90 PROCEDURE CREATE_CONTENT_COLS_FROM_VIEW
91 (P_APPLICATION_ID IN NUMBER,
92 P_CONTENT_CODE IN VARCHAR2,
93 P_VIEW_NAME IN VARCHAR2,
94 P_LANGUAGE IN VARCHAR2,
95 P_SOURCE_LANGUAGE IN VARCHAR2,
96 P_USER_ID IN NUMBER);
97
98 PROCEDURE UPSERT_STORED_SQL_STATEMENT
99 (P_APPLICATION_ID IN NUMBER,
100 P_CONTENT_CODE IN VARCHAR2,
101 P_QUERY IN VARCHAR2,
102 P_USER_ID IN NUMBER);
103
104 PROCEDURE ENABLE_CONTENT_FOR_REPORTING
105 (P_APPLICATION_ID IN NUMBER,
106 P_OBJECT_CODE IN VARCHAR2,
107 P_INTEGRATOR_CODE IN VARCHAR2,
108 P_CONTENT_CODE IN VARCHAR2,
109 P_LANGUAGE IN VARCHAR2,
110 P_SOURCE_LANGUAGE IN VARCHAR2,
111 P_USER_ID IN NUMBER,
112 P_INTERFACE_CODE OUT NOCOPY VARCHAR2,
113 P_MAPPING_CODE OUT NOCOPY VARCHAR2);
114
115 PROCEDURE CREATE_REPORTING_MAPPING
116 (P_APPLICATION_ID IN NUMBER,
117 P_OBJECT_CODE IN VARCHAR2,
118 P_INTEGRATOR_CODE IN VARCHAR2,
119 P_CONTENT_CODE IN VARCHAR2,
120 P_INTERFACE_CODE IN VARCHAR2,
121 P_LANGUAGE IN VARCHAR2,
122 P_SOURCE_LANGUAGE IN VARCHAR2,
123 P_USER_ID IN NUMBER,
124 P_MAPPING_CODE OUT NOCOPY VARCHAR2);
125
126 PROCEDURE CREATE_CONTENT_TO_API_MAP
127 (P_APPLICATION_ID IN NUMBER,
128 P_OBJECT_CODE IN VARCHAR2,
129 P_INTEGRATOR_CODE IN VARCHAR2,
130 P_CONTENT_CODE IN VARCHAR2,
131 P_INTERFACE_CODE IN VARCHAR2,
132 P_LANGUAGE IN VARCHAR2,
133 P_SOURCE_LANGUAGE IN VARCHAR2,
134 P_USER_ID IN NUMBER,
135 P_MAPPING_CODE OUT NOCOPY VARCHAR2);
136
137 PROCEDURE ASSIGN_PARAM_LIST_TO_CONTENT
138 (P_CONTENT_APP_ID IN NUMBER,
139 P_CONTENT_CODE IN VARCHAR2,
140 P_PARAM_LIST_APP_ID IN NUMBER,
141 P_PARAM_LIST_CODE IN VARCHAR2);
142
143 END BNE_CONTENT_UTILS;