APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_SHIPPING_PARAMETERS

Line 690: l_organization_id WSH_SHIPPING_PARAMETERS.ORGANIZATION_ID%TYPE;

686:
687: l_num_error BINARY_INTEGER := 0;
688: l_num_warn BINARY_INTEGER := 0;
689: l_delfirm VARCHAR2(1);
690: l_organization_id WSH_SHIPPING_PARAMETERS.ORGANIZATION_ID%TYPE;
691: l_planned_flag WSH_NEW_DELIVERIES.PLANNED_FLAG%TYPE;
692: l_initial_pickup_location_id WSH_NEW_DELIVERIES.INITIAL_PICKUP_LOCATION_ID%TYPE;
693: l_released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE;
694: l_num_of_staged_lines NUMBER := 0;

Line 1969: FROM wsh_shipping_parameters

1965: WHERE dl.delivery_id = p_delivery_id;
1966:
1967: CURSOR pack_slip_required (l_org_id NUMBER) IS
1968: SELECT pack_slip_required_flag
1969: FROM wsh_shipping_parameters
1970: WHERE organization_id = l_org_id;
1971:
1972: CURSOR get_pack_slip_number IS
1973: SELECT packing_slip_number

Line 2070: -- Bug: 1527393 Packslip should be generated irrespective of the required_flag in wsh_shipping_parameters.

2066: FETCH get_pack_slip_number INTO l_pack_slip_number;
2067: CLOSE get_pack_slip_number;
2068:
2069: SAVEPOINT sp2;
2070: -- Bug: 1527393 Packslip should be generated irrespective of the required_flag in wsh_shipping_parameters.
2071: IF (l_pack_slip_number IS NULL) THEN
2072: --
2073: -- Debug Statements
2074: --

Line 2573: FROM wsh_shipping_parameters sp,

2569: START WITH wda.delivery_id = l_delivery_id;
2570:
2571: CURSOR Report_Set (l_organization_id NUMBER) IS
2572: SELECT rs.name, rs.report_set_id
2573: FROM wsh_shipping_parameters sp,
2574: wsh_report_sets rs
2575: WHERE sp.organization_id = l_organization_id AND
2576: rs.report_set_id = sp.delivery_report_set_id;
2577: