APPS.WSH_ECE_VIEWS_DEF dependencies on WSH_UTIL_CORE

Line 7: G_PAYMENT_TERM_TBL wsh_util_core.char500_tab_type;

3: --
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_ECE_VIEWS_DEF';
5: --
6: --FP Bug 3989208
7: G_PAYMENT_TERM_TBL wsh_util_core.char500_tab_type;
8: G_PAYMENT_TERM_EXT_TBL wsh_util_core.char500_tab_type;
9: --
10: FUNCTION get_cont_area_code(contact_id_in NUMBER) return VARCHAR2 IS
11: cont_area_code_x VARCHAR2(10);

Line 8: G_PAYMENT_TERM_EXT_TBL wsh_util_core.char500_tab_type;

4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_ECE_VIEWS_DEF';
5: --
6: --FP Bug 3989208
7: G_PAYMENT_TERM_TBL wsh_util_core.char500_tab_type;
8: G_PAYMENT_TERM_EXT_TBL wsh_util_core.char500_tab_type;
9: --
10: FUNCTION get_cont_area_code(contact_id_in NUMBER) return VARCHAR2 IS
11: cont_area_code_x VARCHAR2(10);
12: --

Line 394: wsh_util_core.get_cached_value(

390: ELSE
391: --Bug 3989208
392: --Cache the payment_term_id and payment_term_name
393:
394: wsh_util_core.get_cached_value(
395: p_cache_tbl => g_payment_term_tbl,
396: p_cache_ext_tbl => g_payment_term_ext_tbl,
397: p_value => l_payment_term_name,
398: p_key => p_payment_term_id,

Line 407: IF l_return_status = wsh_util_core.g_ret_sts_warning

403: wsh_debug_sv.log(l_module_name, 'Cached l_payment_term_name', l_payment_term_name);
404: wsh_debug_sv.log(l_module_name, 'Get l_return_status', l_return_status);
405: END IF;
406:
407: IF l_return_status = wsh_util_core.g_ret_sts_warning
408: THEN
409:
410: OPEN c_cust_payment_term;
411: FETCH c_cust_payment_term into l_payment_term_name;

Line 424: wsh_util_core.get_cached_value(

420:
421: --Bug 3989208
422: --Cache the payment_term_id and payment_term_name
423:
424: wsh_util_core.get_cached_value(
425: p_cache_tbl => g_payment_term_tbl,
426: p_cache_ext_tbl => g_payment_term_ext_tbl,
427: p_value => l_payment_term_name,
428: p_key => p_payment_term_id,

Line 616: x_location_code := wsh_util_core.get_location_description (

612:
613: BEGIN
614:
615: IF p_location_id IS NOT NULL THEN
616: x_location_code := wsh_util_core.get_location_description (
617: p_location_id => p_location_id,
618: p_format => 'CODE');
619: ELSE
620: x_location_code := NULL;