APPS.JTM_CON_QUERY_REQUEST_PKG dependencies on JTM_CON_QUERY_REQUEST_PKG

Line 1: PACKAGE BODY JTM_CON_QUERY_REQUEST_PKG AS

1: PACKAGE BODY JTM_CON_QUERY_REQUEST_PKG AS
2: /* $Header: jtmconqb.pls 120.3 2006/01/13 03:20:18 trajasek noship $ */
3:
4: /*** Globals ***/
5: G_PACKAGE_NAME constant VARCHAR2(30) := 'JTM_CON_QUERY_REQUEST_PKG';

Line 5: G_PACKAGE_NAME constant VARCHAR2(30) := 'JTM_CON_QUERY_REQUEST_PKG';

1: PACKAGE BODY JTM_CON_QUERY_REQUEST_PKG AS
2: /* $Header: jtmconqb.pls 120.3 2006/01/13 03:20:18 trajasek noship $ */
3:
4: /*** Globals ***/
5: G_PACKAGE_NAME constant VARCHAR2(30) := 'JTM_CON_QUERY_REQUEST_PKG';
6: g_debug_level NUMBER; -- debug level
7: g_category varchar2(30);
8:
9: /*** cursor retrieving query request properties ***/

Line 455: WHERE upper(package_name) = 'JTM_CON_QUERY_REQUEST_PKG'

451: BEGIN
452: SELECT category
453: INTO l_category
454: FROM jtm_con_request_data
455: WHERE upper(package_name) = 'JTM_CON_QUERY_REQUEST_PKG'
456: AND upper(procedure_name) = 'RUN_QUERY_REQUESTS';
457:
458: return l_category;
459: EXCEPTION

Line 1512: END JTM_CON_QUERY_REQUEST_PKG;

1508: END IF;
1509:
1510: END RUN_QUERY_REQUESTS;
1511:
1512: END JTM_CON_QUERY_REQUEST_PKG;