[Home] [Help]
189: CURSOR opm_fetch_quantity IS
190: SELECT line_location_id,
191: quantity,
192: ship_to_organization_id
193: FROM po_line_locations
194: WHERE po_line_id = X_po_line_id
195: AND nvl(cancel_flag,'N') = 'N'
196: AND unit_meas_lookup_code <> X_unit_meas_lookup_code
197: AND shipment_type in ('STANDARD','PLANNED')
295: /* Bug 1916593, Commenting the Cancel Flag condition, so that the
296: canceled shipments can also be updated. Pl. refer the bug for further
297: info */
298:
299: UPDATE po_line_locations
300: SET price_override = X_unit_price,
301: calculate_tax_flag = 'Y',
302: approved_flag = decode(approved_flag, NULL, 'N', 'N','N','R'),
303: last_update_date = sysdate,
354:
355: /*Bug4906693 who columns like last_updated_by and last_update_login
356: also needs to be updated.*/
357:
358: UPDATE po_line_locations
359: SET secondary_quantity = l_shipment_sec_quantity,
360: last_update_date = X_last_update_date,
361: last_updated_by = X_last_updated_by,
362: last_update_login = X_last_update_login
380:
381: /*Bug4906693 who columns like last_updated_by and last_update_login
382: also needs to be updated.*/
383:
384: UPDATE po_line_locations
385: SET unit_meas_lookup_code = X_unit_meas_lookup_code,
386: last_update_date = sysdate,
387: last_updated_by = X_last_updated_by,
388: last_update_login = X_last_update_login
413: -- status is checked in the below sql, so that updation not occur for finally closed shipment.
414: X_progress := '040';
415: SELECT count(pll.po_line_id)
416: INTO X_num_of_shipments
417: FROM po_line_locations pll
418: WHERE pll.po_line_id = X_po_line_id
419: AND NOT EXISTS (SELECT 'there are encumbered or cancelled or drop shipments'
420: FROM po_line_locations pll2
421: WHERE pll2.po_line_id = X_po_line_id
416: INTO X_num_of_shipments
417: FROM po_line_locations pll
418: WHERE pll.po_line_id = X_po_line_id
419: AND NOT EXISTS (SELECT 'there are encumbered or cancelled or drop shipments'
420: FROM po_line_locations pll2
421: WHERE pll2.po_line_id = X_po_line_id
422: AND pll2.shipment_type IN ('STANDARD','PLANNED')
423: AND ( nvl(pll2.encumbered_flag, 'N') <> 'N'
424: OR nvl(pll2.cancel_flag,'N') <> 'N'
440: SELECT secondary_quantity,
441: ship_to_organization_id
442: INTO X_secondary_quantity_ship,
443: X_ship_org_id
444: FROM po_line_locations pll
445: WHERE pll.po_line_id = X_po_line_id
446: AND pll.shipment_type IN ('STANDARD','PLANNED')
447: AND nvl(pll.cancel_flag,'N') <> 'Y';
448:
497:
498: /*Bug4906693 who columns like last_updated_by and last_update_login
499: also needs to be updated.*/
500:
501: UPDATE po_line_locations
502: SET amount = X_amount_db,
503: calculate_tax_flag = 'Y',
504: last_update_date = sysdate,
505: last_updated_by = X_last_updated_by,
525:
526: /*Bug4906693 who columns like last_updated_by and last_update_login
527: also needs to be updated.*/
528:
529: UPDATE po_line_locations
530: SET quantity = X_quantity,
531: -- start of 1548597 --PB Bug# 3274039 changed the variable to X_secondary_quantity_ship_new
532: secondary_quantity = decode(secondary_quantity,null,null,X_secondary_quantity_ship_new),
533: -- end of 1548597
604:
605: SELECT count(pll.po_line_id), max(days_late_receipt_allowed)
606: INTO X_num_of_shipments,
607: X_days_late_receipt_allowed
608: FROM po_line_locations pll
609: WHERE pll.po_line_id = X_po_line_id
610: AND nvl(pll.cancel_flag,'N') <> 'Y'
611: AND pll.shipment_type IN ('STANDARD','PLANNED');
612:
630:
631: /*Bug4906693 who columns like last_updated_by and last_update_login
632: also needs to be updated.*/
633:
634: UPDATE po_line_locations
635: SET promised_date = p_promised_date,
636: need_by_date = p_need_by_date,
637: last_accept_date = decode(p_promised_date,NULL,NULL,
638: p_promised_date+nvl(X_days_late_receipt_allowed,0)),