APPS.WSH_CONTAINER_GRP dependencies on WSH_NEW_DELIVERIES

Line 1129: FROM WSH_NEW_DELIVERIES

1125: AND nvl(line_direction,'O') in ('O','IO'); -- J-IB-NPARIKH;
1126:
1127: CURSOR Check_Delivery (v_del_id NUMBER) IS
1128: SELECT delivery_id, name, status_code
1129: FROM WSH_NEW_DELIVERIES
1130: WHERE delivery_id = v_del_id
1131: AND nvl(shipment_direction,'O') in ('O','IO'); -- J-IB-NPARIKH;;
1132:
1133:

Line 1998: l_dlvy_status_code wsh_new_deliveries.status_code%TYPE;

1994: l_verify_status_lvl NUMBER ;
1995: l_verify_org NUMBER ;
1996: l_verify_dlvy NUMBER ;
1997: l_wms_enabled_flag VARCHAR2(10);
1998: l_dlvy_status_code wsh_new_deliveries.status_code%TYPE;
1999: l_cont_org_id NUMBER;
2000: l_cont_released_status wsh_delivery_details.released_status%TYPE;
2001: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2002: l_num_warning NUMBER := 0;

Line 2032: FROM WSH_NEW_DELIVERIES

2028: AND nvl(wdd.line_direction,'O') in ('O','IO'); -- J-IB-NPARIKH
2029:
2030: CURSOR Check_Delivery_by_id (v_del_id NUMBER) IS
2031: SELECT delivery_id, name, status_code
2032: FROM WSH_NEW_DELIVERIES
2033: WHERE delivery_id = v_del_id;
2034:
2035: CURSOR Check_Delivery_by_Name ( v_del_name VARCHAR2) IS
2036: SELECT delivery_id, name, status_code

Line 2037: FROM WSH_NEW_DELIVERIES

2033: WHERE delivery_id = v_del_id;
2034:
2035: CURSOR Check_Delivery_by_Name ( v_del_name VARCHAR2) IS
2036: SELECT delivery_id, name, status_code
2037: FROM WSH_NEW_DELIVERIES
2038: WHERE name = v_del_name;
2039:
2040: CURSOR c_dlvy(l_delivery_id number) IS
2041: SELECT status_code

Line 2042: FROM wsh_new_deliveries

2038: WHERE name = v_del_name;
2039:
2040: CURSOR c_dlvy(l_delivery_id number) IS
2041: SELECT status_code
2042: FROM wsh_new_deliveries
2043: WHERE delivery_id = l_delivery_id;
2044:
2045: -- K LPN CONV. rv
2046: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;