DBA Data[Home] [Help]

APPS.BIS_RSG_PUB_APIS_PKG dependencies on BIS_REQUEST_SET_OBJECTS

Line 173: select object_name,object_type from bis_request_set_objects

169: Procedure Get_content_in_RS( p_req_set_name IN varchar2, p_content_list OUT NOCOPY BIS_RSG_CONTENT_LIST,
170: p_content_type IN VARCHAR2,errbuf out NOCOPY varchar2,
171: errcode out NOCOPY varchar2) IS
172: CURSOR CV (rs_name IN varchar2) IS
173: select object_name,object_type from bis_request_set_objects
174: where request_set_name = upper(rs_name) and set_app_id = 191;
175:
176: CURSOR CV_TYPE (rs_name in varchar2, con_type in varchar2) IS
177: select object_name,object_type from bis_request_set_objects

Line 177: select object_name,object_type from bis_request_set_objects

173: select object_name,object_type from bis_request_set_objects
174: where request_set_name = upper(rs_name) and set_app_id = 191;
175:
176: CURSOR CV_TYPE (rs_name in varchar2, con_type in varchar2) IS
177: select object_name,object_type from bis_request_set_objects
178: where request_set_name = upper(rs_name) and object_type = con_type and set_app_id = 191;
179: i number;
180: BEGIN
181: i := 0;