DBA Data[Home] [Help]

APPS.PO_ITEMS_SV dependencies on PO_SESSION_GT

Line 678: l_key PO_SESSION_GT.key%TYPE;

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

Line 722: INSERT INTO po_session_gt

718: -- (3) If a particular revision is shared among all orgs, the count
719: -- for the revision should be the same as the shipment count
720:
721:
722: INSERT INTO po_session_gt
723: ( key,
724: char1,
725: num1
726: )

Line 756: FROM po_session_gt

752: INTO l_dummy
753: FROM DUAL
754: WHERE EXISTS
755: ( SELECT 1
756: FROM po_session_gt
757: WHERE key = l_key
758: AND num1 = l_shipment_count );
759:
760: x_result := FND_API.G_TRUE;

Line 767: DELETE FROM po_session_gt WHERE key = l_key;

763: WHEN NO_DATA_FOUND THEN
764: x_result := FND_API.G_FALSE;
765: END;
766:
767: DELETE FROM po_session_gt WHERE key = l_key;
768:
769:
770: END IF;
771: