DBA Data[Home] [Help]

APPS.JMF_SHIKYU_PO_PVT dependencies on PO_DISTRIBUTIONS_INTERFACE

Line 86: --| po_distributions_interface table |

82: --| request instead the OU specified in the |
83: --| 'MO: Operating Unit' profile option. |
84: --| 05/09/2006 vchu Bug fix for 5212219: Populate project |
85: --| id and task id into the |
86: --| po_distributions_interface table |
87: --| in order for the corresponding Sales |
88: --| Order to pick up. |
89: --| 05/11/2006 vchu Modified the query for getting the |
90: --| need_by_date of the Subcontracting |

Line 539: INSERT INTO po_distributions_interface

535: , G_PKG_NAME || ': Inserted into po_lines_interface');
536: END IF;
537: END IF;
538:
539: INSERT INTO po_distributions_interface
540: ( interface_header_id
541: , interface_line_id
542: , interface_distribution_id
543: , quantity_ordered

Line 555: , PO_DISTRIBUTIONS_INTERFACE_S.nextval

551: )
552: VALUES
553: ( l_interface_header_id
554: , l_interface_line_id
555: , PO_DISTRIBUTIONS_INTERFACE_S.nextval
556: , l_quantity
557: , l_subcontract_orders_rec.project_id
558: , l_subcontract_orders_rec.task_id
559: , sysdate

Line 570: , G_PKG_NAME || ': Inserted into po_distributions_interface');

566: IF g_log_enabled THEN
567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
568: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
569: , G_PKG_NAME
570: , G_PKG_NAME || ': Inserted into po_distributions_interface');
571: END IF;
572: END IF;
573:
574: -- To get the max line_location_id before calling submit_request