APPS.PO_LINES_SV11 dependencies on PO_DISTRIBUTIONS

Line 542: FROM po_distributions pd

538: X_progress := '060';
539:
540: SELECT count(po_distribution_id)
541: INTO X_num_of_distributions
542: FROM po_distributions pd
543: WHERE pd.po_line_id = X_po_line_id
544: AND NOT EXISTS (SELECT 'there are encumbered distributions'
545: FROM po_distributions pd2
546: WHERE pd2.po_line_id = X_po_line_id

Line 545: FROM po_distributions pd2

541: INTO X_num_of_distributions
542: FROM po_distributions pd
543: WHERE pd.po_line_id = X_po_line_id
544: AND NOT EXISTS (SELECT 'there are encumbered distributions'
545: FROM po_distributions pd2
546: WHERE pd2.po_line_id = X_po_line_id
547: AND nvl(pd2.encumbered_flag, 'N') <> 'N');
548:
549:

Line 558: UPDATE po_distributions

554:
555: /*Bug4906693 who columns like last_updated_by and last_update_login
556: also needs to be updated.*/
557:
558: UPDATE po_distributions
559: SET amount_ordered = X_amount_db,
560: last_update_date = sysdate,
561: last_updated_by = X_last_updated_by,
562: last_update_login = X_last_update_login

Line 570: UPDATE po_distributions

566:
567: /*Bug4906693 who columns like last_updated_by and last_update_login
568: also needs to be updated.*/
569:
570: UPDATE po_distributions
571: SET quantity_ordered = X_quantity,
572: last_update_date = sysdate,
573: last_updated_by = X_last_updated_by,
574: last_update_login = X_last_update_login