APPS.WSH_XC_UTIL dependencies on WSH_EXCEPTION_DEFINITIONS_VL

Line 24: DEFAULT_SEVERITY WSH_EXCEPTION_DEFINITIONS_VL.DEFAULT_SEVERITY%TYPE,

20: -- bug 5183769 : BEGIN
21: -- following types/variable are added to cache Exception Definitions
22:
23: TYPE Exception_Def_Rec_Typ IS RECORD(
24: DEFAULT_SEVERITY WSH_EXCEPTION_DEFINITIONS_VL.DEFAULT_SEVERITY%TYPE,
25: EXCEPTION_HANDLING WSH_EXCEPTION_DEFINITIONS_VL.EXCEPTION_HANDLING%TYPE,
26: INITIATE_WORKFLOW WSH_EXCEPTION_DEFINITIONS_VL.INITIATE_WORKFLOW%TYPE,
27: ENABLED WSH_EXCEPTION_DEFINITIONS_VL.ENABLED%TYPE
28: );

Line 25: EXCEPTION_HANDLING WSH_EXCEPTION_DEFINITIONS_VL.EXCEPTION_HANDLING%TYPE,

21: -- following types/variable are added to cache Exception Definitions
22:
23: TYPE Exception_Def_Rec_Typ IS RECORD(
24: DEFAULT_SEVERITY WSH_EXCEPTION_DEFINITIONS_VL.DEFAULT_SEVERITY%TYPE,
25: EXCEPTION_HANDLING WSH_EXCEPTION_DEFINITIONS_VL.EXCEPTION_HANDLING%TYPE,
26: INITIATE_WORKFLOW WSH_EXCEPTION_DEFINITIONS_VL.INITIATE_WORKFLOW%TYPE,
27: ENABLED WSH_EXCEPTION_DEFINITIONS_VL.ENABLED%TYPE
28: );
29:

Line 26: INITIATE_WORKFLOW WSH_EXCEPTION_DEFINITIONS_VL.INITIATE_WORKFLOW%TYPE,

22:
23: TYPE Exception_Def_Rec_Typ IS RECORD(
24: DEFAULT_SEVERITY WSH_EXCEPTION_DEFINITIONS_VL.DEFAULT_SEVERITY%TYPE,
25: EXCEPTION_HANDLING WSH_EXCEPTION_DEFINITIONS_VL.EXCEPTION_HANDLING%TYPE,
26: INITIATE_WORKFLOW WSH_EXCEPTION_DEFINITIONS_VL.INITIATE_WORKFLOW%TYPE,
27: ENABLED WSH_EXCEPTION_DEFINITIONS_VL.ENABLED%TYPE
28: );
29:
30: TYPE Exception_Def_Tab_Typ IS TABLE OF Exception_Def_Rec_Typ INDEX BY VARCHAR2(30);

Line 27: ENABLED WSH_EXCEPTION_DEFINITIONS_VL.ENABLED%TYPE

23: TYPE Exception_Def_Rec_Typ IS RECORD(
24: DEFAULT_SEVERITY WSH_EXCEPTION_DEFINITIONS_VL.DEFAULT_SEVERITY%TYPE,
25: EXCEPTION_HANDLING WSH_EXCEPTION_DEFINITIONS_VL.EXCEPTION_HANDLING%TYPE,
26: INITIATE_WORKFLOW WSH_EXCEPTION_DEFINITIONS_VL.INITIATE_WORKFLOW%TYPE,
27: ENABLED WSH_EXCEPTION_DEFINITIONS_VL.ENABLED%TYPE
28: );
29:
30: TYPE Exception_Def_Tab_Typ IS TABLE OF Exception_Def_Rec_Typ INDEX BY VARCHAR2(30);
31:

Line 59: FROM wsh_exception_definitions_vl

55: SELECT UPPER(default_severity),
56: UPPER(exception_handling),
57: UPPER(initiate_workflow),
58: enabled
59: FROM wsh_exception_definitions_vl
60: WHERE exception_name = c_exception_name;
61:
62: l_debug_on BOOLEAN;
63: l_msg_data VARCHAR(2000);

Line 1751: FROM wsh_exception_definitions_vl

1747:
1748: CURSOR C2(c_exception_id NUMBER) IS
1749: SELECT UPPER(default_severity), UPPER(exception_handling),
1750: UPPER(initiate_workflow)
1751: FROM wsh_exception_definitions_vl
1752: WHERE exception_name = (
1753: SELECT exception_name
1754: FROM wsh_exceptions
1755: WHERE exception_id = c_exception_id);

Line 1877: -- exception name not found in wsh_exception_definitions_vl

1873: l_new_status := 'NO_ACTION_REQUIRED';
1874: END IF;
1875:
1876: ELSE
1877: -- exception name not found in wsh_exception_definitions_vl
1878: CLOSE C2;
1879: RAISE WSH_XC_DATA_ERROR;
1880: END IF;
1881:

Line 2167: from wsh_exception_definitions_vl

2163: ) is
2164:
2165: cursor C1 (c_exception_name VARCHAR2) is
2166: select exception_name
2167: from wsh_exception_definitions_vl
2168: where exception_name = c_exception_name;
2169:
2170: cursor C2 (c_exception_definition_id NUMBER) is
2171: select ROWID from WSH_EXCEPTION_DEFINITIONS_B