APPS.WSH_CONTAINER_GRP dependencies on WSH_DELIVERY_DETAILS

Line 441: -- container record in WSH_DELIVERY_DETAILS with the attributes input in the

437: -- 2) other standard parameters
438: --
439: -- Description: This procedure takes in a record of container attributes that
440: -- contains the name and delivery detail id of container to update the
441: -- container record in WSH_DELIVERY_DETAILS with the attributes input in the
442: -- container rec type. The API validates the container name and detail id and
443: -- calls the wsh_delivery_details_grp.update_shipping_attributes public API.
444:
445: -- THIS PROCEDURE SHOULD NOT BE USED ANYMORE, IT IS USED ONLY FOR BACKWARD

Line 443: -- calls the wsh_delivery_details_grp.update_shipping_attributes public API.

439: -- Description: This procedure takes in a record of container attributes that
440: -- contains the name and delivery detail id of container to update the
441: -- container record in WSH_DELIVERY_DETAILS with the attributes input in the
442: -- container rec type. The API validates the container name and detail id and
443: -- calls the wsh_delivery_details_grp.update_shipping_attributes public API.
444:
445: -- THIS PROCEDURE SHOULD NOT BE USED ANYMORE, IT IS USED ONLY FOR BACKWARD
446: -- COMPATIBILITY.
447: ------------------------------------------------------------------------------

Line 501: FROM WSH_DELIVERY_DETAILS

497:
498: --lpn conv
499: CURSOR Check_Cont (v_cont_id NUMBER ) IS
500: SELECT container_flag, delivery_detail_id, lpn_id, released_status
501: FROM WSH_DELIVERY_DETAILS
502: WHERE delivery_detail_id = v_cont_id
503: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO');
504:
505: CURSOR Check_Cont_Name (v_cont_name VARCHAR2) IS

Line 507: FROM WSH_DELIVERY_DETAILS

503: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO');
504:
505: CURSOR Check_Cont_Name (v_cont_name VARCHAR2) IS
506: SELECT delivery_detail_id, container_name
507: FROM WSH_DELIVERY_DETAILS
508: WHERE container_name = v_cont_name
509: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO');
510:
511: CURSOR c_get_lpn (l_delivery_detail_id NUMBER) IS

Line 513: FROM wsh_delivery_details

509: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO');
510:
511: CURSOR c_get_lpn (l_delivery_detail_id NUMBER) IS
512: SELECT lpn_id
513: FROM wsh_delivery_details
514: WHERE delivery_detail_id = l_delivery_detail_id;
515:
516:
517: --

Line 1123: FROM WSH_DELIVERY_DETAILS

1119: WSH_FAIL_AUTOPACK EXCEPTION;
1120:
1121: CURSOR Check_Detail (v_detail_id NUMBER) IS
1122: SELECT delivery_detail_id, container_flag
1123: FROM WSH_DELIVERY_DETAILS
1124: WHERE delivery_detail_id = v_detail_id
1125: AND nvl(line_direction,'O') in ('O','IO'); -- J-IB-NPARIKH;
1126:
1127: CURSOR Check_Delivery (v_del_id NUMBER) IS

Line 2000: l_cont_released_status wsh_delivery_details.released_status%TYPE;

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;
2003: l_num_errors NUMBER := 0;
2004: l_next NUMBER ;

Line 2016: FROM WSH_DELIVERY_DETAILS

2012:
2013: --Bug 4329611. Perf Fix .
2014: CURSOR Get_Detail_Id (v_cont_name VARCHAR2) IS
2015: SELECT delivery_detail_id, container_flag
2016: FROM WSH_DELIVERY_DETAILS
2017: WHERE container_name = v_cont_name
2018: --LPN reuse project
2019: AND released_status = 'X'
2020: AND container_flag = 'Y';

Line 2025: FROM WSH_DELIVERY_DETAILS wdd, wsh_delivery_assignments_v wda

2021:
2022: CURSOR Check_Detail (v_detail_id NUMBER) IS
2023: SELECT wdd.delivery_detail_id, wdd.container_flag,wdd.released_status,
2024: wdd.organization_id ,wda.delivery_id
2025: FROM WSH_DELIVERY_DETAILS wdd, wsh_delivery_assignments_v wda
2026: WHERE wdd.delivery_detail_id = v_detail_id
2027: AND wdd.delivery_detail_id = wda.delivery_detail_id
2028: AND nvl(wdd.line_direction,'O') in ('O','IO'); -- J-IB-NPARIKH
2029: