15:
16: --for a session id returns the Numeric configuration parameter value
17: --for the provided parameter name
18: --from ego_pub_ws_config table - For List mode
19: --from ego_pub_bat_params_b table - For Batch mode
20:
21: FUNCTION Get_Numeric_Param_Value( p_session_id IN NUMBER,
22: p_param_name IN VARCHAR2,
23: p_batch_id IN NUMBER DEFAULT NULL,
39: AND SESSION_ID = p_session_id;
40: ELSIF l_mode = 'BATCH' THEN
41: SELECT NUMERIC_VALUE
42: INTO x_param_value
43: FROM EGO_PUB_BAT_PARAMS_B
44: WHERE PARAMETER_NAME = l_param_name
45: AND DATA_TYPE = 1
46: AND TYPE_ID = l_batch_id;
47: END IF;
52:
53: --for a session id returns the char configuration parameter value
54: --for the provided parameter name
55: --from ego_pub_ws_config table - For List mode
56: --from ego_pub_bat_params_b table - For Batch mode
57:
58:
59: FUNCTION Get_Char_Param_Value(p_session_id IN NUMBER,
60: p_param_name IN VARCHAR2,
78:
79: IF l_mode = 'BATCH' THEN
80: SELECT CHAR_VALUE
81: INTO x_param_value
82: FROM EGO_PUB_BAT_PARAMS_B
83: WHERE PARAMETER_NAME = l_param_name
84: AND DATA_TYPE = 2
85: AND TYPE_ID = l_batch_id;
86: ELSE
97:
98: --for a session id returns the date configuration parameter value
99: --for the provided parameter name
100: --from ego_pub_ws_config table - For List mode
101: --from ego_pub_bat_params_b table - For Batch mode
102:
103:
104: FUNCTION Get_Char_Date_Value( p_session_id IN NUMBER,
105: p_param_name IN VARCHAR2,
123: AND SESSION_ID = p_session_id;
124: ELSIF l_mode = 'BATCH' THEN
125: SELECT DATE_VALUE
126: INTO x_param_value
127: FROM EGO_PUB_BAT_PARAMS_B
128: WHERE PARAMETER_NAME = l_param_name
129: AND DATA_TYPE = 3
130: AND TYPE_ID = l_batch_id;
131: END IF;