APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on WSH_NEW_DELIVERIES

Line 254: L_CUSTOMER_ID WSH_NEW_DELIVERIES.CUSTOMER_ID%TYPE;

250: L_RESULT NUMBER;
251: L_RETURN_STATUS VARCHAR2(5);
252: L_MSG_COUNT NUMBER;
253: L_MSG_DATA VARCHAR2(3000);
254: L_CUSTOMER_ID WSH_NEW_DELIVERIES.CUSTOMER_ID%TYPE;
255: BEGIN
256: /*SRW.REFERENCE(C_DEL_CUSTOMER_ID)*/NULL;
257: /*SRW.REFERENCE(C_CUSTOMER_ID)*/NULL;
258: /*SRW.REFERENCE(C_SRC_LINE_ID)*/NULL;

Line 1176: WSH_NEW_DELIVERIES DEL,

1172: SELECT
1173: LOC.ADDRESS1 || ', ' || LOC.ADDRESS2 || ', ' || LOC.ADDRESS3 || ', ' || LOC.ADDRESS4 || ', ' || LOC.CITY || ', ' || LOC.STATE || ', ' || LOC.COUNTRY || ', ' || LOC.POSTAL_CODE CARRIER_ADDR
1174: FROM
1175: WSH_ORG_CARRIER_SITES ORG_SITES,
1176: WSH_NEW_DELIVERIES DEL,
1177: HZ_PARTY_SITES HZ_SITES,
1178: HZ_LOCATIONS LOC
1179: WHERE ORG_SITES.ORGANIZATION_ID = DEL.ORGANIZATION_ID
1180: AND HZ_SITES.PARTY_SITE_ID = ORG_SITES.CARRIER_SITE_ID

Line 1204: WSH_NEW_DELIVERIES DEL,

1200: SELECT
1201: LOC.ADDRESS1 || ', ' || LOC.ADDRESS2 || ', ' || LOC.ADDRESS3 || ', ' || LOC.ADDRESS4 || ', ' || LOC.CITY || ', ' || LOC.STATE || ', ' || LOC.COUNTRY || ', ' || LOC.POSTAL_CODE CARRIER_ADDR
1202: FROM
1203: WSH_ORG_CARRIER_SITES ORG_SITES,
1204: WSH_NEW_DELIVERIES DEL,
1205: HZ_PARTY_SITES HZ_SITES,
1206: HZ_LOCATIONS LOC
1207: WHERE ORG_SITES.ORGANIZATION_ID = DEL.ORGANIZATION_ID
1208: AND HZ_SITES.PARTY_SITE_ID = ORG_SITES.CARRIER_SITE_ID

Line 1218: WSH_NEW_DELIVERIES WND

1214: CURSOR C_DEL_CARRIER(C_DELIVERY_ID IN NUMBER) IS
1215: SELECT
1216: WND.CARRIER_ID DEL_CARRIER_ID
1217: FROM
1218: WSH_NEW_DELIVERIES WND
1219: WHERE WND.DELIVERY_ID = C_DELIVERY_ID;
1220: BEGIN
1221: IF (TRIP_CARRIER_ID IS NOT NULL) THEN
1222: FOR c_rec IN C_CARRIER_ADDRESS(c_carrier_id => trip_carrier_id,c_delivery_id => c_trip_delivery_id)

Line 1412: wsh_new_deliveries del

1408: IF p_delivery_id IS NOT NULL THEN
1409: SELECT hr.name
1410: INTO cp_warehouse_name
1411: FROM hr_organization_units hr,
1412: wsh_new_deliveries del
1413: WHERE del.organization_id = hr.organization_id
1414: AND del.delivery_id = p_delivery_id;
1415: ELSIF p_organization_id IS NOT NULL
1416: THEN