APPS.WSH_ECE_VIEWS_DEF dependencies on WSH_ECE_VIEWS_DEF

Line 1: PACKAGE BODY WSH_ECE_VIEWS_DEF AS

1: PACKAGE BODY WSH_ECE_VIEWS_DEF AS
2: /* $Header: WSHECVWB.pls 120.0 2005/05/26 17:06:59 appldev noship $ */
3: --
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_ECE_VIEWS_DEF';
5: --

Line 4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_ECE_VIEWS_DEF';

1: PACKAGE BODY WSH_ECE_VIEWS_DEF AS
2: /* $Header: WSHECVWB.pls 120.0 2005/05/26 17:06:59 appldev noship $ */
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;

Line 41: WSH_ECE_VIEWS_DEF.cont_phone_number_x

37: contact.PHONE_AREA_CODE Area_Code,
38: contact.PHONE_NUMBER Phone_Number
39: INTO
40: cont_area_code_x,
41: WSH_ECE_VIEWS_DEF.cont_phone_number_x
42: FROM HZ_CONTACT_POINTS contact,
43: HZ_CUST_ACCOUNT_ROLES acct_roles
44: WHERE acct_roles.CUST_ACCOUNT_ROLE_ID = contact_id_in
45: AND contact.OWNER_TABLE_NAME = 'HZ_PARTIES'

Line 62: WSH_ECE_VIEWS_DEF.cont_phone_number_x := NULL;

58: --
59: return cont_area_code_x;
60:
61: EXCEPTION WHEN OTHERS THEN
62: WSH_ECE_VIEWS_DEF.cont_phone_number_x := NULL;
63: cont_area_code_x := NULL;
64: --
65: -- Debug Statements
66: --

Line 112: return WSH_ECE_VIEWS_DEF.cont_phone_number_x;

108: IF l_debug_on THEN
109: WSH_DEBUG_SV.pop(l_module_name);
110: END IF;
111: --
112: return WSH_ECE_VIEWS_DEF.cont_phone_number_x;
113: END;
114:
115: FUNCTION get_cust_area_code(customer_id_in NUMBER) return VARCHAR2 IS
116: cust_area_code_x VARCHAR2(10);

Line 160: FETCH l_cust_ph_num_csr INTO cust_area_code_x, WSH_ECE_VIEWS_DEF.cust_phone_number_x, l_cust_acct_site_id;

156: WSH_DEBUG_SV.log(l_module_name,'CUSTOMER_ID_IN',CUSTOMER_ID_IN);
157: END IF;
158: --
159: OPEN l_cust_ph_num_csr(customer_id_in);
160: FETCH l_cust_ph_num_csr INTO cust_area_code_x, WSH_ECE_VIEWS_DEF.cust_phone_number_x, l_cust_acct_site_id;
161: CLOSE l_cust_ph_num_csr;
162: --
163: -- Debug Statements
164: --

Line 167: WSH_DEBUG_SV.log(l_module_name,'phone_number',WSH_ECE_VIEWS_DEF.cust_phone_number_x);

163: -- Debug Statements
164: --
165: IF l_debug_on THEN
166: WSH_DEBUG_SV.log(l_module_name,'cust_area_code_x',cust_area_code_x);
167: WSH_DEBUG_SV.log(l_module_name,'phone_number',WSH_ECE_VIEWS_DEF.cust_phone_number_x);
168: WSH_DEBUG_SV.pop(l_module_name);
169: END IF;
170: --
171: return cust_area_code_x;

Line 174: WSH_ECE_VIEWS_DEF.cust_phone_number_x := NULL;

170: --
171: return cust_area_code_x;
172:
173: EXCEPTION WHEN OTHERS THEN
174: WSH_ECE_VIEWS_DEF.cust_phone_number_x := NULL;
175: cust_area_code_x := NULL;
176: --
177: -- Debug Statements
178: --

Line 223: return WSH_ECE_VIEWS_DEF.cust_phone_number_x;

219: IF l_debug_on THEN
220: WSH_DEBUG_SV.pop(l_module_name);
221: END IF;
222: --
223: return WSH_ECE_VIEWS_DEF.cust_phone_number_x;
224: END;
225:
226:
227: PROCEDURE get_invoice_number(p_delivery_id IN NUMBER,

Line 740: x_area_code := wsh_ece_views_def.get_cust_area_code(l_customer_id);

736: x_area_code := NULL;
737: x_phone_number := NULL;
738:
739: ELSE
740: x_area_code := wsh_ece_views_def.get_cust_area_code(l_customer_id);
741: x_phone_number := wsh_ece_views_def.get_cust_phone_number;
742: END IF;
743:
744: ELSE

Line 741: x_phone_number := wsh_ece_views_def.get_cust_phone_number;

737: x_phone_number := NULL;
738:
739: ELSE
740: x_area_code := wsh_ece_views_def.get_cust_area_code(l_customer_id);
741: x_phone_number := wsh_ece_views_def.get_cust_phone_number;
742: END IF;
743:
744: ELSE
745: x_location := NULL;