APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on WSH_UTIL_CORE

Line 43: L_ITEM_FLEX := WSH_UTIL_CORE.GET_ITEM_NAME(C_INV_ITEM_ID

39: ,C_DEL_ORG_ID IN NUMBER) RETURN VARCHAR2 IS
40: L_ITEM_FLEX VARCHAR2(2000);
41: BEGIN
42: /*SRW.REFERENCE(C_ITEM_FLEX)*/NULL;
43: L_ITEM_FLEX := WSH_UTIL_CORE.GET_ITEM_NAME(C_INV_ITEM_ID
44: ,NVL(C_DEL_ORG_ID
45: ,P_ORGANIZATION_ID));
46: RETURN (L_ITEM_FLEX);
47: EXCEPTION

Line 211: CITY_REGION_POSTAL := WSH_UTIL_CORE.CITY_REGION_POSTAL(C_FROM_CITY

207: BEGIN
208: /*SRW.REFERENCE(C_FROM_CITY)*/NULL;
209: /*SRW.REFERENCE(C_FROM_POSTAL_CODE)*/NULL;
210: /*SRW.REFERENCE(C_FROM_REGION)*/NULL;
211: CITY_REGION_POSTAL := WSH_UTIL_CORE.CITY_REGION_POSTAL(C_FROM_CITY
212: ,C_FROM_REGION
213: ,C_FROM_POSTAL_CODE);
214: IF (CITY_REGION_POSTAL IS NULL) THEN
215: CITY_REGION_POSTAL := C_FROM_CITY || ', ' || C_FROM_REGION || ' ' || C_FROM_POSTAL_CODE;

Line 227: CITY_REGION_POSTAL := WSH_UTIL_CORE.CITY_REGION_POSTAL(C_TO_CITY

223: BEGIN
224: /*SRW.REFERENCE(C_TO_CITY)*/NULL;
225: /*SRW.REFERENCE(C_TO_POSTAL_CODE)*/NULL;
226: /*SRW.REFERENCE(C_TO_REGION)*/NULL;
227: CITY_REGION_POSTAL := WSH_UTIL_CORE.CITY_REGION_POSTAL(C_TO_CITY
228: ,C_TO_REGION
229: ,C_TO_POSTAL_CODE);
230: RETURN (CITY_REGION_POSTAL);
231: END CF_TO_CITY_STATE_ZIPFORMULA;

Line 239: CITY_REGION_POSTAL := WSH_UTIL_CORE.CITY_REGION_POSTAL(CP_BILL_TOWN_OR_CITY

235: BEGIN
236: /*SRW.REFERENCE(CP_BILL_TOWN_OR_CITY)*/NULL;
237: /*SRW.REFERENCE(CP_BILL_POSTAL_CODE)*/NULL;
238: /*SRW.REFERENCE(CP_BILL_REGION)*/NULL;
239: CITY_REGION_POSTAL := WSH_UTIL_CORE.CITY_REGION_POSTAL(CP_BILL_TOWN_OR_CITY
240: ,CP_BILL_REGION
241: ,CP_BILL_POSTAL_CODE);
242: IF (CITY_REGION_POSTAL IS NULL) THEN
243: CITY_REGION_POSTAL := CP_BILL_TOWN_OR_CITY || ', ' || CP_BILL_REGION || ' ' || CP_BILL_POSTAL_CODE;

Line 500: L_BO_ITEM_FLEX := WSH_UTIL_CORE.GET_ITEM_NAME(BO_INVENTORY_ITEM_ID

496: L_BO_ITEM_FLEX VARCHAR2(2000);
497: BEGIN
498: /*SRW.REFERENCE(BO_INVENTORY_ITEM_ID)*/NULL;
499: /*SRW.REFERENCE(BO_ORGANIZATION_ID)*/NULL;
500: L_BO_ITEM_FLEX := WSH_UTIL_CORE.GET_ITEM_NAME(BO_INVENTORY_ITEM_ID
501: ,NVL(BO_ORGANIZATION_ID
502: ,P_ORGANIZATION_ID));
503: RETURN (L_BO_ITEM_FLEX);
504: EXCEPTION

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

1263: AND RTYPES.REPORTING_TYPE_CODE = 'AR-SYSTEM-PARAM-REG-NUM'
1264: AND PTP.PARTY_TYPE_CODE = 'OU'
1265: AND PTP.PARTY_ID = P_ORG_ID;
1266: BEGIN
1267: L_OPERATING_UNIT_ID := WSH_UTIL_CORE.GET_OPERATINGUNIT_ID(C_Q2_DELIVERY_ID);
1268: OPEN TAX_REG_NUM_CSR(L_OPERATING_UNIT_ID);
1269: FETCH TAX_REG_NUM_CSR
1270: INTO L_TAX_REG_NUM;
1271: IF TAX_REG_NUM_CSR%NOTFOUND OR L_TAX_REG_NUM IS NULL THEN

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

1399: END;
1400: BEGIN
1401: IF p_print_mode IS NOT NULL
1402: THEN
1403: cp_draft_or_final := WSH_UTIL_CORE.Get_Lookup_Meaning( p_lookup_type => 'PACK_MODE',
1404: p_lookup_code =>p_print_mode);
1405: ELSE
1406: NULL;
1407: END IF;