APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on WSH_UTIL_CORE

Line 58: L_ITEM_FLEX := WSH_UTIL_CORE.GET_ITEM_NAME(p_item_id => C_INV_ITEM_ID

54: L_ITEM_FLEX VARCHAR2(2000);
55: BEGIN
56: /*SRW.REFERENCE(C_ITEM_FLEX)*/NULL;
57: -- LSP PROJECT : passing p_remove_client_code as 'Y'
58: L_ITEM_FLEX := WSH_UTIL_CORE.GET_ITEM_NAME(p_item_id => C_INV_ITEM_ID
59: ,p_organization_id => NVL(C_DEL_ORG_ID,P_ORGANIZATION_ID)
60: ,p_remove_client_code => 'Y');
61: RETURN (L_ITEM_FLEX);
62: EXCEPTION

Line 226: CITY_REGION_POSTAL := WSH_UTIL_CORE.CITY_REGION_POSTAL(C_FROM_CITY

222: BEGIN
223: /*SRW.REFERENCE(C_FROM_CITY)*/NULL;
224: /*SRW.REFERENCE(C_FROM_POSTAL_CODE)*/NULL;
225: /*SRW.REFERENCE(C_FROM_REGION)*/NULL;
226: CITY_REGION_POSTAL := WSH_UTIL_CORE.CITY_REGION_POSTAL(C_FROM_CITY
227: ,C_FROM_REGION
228: ,C_FROM_POSTAL_CODE);
229: IF (CITY_REGION_POSTAL IS NULL) THEN
230: CITY_REGION_POSTAL := C_FROM_CITY || ', ' || C_FROM_REGION || ' ' || C_FROM_POSTAL_CODE;

Line 242: CITY_REGION_POSTAL := WSH_UTIL_CORE.CITY_REGION_POSTAL(C_TO_CITY

238: BEGIN
239: /*SRW.REFERENCE(C_TO_CITY)*/NULL;
240: /*SRW.REFERENCE(C_TO_POSTAL_CODE)*/NULL;
241: /*SRW.REFERENCE(C_TO_REGION)*/NULL;
242: CITY_REGION_POSTAL := WSH_UTIL_CORE.CITY_REGION_POSTAL(C_TO_CITY
243: ,C_TO_REGION
244: ,C_TO_POSTAL_CODE);
245: RETURN (CITY_REGION_POSTAL);
246: END CF_TO_CITY_STATE_ZIPFORMULA;

Line 254: CITY_REGION_POSTAL := WSH_UTIL_CORE.CITY_REGION_POSTAL(CP_BILL_TOWN_OR_CITY

250: BEGIN
251: /*SRW.REFERENCE(CP_BILL_TOWN_OR_CITY)*/NULL;
252: /*SRW.REFERENCE(CP_BILL_POSTAL_CODE)*/NULL;
253: /*SRW.REFERENCE(CP_BILL_REGION)*/NULL;
254: CITY_REGION_POSTAL := WSH_UTIL_CORE.CITY_REGION_POSTAL(CP_BILL_TOWN_OR_CITY
255: ,CP_BILL_REGION
256: ,CP_BILL_POSTAL_CODE);
257: IF (CITY_REGION_POSTAL IS NULL AND CP_BILL_TOWN_OR_CITY IS NOT NULL) THEN --RTV changes
258: CITY_REGION_POSTAL := CP_BILL_TOWN_OR_CITY || ', ' || CP_BILL_REGION || ' ' || CP_BILL_POSTAL_CODE;

Line 523: L_BO_ITEM_FLEX := WSH_UTIL_CORE.GET_ITEM_NAME(BO_INVENTORY_ITEM_ID

519: L_BO_ITEM_FLEX VARCHAR2(2000);
520: BEGIN
521: /*SRW.REFERENCE(BO_INVENTORY_ITEM_ID)*/NULL;
522: /*SRW.REFERENCE(BO_ORGANIZATION_ID)*/NULL;
523: L_BO_ITEM_FLEX := WSH_UTIL_CORE.GET_ITEM_NAME(BO_INVENTORY_ITEM_ID
524: ,NVL(BO_ORGANIZATION_ID
525: ,P_ORGANIZATION_ID));
526: RETURN (L_BO_ITEM_FLEX);
527: EXCEPTION

Line 1504: L_OPERATING_UNIT_ID := WSH_UTIL_CORE.GET_OPERATINGUNIT_ID(C_Q2_DELIVERY_ID);

1500: AND RTYPES.REPORTING_TYPE_CODE = 'AR-SYSTEM-PARAM-REG-NUM'
1501: AND PTP.PARTY_TYPE_CODE = 'OU'
1502: AND PTP.PARTY_ID = P_ORG_ID;
1503: BEGIN
1504: L_OPERATING_UNIT_ID := WSH_UTIL_CORE.GET_OPERATINGUNIT_ID(C_Q2_DELIVERY_ID);
1505: OPEN TAX_REG_NUM_CSR(L_OPERATING_UNIT_ID);
1506: FETCH TAX_REG_NUM_CSR
1507: INTO L_TAX_REG_NUM;
1508: IF TAX_REG_NUM_CSR%NOTFOUND OR L_TAX_REG_NUM IS NULL THEN

Line 1640: cp_draft_or_final := WSH_UTIL_CORE.Get_Lookup_Meaning( p_lookup_type => 'PACK_MODE',

1636: END;
1637: BEGIN
1638: IF p_print_mode IS NOT NULL
1639: THEN
1640: cp_draft_or_final := WSH_UTIL_CORE.Get_Lookup_Meaning( p_lookup_type => 'PACK_MODE',
1641: p_lookup_code =>p_print_mode);
1642: ELSE
1643: NULL;
1644: END IF;