APPS.WSH_UPGRADE_PICK_SLIP_DATA_NEW dependencies on SO_PICKING_HEADERS_ALL

Line 195: FROM SO_PICKING_HEADERS_ALL

191: last_updated_by,
192: last_update_login,
193: last_update_date,
194: expected_arrival_date -- added: for bug 1413000
195: FROM SO_PICKING_HEADERS_ALL
196: WHERE picking_header_id = x_header_id;
197:
198: CURSOR get_order_info(x_header_id IN BINARY_INTEGER) IS
199: SELECT NVL(CUSTOMER_ID,-1),

Line 311: Init_Mesg('ERROR: Ship_To_Site_Use_Id column for picking_header_id '||p_header_id||' in so_picking_headers_all is NULL');

307:
308: CLOSE get_order_info;
309:
310: IF (p_ship_to_site_use_id is NULL) THEN
311: Init_Mesg('ERROR: Ship_To_Site_Use_Id column for picking_header_id '||p_header_id||' in so_picking_headers_all is NULL');
312: RETURN FAILURE;
313: END IF;
314:
315: IF (v_customer_id is NULL) THEN

Line 326: Init_Mesg('ERROR: Date_Shipped column for picking_header_id '||p_header_id||' in so_picking_headers_all is NULL');

322: FETCH count_shipped_pls INTO p_pick_line_count;
323: CLOSE count_shipped_pls;
324:
325: IF p_pick_line_count > 0 THEN
326: Init_Mesg('ERROR: Date_Shipped column for picking_header_id '||p_header_id||' in so_picking_headers_all is NULL');
327: RETURN FAILURE;
328: ELSE
329: p_date_shipped := p_last_update_date;
330: END IF;

Line 555: FROM SO_PICKING_HEADERS_ALL

551: NULL_ERROR EXCEPTION;
552:
553: CURSOR get_header_id(l_min BINARY_INTEGER, l_max BINARY_INTEGER) IS
554: SELECT picking_header_id
555: FROM SO_PICKING_HEADERS_ALL
556: WHERE
557: delivery_id is NULL
558: AND status_code = 'CLOSED'
559: AND picking_header_id BETWEEN l_min and l_max;

Line 563: FROM so_picking_headers_all WHERE

559: AND picking_header_id BETWEEN l_min and l_max;
560:
561: CURSOR get_any_row IS
562: SELECT 1
563: FROM so_picking_headers_all WHERE
564: delivery_id is NULL and
565: picking_header_id > 0 and
566: status_code = 'CLOSED';
567:

Line 600: FROM SO_PICKING_HEADERS_ALL

596: IF batch_number = 0 THEN
597:
598: SELECT NVL(MIN(picking_header_id),0), NVL(MAX(picking_header_id),0)
599: INTO l_job_min, l_job_max
600: FROM SO_PICKING_HEADERS_ALL
601: WHERE picking_header_id between 1 and 9999
602: AND delivery_id IS NULL
603: AND status_code = 'CLOSED';
604:

Line 609: FROM SO_PICKING_HEADERS_ALL

605: ELSIF batch_number = 1 THEN
606:
607: SELECT NVL(MIN(picking_header_id),0), NVL(MAX(picking_header_id),0)
608: INTO l_job_min, l_job_max
609: FROM SO_PICKING_HEADERS_ALL
610: WHERE picking_header_id between 10000 and 99999999
611: AND delivery_id IS NULL
612: AND status_code = 'CLOSED';
613:

Line 618: FROM SO_PICKING_HEADERS_ALL

614: ELSIF batch_number = 2 THEN
615:
616: SELECT NVL(MIN(picking_header_id),0), NVL(MAX(picking_header_id),0)
617: INTO l_job_min, l_job_max
618: FROM SO_PICKING_HEADERS_ALL
619: WHERE picking_header_id >= 100000000
620: AND delivery_id IS NULL
621: AND status_code = 'CLOSED';
622:

Line 673: UPDATE SO_PICKING_HEADERS_ALL PH

669: UPDATE SO_FREIGHT_CHARGES
670: SET delivery_id = u_delivery_id
671: WHERE picking_header_id = u_picking_header_id;
672:
673: UPDATE SO_PICKING_HEADERS_ALL PH
674: SET PH.delivery_id = u_delivery_id
675: WHERE PH.picking_header_id = u_picking_header_id;
676:
677: UPDATE SO_PICKING_LINE_DETAILS

Line 701: Insert_Mesg('No closed row in table SO_PICKING_HEADERS_ALL, skipping Upgrade_Row');

697:
698: END LOOP;
699: Insert_Mesg('Long waybill count : ' || to_char(long_waybill_count));
700: ELSE
701: Insert_Mesg('No closed row in table SO_PICKING_HEADERS_ALL, skipping Upgrade_Row');
702: END IF;
703: close get_any_row;
704: Commit;
705: EXCEPTION