1: PACKAGE bis_business_views_catalog AUTHID CURRENT_USER AS
2: /* $Header: BISPBVCS.pls 115.3 99/09/17 19:17:08 porting ship $ */
3: --Constants declarations
4: c_title CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_TITLE');
5: c_submit CONSTANT varchar2(100) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_SEARCH_BUTTON');
6: c_busarea CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_BUSINESS_AREA');
7: c_folder CONSTANT varchar2(80) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_FOLDER');
8: c_desc CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_DESCRIPTION');
1: PACKAGE bis_business_views_catalog AUTHID CURRENT_USER AS
2: /* $Header: BISPBVCS.pls 115.3 99/09/17 19:17:08 porting ship $ */
3: --Constants declarations
4: c_title CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_TITLE');
5: c_submit CONSTANT varchar2(100) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_SEARCH_BUTTON');
6: c_busarea CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_BUSINESS_AREA');
7: c_folder CONSTANT varchar2(80) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_FOLDER');
8: c_desc CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_DESCRIPTION');
9:
2: /* $Header: BISPBVCS.pls 115.3 99/09/17 19:17:08 porting ship $ */
3: --Constants declarations
4: c_title CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_TITLE');
5: c_submit CONSTANT varchar2(100) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_SEARCH_BUTTON');
6: c_busarea CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_BUSINESS_AREA');
7: c_folder CONSTANT varchar2(80) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_FOLDER');
8: c_desc CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_DESCRIPTION');
9:
10: C_MAX_HITS CONSTANT PLS_INTEGER := 200; -- To be used in case I need to stop searching after this
3: --Constants declarations
4: c_title CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_TITLE');
5: c_submit CONSTANT varchar2(100) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_SEARCH_BUTTON');
6: c_busarea CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_BUSINESS_AREA');
7: c_folder CONSTANT varchar2(80) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_FOLDER');
8: c_desc CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_DESCRIPTION');
9:
10: C_MAX_HITS CONSTANT PLS_INTEGER := 200; -- To be used in case I need to stop searching after this
11: C_ROW_COUNT CONSTANT PLS_INTEGER := 40; -- To be used in case I need to show only so many at a time
4: c_title CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_TITLE');
5: c_submit CONSTANT varchar2(100) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_SEARCH_BUTTON');
6: c_busarea CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_BUSINESS_AREA');
7: c_folder CONSTANT varchar2(80) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_FOLDER');
8: c_desc CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_DESCRIPTION');
9:
10: C_MAX_HITS CONSTANT PLS_INTEGER := 200; -- To be used in case I need to stop searching after this
11: C_ROW_COUNT CONSTANT PLS_INTEGER := 40; -- To be used in case I need to show only so many at a time
12: