APPS.WSH_ITM_UTIL dependencies on WSH_ITM_VENDORS

Line 38: vendor_id WSH_ITM_VENDORS.VENDOR_ID%TYPE := 0;

34: IS
35: priority NUMBER := 0;
36: service_tbl Service_Tbl_Type;
37: G_MISS_SERVICE_TBL Service_Tbl_Type;
38: vendor_id WSH_ITM_VENDORS.VENDOR_ID%TYPE := 0;
39: comb_flag WSH_ITM_VENDORS.SUPPORTS_COMBINATION_FLAG%TYPE := 'Y';
40: l_addl_country_code VARCHAR2(5);
41: l_sql_error VARCHAR2(2000);
42: i NUMBER := 1;

Line 39: comb_flag WSH_ITM_VENDORS.SUPPORTS_COMBINATION_FLAG%TYPE := 'Y';

35: priority NUMBER := 0;
36: service_tbl Service_Tbl_Type;
37: G_MISS_SERVICE_TBL Service_Tbl_Type;
38: vendor_id WSH_ITM_VENDORS.VENDOR_ID%TYPE := 0;
39: comb_flag WSH_ITM_VENDORS.SUPPORTS_COMBINATION_FLAG%TYPE := 'Y';
40: l_addl_country_code VARCHAR2(5);
41: l_sql_error VARCHAR2(2000);
42: i NUMBER := 1;
43:

Line 61: WSH_ITM_VENDORS v

57: v.vendor_id,
58: v.supports_combination_flag
59: FROM WSH_ITM_SERVICE_PREFERENCES us1,
60: WSH_ITM_VENDOR_SERVICES s,
61: WSH_ITM_VENDORS v
62: WHERE us1.application_id = p_application_id and
63: us1.master_organization_id = p_master_organization_id and
64: us1.vendor_service_id = s.vendor_service_id and
65: us1.active_flag = 'Y'and

Line 75: WSH_ITM_VENDORS v

71: v.vendor_id,
72: v.supports_combination_flag
73: FROM WSH_ITM_SERVICE_PREFERENCES us1,
74: WSH_ITM_VENDOR_SERVICES s,
75: WSH_ITM_VENDORS v
76: WHERE us1.application_id = p_application_id and
77: us1.master_organization_id is null and
78: us1.active_flag = 'Y'and
79: us1.vendor_service_id = s.vendor_service_id and

Line 211: WSH_ITM_VENDOR_SERVICES S, WSH_ITM_VENDORS V,

207: BEGIN
208: SELECT VENDOR INTO x_service_provider FROM
209: ( SELECT 1 PRIORITY, V.SERVICE_PROVIDER VENDOR
210: FROM WSH_ITM_SERVICE_PREFERENCES US1,
211: WSH_ITM_VENDOR_SERVICES S, WSH_ITM_VENDORS V,
212: WSH_ITM_REQUEST_CONTROL RC
213: WHERE US1.APPLICATION_ID = RC.APPLICATION_ID AND
214: US1.MASTER_ORGANIZATION_ID = RC.MASTER_ORGANIZATION_ID AND
215: US1.VENDOR_SERVICE_ID = S.VENDOR_SERVICE_ID AND

Line 223: WSH_ITM_VENDOR_SERVICES S, WSH_ITM_VENDORS V,

219: RC.REQUEST_CONTROL_ID = p_request_control_id
220: UNION
221: SELECT 2 PRIORITY, V.SERVICE_PROVIDER VENDOR
222: FROM WSH_ITM_SERVICE_PREFERENCES US1,
223: WSH_ITM_VENDOR_SERVICES S, WSH_ITM_VENDORS V,
224: WSH_ITM_REQUEST_CONTROL RC
225: WHERE US1.APPLICATION_ID = RC.APPLICATION_ID AND
226: US1.MASTER_ORGANIZATION_ID IS NULL AND
227: US1.VENDOR_SERVICE_ID = S.VENDOR_SERVICE_ID AND