[Home] [Help]
PACKAGE: APPS.BIS_RSG_PUB_API_PKG
Source
1 PACKAGE bis_rsg_pub_api_pkg AS
2 /* $Header: BISRSGPS.pls 120.1 2005/09/16 06:22:40 amitgupt noship $ */
3 version CONSTANT VARCHAR (80)
4 := '$Header: BISRSGPS.pls 120.1 2005/09/16 06:22:40 amitgupt noship $';
5
6 PROCEDURE Create_Dependency (
7 P_OBJECT_TYPE in VARCHAR2,
8 P_OBJECT_OWNER in VARCHAR2,
9 P_OBJECT_NAME in VARCHAR2,
10 P_ENABLED_FLAG in VARCHAR2,
11 P_DEPEND_OBJECT_TYPE in VARCHAR2,
12 P_DEPEND_OBJECT_OWNER in VARCHAR2,
13 P_DEPEND_OBJECT_NAME in VARCHAR2,
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_msg_data OUT NOCOPY VARCHAR2
16 );
17
18 PROCEDURE Update_Dependency (
19 P_OBJECT_TYPE in VARCHAR2,
20 P_OBJECT_NAME in VARCHAR2,
21 P_ENABLED_FLAG in VARCHAR2,
22 P_DEPEND_OBJECT_TYPE in VARCHAR2,
23 P_DEPEND_OBJECT_NAME in VARCHAR2,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_data OUT NOCOPY VARCHAR2
26 ) ;
27
28 PROCEDURE Delete_Dependency (
29 P_OBJECT_TYPE in VARCHAR2,
30 P_OBJECT_NAME in VARCHAR2,
31 P_DEPEND_OBJECT_TYPE in VARCHAR2,
32 P_DEPEND_OBJECT_NAME in VARCHAR2,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_data OUT NOCOPY VARCHAR2
35 ) ;
36
37 --added for bug 4606455
38 PROCEDURE Delete_Dependency (
39 P_ROWID IN ROWID,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_data OUT NOCOPY VARCHAR2
42 ) ;
43
44 PROCEDURE Delete_Page_Dependencies (
45 P_OBJECT_NAME in VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_data OUT NOCOPY VARCHAR2
48 );
49
50 PROCEDURE Update_Property(
51 P_OBJECT_TYPE in VARCHAR2,
52 P_OBJECT_NAME in VARCHAR2,
53 P_DIMENSION_FLAG in VARCHAR2,
54 P_CUSTOM_API in VARCHAR2,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_data OUT NOCOPY VARCHAR2
57 ) ;
58
59 PROCEDURE Update_Property_Dim_Flag(
60 P_OBJECT_TYPE in VARCHAR2,
61 P_OBJECT_NAME in VARCHAR2,
62 P_DIMENSION_FLAG in VARCHAR2,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_data OUT NOCOPY VARCHAR2
65 ) ;
66
67 PROCEDURE Update_Property_Custom_API(
68 P_OBJECT_TYPE in VARCHAR2,
69 P_OBJECT_NAME in VARCHAR2,
70 P_CUSTOM_API in VARCHAR2,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_data OUT NOCOPY VARCHAR2
73 ) ;
74
75
76 PROCEDURE Create_Linkage (
77 P_OBJECT_TYPE in VARCHAR2,
78 P_OBJECT_OWNER in VARCHAR2,
79 P_OBJECT_NAME in VARCHAR2,
80 P_ENABLED_FLAG in VARCHAR2,
81 P_CONC_PROG_NAME in VARCHAR2,
82 P_APPL_SHORT_NAME in VARCHAR2,
83 P_REFRESH_MODE in VARCHAR2,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE Update_Linkage (
89 P_OBJECT_TYPE in VARCHAR2,
90 P_OBJECT_NAME in VARCHAR2,
91 P_ENABLED_FLAG in VARCHAR2,
92 P_CONC_PROG_NAME in VARCHAR2,
93 P_APPL_SHORT_NAME in VARCHAR2,
94 p_refresh_mode IN VARCHAR2,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_data OUT NOCOPY VARCHAR2
97 ) ;
98
99 PROCEDURE Update_Linkage_Enabled_Flag (
100 P_OBJECT_TYPE in VARCHAR2,
101 P_OBJECT_NAME in VARCHAR2,
102 P_ENABLED_FLAG in VARCHAR2,
103 P_CONC_PROG_NAME in VARCHAR2,
104 P_APPL_SHORT_NAME in VARCHAR2,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_data OUT NOCOPY VARCHAR2
107 ) ;
108
109 PROCEDURE Update_Linkage_Refresh_Mode (
110 P_OBJECT_TYPE in VARCHAR2,
111 P_OBJECT_NAME in VARCHAR2,
112 P_CONC_PROG_NAME in VARCHAR2,
113 P_APPL_SHORT_NAME in VARCHAR2,
114 p_refresh_mode IN VARCHAR2,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_data OUT NOCOPY VARCHAR2
117 ) ;
118
119 PROCEDURE Delete_Linkage (
120 P_OBJECT_TYPE in VARCHAR2,
121 P_OBJECT_NAME in VARCHAR2,
122 P_CONC_PROG_NAME in VARCHAR2,
123 P_APPL_SHORT_NAME in VARCHAR2,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_data OUT NOCOPY VARCHAR2
126 ) ;
127
128 --added for bug 4606455
129 PROCEDURE Delete_Linkage (
130 P_ROWID IN ROWID,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_data OUT NOCOPY VARCHAR2
133 ) ;
134
135 PROCEDURE Delete_Obj_Linkages (
136 P_OBJECT_TYPE in VARCHAR2,
137 P_OBJECT_NAME in VARCHAR2,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_data OUT NOCOPY VARCHAR2
140 ) ;
141
142
143 FUNCTION get_page_name_by_func (
144 p_func_name IN VARCHAR2) RETURN VARCHAR2;
145
146 -- for testing
147 PROCEDURE delete_property (
148 P_OBJECT_TYPE in VARCHAR2,
149 P_OBJECT_NAME in VARCHAR2
150 );
151
152 --begin: added for enhancement bug 3686273
153
154 TYPE t_BIA_RSG_Obj_Rec IS RECORD (object_name VARCHAR2(240),
155 user_object_name VARCHAR2(240),
156 object_owner VARCHAR2(50));
157
158 TYPE t_BIA_RSG_Obj_Table IS TABLE OF t_BIA_RSG_Obj_Rec INDEX BY BINARY_INTEGER;
159
160 -- retrieve all the ancestor objects for a given dependent object, considering both
161 -- enabled and disabled dependencies, so as to fix bug 3867557
162 FUNCTION GetParentObjects(P_DEP_OBJ_NAME IN VARCHAR2,
163 P_DEP_OBJ_TYPE IN VARCHAR2,
164 P_OBJ_TYPE IN VARCHAR2,
165 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
166 X_MSG_DATA OUT NOCOPY VARCHAR2
167 ) RETURN t_BIA_RSG_Obj_Table;
168
169
170 -- end: enhancement bug 3686273
171
172 -- begin: enhancement bug 3999642
173 procedure enable_index_mgmt(p_mv_name in varchar2, p_mv_schema in varchar2) ;
174
175 procedure disable_index_mgmt(p_mv_name in varchar2, p_mv_schema in varchar2) ;
176 -- end: enhancement bug 3999642
177
178 END bis_rsg_pub_api_pkg;