APPS.WSH_ITM_ASYN_MSGMAP_ASSISTANT dependencies on WSH_ITM_PARAMETER_SETUPS_B

Line 5: G_ITM_LOG_LEVEL WSH_ITM_PARAMETER_SETUPS_B.VALUE%TYPE;

1: PACKAGE BODY WSH_ITM_ASYN_MSGMAP_ASSISTANT AS
2: /* $Header: WSHITMAB.pls 120.2.12010000.4 2010/04/08 13:09:15 skanduku ship $ */
3: --
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_ITM_ASYN_MSGMAP_ASSISTANT';
5: G_ITM_LOG_LEVEL WSH_ITM_PARAMETER_SETUPS_B.VALUE%TYPE;
6: G_LOG_FILENAME VARCHAR2(100);
7: G_FILE_PTR UTL_FILE.File_Type;
8: G_REQ_CONTROL_ID VARCHAR(50); --Bug 9226895 changed from number
9: G_PRV_REQ_CONTROL_ID VARCHAR(50):= '-1';--Bug 9226895

Line 627: from WSH_ITM_PARAMETER_SETUPS_B

623: IF G_ITM_LOG_LEVEL IS NULL THEN
624: BEGIN
625: select value
626: into G_ITM_LOG_LEVEL
627: from WSH_ITM_PARAMETER_SETUPS_B
628: where parameter_name = 'WSH_ITM_LOG_SEVERITY';
629:
630: EXCEPTION
631: when no_data_found then