DBA Data[Home] [Help]

APPS.PO_ITEMS_SV dependencies on PO_SESSION_GT

Line 679: l_key PO_SESSION_GT.key%TYPE;

675: p_sob_id IN NUMBER,
676: x_result OUT NOCOPY VARCHAR2
677: ) IS
678:
679: l_key PO_SESSION_GT.key%TYPE;
680: l_dummy NUMBER;
681: l_shipment_count NUMBER;
682:
683: --Bug11658279

Line 745: INSERT INTO po_session_gt

741: -- (2) Count the number of shipments
742: -- (3) If a particular revision is shared among all orgs, the count
743: -- for the revision should be the same as the shipment count
744:
745: INSERT INTO po_session_gt
746: ( key,
747: char1,
748: num1
749: )

Line 780: FROM po_session_gt

776: INTO l_dummy
777: FROM DUAL
778: WHERE EXISTS
779: ( SELECT 1
780: FROM po_session_gt
781: WHERE key = l_key
782: AND num1 = l_shipment_count );
783:
784: x_result := FND_API.G_TRUE;

Line 791: DELETE FROM po_session_gt WHERE key = l_key;

787: WHEN NO_DATA_FOUND THEN
788: x_result := FND_API.G_FALSE;
789: END;
790:
791: DELETE FROM po_session_gt WHERE key = l_key;
792:
793:
794: END IF;
795: