eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CORE_S dependencies on PO_SESSION_GT

Line 4103: -- PO_SESSION_GT column mapping

4099: -- We can't do a FORALL ... SELECT (PL/SQL limitation),
4100: -- but we can to a FORALL ... INSERT ... RETURNING.
4101:
4102: ----------------------------------------------------------------
4103: -- PO_SESSION_GT column mapping
4104: --
4105: -- num1 doc level id
4106: -- num2 header id of num1
4107: ----------------------------------------------------------------

Line 4130: INSERT INTO PO_SESSION_GT ( key, num1 )

4126:
4127: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4128:
4129: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4130: INSERT INTO PO_SESSION_GT ( key, num1 )
4131: VALUES
4132: ( l_id_key
4133: , p_doc_level_id_tbl(i)
4134: )

Line 4140: UPDATE PO_SESSION_GT

4136: BULK COLLECT INTO l_rowid_char_tbl
4137: ;
4138:
4139: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4140: UPDATE PO_SESSION_GT
4141: SET num2 =
4142: (
4143: SELECT PRL.requisition_header_id
4144: FROM PO_REQUISITION_LINES_ALL PRL

Line 4166: INSERT INTO PO_SESSION_GT ( key, num1 )

4162:
4163: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4164:
4165: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4166: INSERT INTO PO_SESSION_GT ( key, num1 )
4167: VALUES
4168: ( l_id_key
4169: , p_doc_level_id_tbl(i)
4170: )

Line 4176: UPDATE PO_SESSION_GT

4172: BULK COLLECT INTO l_rowid_char_tbl
4173: ;
4174:
4175: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4176: UPDATE PO_SESSION_GT
4177: SET num2 =
4178: (
4179: SELECT PRL.requisition_header_id
4180: FROM

Line 4219: INSERT INTO PO_SESSION_GT ( key, num1 )

4215:
4216: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4217:
4218: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4219: INSERT INTO PO_SESSION_GT ( key, num1 )
4220: VALUES
4221: ( l_id_key
4222: , p_doc_level_id_tbl(i)
4223: )

Line 4229: UPDATE PO_SESSION_GT

4225: BULK COLLECT INTO l_rowid_char_tbl
4226: ;
4227:
4228: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4229: UPDATE PO_SESSION_GT
4230: SET num2 =
4231: (
4232: SELECT POL.po_header_id
4233: FROM PO_LINES_ALL POL

Line 4255: INSERT INTO PO_SESSION_GT ( key, num1 )

4251:
4252: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4253:
4254: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4255: INSERT INTO PO_SESSION_GT ( key, num1 )
4256: VALUES
4257: ( l_id_key
4258: , p_doc_level_id_tbl(i)
4259: )

Line 4265: UPDATE PO_SESSION_GT

4261: BULK COLLECT INTO l_rowid_char_tbl
4262: ;
4263:
4264: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4265: UPDATE PO_SESSION_GT
4266: SET num2 =
4267: (
4268: SELECT DECODE( p_doc_type
4269: , g_doc_type_RELEASE, POLL.po_release_id

Line 4294: INSERT INTO PO_SESSION_GT ( key, num1 )

4290:
4291: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4292:
4293: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4294: INSERT INTO PO_SESSION_GT ( key, num1 )
4295: VALUES
4296: ( l_id_key
4297: , p_doc_level_id_tbl(i)
4298: )

Line 4304: UPDATE PO_SESSION_GT

4300: BULK COLLECT INTO l_rowid_char_tbl
4301: ;
4302:
4303: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4304: UPDATE PO_SESSION_GT
4305: SET num2 =
4306: (
4307: SELECT DECODE( p_doc_type
4308: , g_doc_type_RELEASE, POD.po_release_id

Line 4456: -- PO_SESSION_GT column mapping

4452: -- 2. Join to the appropriate tables to bulk collect the line ids.
4453: ----------------------------------------------------
4454:
4455: ---------------------------------------
4456: -- PO_SESSION_GT column mapping
4457: --
4458: -- num1 doc_level_id
4459: ---------------------------------------
4460:

Line 4466: INSERT INTO PO_SESSION_GT ( key, num1 )

4462:
4463: l_progress := '110';
4464:
4465: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4466: INSERT INTO PO_SESSION_GT ( key, num1 )
4467: VALUES ( l_id_key, p_doc_level_id_tbl(i) )
4468: ;
4469:
4470: l_progress := '120';

Line 4485: , PO_SESSION_GT IDS

4481: SELECT PRL.requisition_line_id
4482: BULK COLLECT INTO x_line_id_tbl
4483: FROM
4484: PO_REQUISITION_LINES_ALL PRL
4485: , PO_SESSION_GT IDS
4486: WHERE PRL.requisition_header_id = IDS.num1
4487: AND IDS.key = l_id_key
4488: ;
4489:

Line 4505: , PO_SESSION_GT IDS

4501: SELECT POL.po_line_id
4502: BULK COLLECT INTO x_line_id_tbl
4503: FROM
4504: PO_LINES_MERGE_V POL -- replaced PO_LINES_ALL
4505: , PO_SESSION_GT IDS
4506: WHERE POL.po_header_id = IDS.num1
4507: AND POL.draft_id = p_draft_id
4508: AND IDS.key = l_id_key
4509: ;

Line 4535: -- PO_SESSION_GT column mapping

4531: -- We can't do a FORALL ... SELECT (PL/SQL limitation),
4532: -- but we can to a FORALL ... INSERT ... RETURNING.
4533:
4534: ----------------------------------------------------------------
4535: -- PO_SESSION_GT column mapping
4536: --
4537: -- num1 doc level id
4538: -- num2 line id of num1
4539: ----------------------------------------------------------------

Line 4548: INSERT INTO PO_SESSION_GT ( key, num1 )

4544:
4545: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4546:
4547: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4548: INSERT INTO PO_SESSION_GT ( key, num1 )
4549: VALUES
4550: ( l_id_key
4551: , p_doc_level_id_tbl(i)
4552: )

Line 4558: UPDATE PO_SESSION_GT

4554: BULK COLLECT INTO l_rowid_char_tbl
4555: ;
4556:
4557: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4558: UPDATE PO_SESSION_GT
4559: SET num2 =
4560: (
4561: SELECT POLL.po_line_id
4562: FROM PO_LINE_LOCATIONS_MERGE_V POLL -- replaced PO_LINE_LOCATIONS_ALL

Line 4588: -- PO_SESSION_GT column mapping

4584: -- We can't do a FORALL ... SELECT (PL/SQL limitation),
4585: -- but we can to a FORALL ... INSERT ... RETURNING.
4586:
4587: ----------------------------------------------------------------
4588: -- PO_SESSION_GT column mapping
4589: --
4590: -- num1 doc level id
4591: -- num2 line id of num1
4592: ----------------------------------------------------------------

Line 4608: INSERT INTO PO_SESSION_GT ( key, num1 )

4604:
4605: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4606:
4607: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4608: INSERT INTO PO_SESSION_GT ( key, num1 )
4609: VALUES
4610: ( l_id_key
4611: , p_doc_level_id_tbl(i)
4612: )

Line 4618: UPDATE PO_SESSION_GT

4614: BULK COLLECT INTO l_rowid_char_tbl
4615: ;
4616:
4617: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4618: UPDATE PO_SESSION_GT
4619: SET num2 =
4620: (
4621: SELECT PRD.requisition_line_id
4622: FROM PO_REQ_DISTRIBUTIONS_ALL PRD

Line 4644: INSERT INTO PO_SESSION_GT ( key, num1 )

4640:
4641: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4642:
4643: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4644: INSERT INTO PO_SESSION_GT ( key, num1 )
4645: VALUES
4646: ( l_id_key
4647: , p_doc_level_id_tbl(i)
4648: )

Line 4654: UPDATE PO_SESSION_GT

4650: BULK COLLECT INTO l_rowid_char_tbl
4651: ;
4652:
4653: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4654: UPDATE PO_SESSION_GT
4655: SET num2 =
4656: (
4657: SELECT POD.po_line_id
4658: FROM PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL

Line 4806: -- PO_SESSION_GT column mapping

4802:
4803: -- Load the entity ids into the scratchpad.
4804:
4805: ---------------------------------------
4806: -- PO_SESSION_GT column mapping
4807: --
4808: -- num1 document_level_id
4809: ---------------------------------------
4810:

Line 4816: INSERT INTO PO_SESSION_GT ( key, num1 )

4812:
4813: l_progress := '210';
4814:
4815: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4816: INSERT INTO PO_SESSION_GT ( key, num1 )
4817: VALUES ( l_doc_level_id_key, p_doc_level_id_tbl(i) )
4818: ;
4819:
4820: l_progress := '220';

Line 4840: , PO_SESSION_GT IDS

4836: SELECT POLL.line_location_id
4837: BULK COLLECT INTO x_line_location_id_tbl
4838: FROM
4839: PO_LINE_LOCATIONS_ALL POLL
4840: , PO_SESSION_GT IDS
4841: WHERE POLL.po_release_id = IDS.num1
4842: AND IDS.key = l_doc_level_id_key
4843: ;
4844:

Line 4858: , PO_SESSION_GT IDS

4854: SELECT POLL.line_location_id
4855: BULK COLLECT INTO x_line_location_id_tbl
4856: FROM
4857: PO_LINE_LOCATIONS_MERGE_V POLL -- replaced PO_LINE_LOCATIONS_ALL
4858: , PO_SESSION_GT IDS
4859: WHERE POLL.po_header_id = IDS.num1
4860: and POLL.draft_id = p_draft_id
4861: AND POLL.shipment_type <> g_ship_type_SCHEDULED
4862: AND POLL.shipment_type <> g_ship_type_BLANKET

Line 4880: , PO_SESSION_GT IDS

4876: SELECT POLL.line_location_id
4877: BULK COLLECT INTO x_line_location_id_tbl
4878: FROM
4879: PO_LINE_LOCATIONS_MERGE_V POLL -- replaced PO_LINE_LOCATIONS_ALL
4880: , PO_SESSION_GT IDS
4881: WHERE POLL.po_line_id = IDS.num1
4882: and POLL.draft_id = p_draft_id
4883: AND POLL.shipment_type <> g_ship_type_SCHEDULED
4884: AND POLL.shipment_type <> g_ship_type_BLANKET

Line 4899: -- PO_SESSION_GT column mapping

4895: -- We can't do a FORALL ... SELECT (PL/SQL limitation),
4896: -- but we can to a FORALL ... INSERT ... RETURNING.
4897:
4898: ----------------------------------------------------------------
4899: -- PO_SESSION_GT column mapping
4900: --
4901: -- num1 doc level id
4902: -- num2 line location id of num1
4903: ----------------------------------------------------------------

Line 4913: INSERT INTO PO_SESSION_GT ( key, num1 )

4909:
4910: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4911:
4912: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4913: INSERT INTO PO_SESSION_GT ( key, num1 )
4914: VALUES
4915: ( l_doc_level_id_key
4916: , p_doc_level_id_tbl(i)
4917: )

Line 4923: UPDATE PO_SESSION_GT

4919: BULK COLLECT INTO l_rowid_char_tbl
4920: ;
4921:
4922: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4923: UPDATE PO_SESSION_GT
4924: SET num2 =
4925: (
4926: SELECT POD.line_location_id
4927: FROM PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL

Line 5069: -- PO_SESSION_GT column mapping

5065:
5066: -- Load the entity ids into the scratchpad.
5067:
5068: ---------------------------------------
5069: -- PO_SESSION_GT column mapping
5070: --
5071: -- num1 document_level_id
5072: ---------------------------------------
5073:

Line 5079: INSERT INTO PO_SESSION_GT ( key, num1 )

5075:
5076: l_progress := '210';
5077:
5078: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
5079: INSERT INTO PO_SESSION_GT ( key, num1 )
5080: VALUES ( l_doc_level_id_key, p_doc_level_id_tbl(i) )
5081: ;
5082:
5083: l_progress := '220';

Line 5109: , PO_SESSION_GT IDS

5105: BULK COLLECT INTO x_distribution_id_tbl
5106: FROM
5107: PO_REQUISITION_LINES_ALL PRL
5108: , PO_REQ_DISTRIBUTIONS_ALL PRD
5109: , PO_SESSION_GT IDS
5110: WHERE PRL.requisition_header_id = IDS.num1
5111: AND PRD.requisition_line_id = PRL.requisition_line_id
5112: AND IDS.key = l_doc_level_id_key
5113: ;

Line 5128: , PO_SESSION_GT IDS

5124: SELECT PRD.distribution_id
5125: BULK COLLECT INTO x_distribution_id_tbl
5126: FROM
5127: PO_REQ_DISTRIBUTIONS_ALL PRD
5128: , PO_SESSION_GT IDS
5129: WHERE PRD.requisition_line_id = IDS.num1
5130: AND IDS.key = l_doc_level_id_key
5131: ;
5132:

Line 5165: , PO_SESSION_GT IDS

5161: SELECT POD.po_distribution_id
5162: BULK COLLECT INTO x_distribution_id_tbl
5163: FROM
5164: PO_DISTRIBUTIONS_ALL POD
5165: , PO_SESSION_GT IDS
5166: WHERE POD.po_release_id = IDS.num1
5167: AND IDS.key = l_doc_level_id_key
5168: ;
5169:

Line 5183: , PO_SESSION_GT IDS

5179: SELECT POD.po_distribution_id
5180: BULK COLLECT INTO x_distribution_id_tbl
5181: FROM
5182: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL
5183: , PO_SESSION_GT IDS
5184: WHERE POD.po_header_id = IDS.num1
5185: AND POD.draft_id = p_draft_id
5186: AND POD.po_release_id IS NULL
5187: -- Don't pick up Release distributions when acting on a PPO/BPA/GA.

Line 5205: , PO_SESSION_GT IDS

5201: SELECT POD.po_distribution_id
5202: BULK COLLECT INTO x_distribution_id_tbl
5203: FROM
5204: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL
5205: , PO_SESSION_GT IDS
5206: WHERE POD.po_line_id = IDS.num1
5207: AND POD.draft_id = p_draft_id
5208: AND POD.po_release_id IS NULL
5209: -- Don't pick up SR distributions when acting on a PPO.

Line 5227: , PO_SESSION_GT IDS

5223: SELECT POD.po_distribution_id
5224: BULK COLLECT INTO x_distribution_id_tbl
5225: FROM
5226: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL
5227: , PO_SESSION_GT IDS
5228: WHERE POD.line_location_id = IDS.num1
5229: AND POD.draft_id = p_draft_id
5230: AND IDS.key = l_doc_level_id_key
5231: ;

Line 5349: -- PO_SESSION_GT column mapping

5345:
5346: -- Load the entity ids into the scratchpad.
5347:
5348: ---------------------------------------
5349: -- PO_SESSION_GT column mapping
5350: --
5351: -- num1 document_level_id
5352: ---------------------------------------
5353:

Line 5359: INSERT INTO PO_SESSION_GT ( key, num1 )

5355:
5356: l_progress := '210';
5357:
5358: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
5359: INSERT INTO PO_SESSION_GT ( key, num1 )
5360: VALUES ( l_doc_level_id_key, p_doc_level_id_tbl(i) )
5361: ;
5362:
5363: l_progress := '220';

Line 5414: , PO_SESSION_GT IDS

5410: x_distribution_id_tbl
5411: , x_distribution_rev_num_tbl
5412: FROM
5413: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5414: , PO_SESSION_GT IDS
5415: WHERE POD.po_release_id = IDS.num1
5416: AND IDS.key = l_doc_level_id_key
5417: AND ( (l_revision_specified_flag = 'Y'
5418: AND POD.latest_external_flag = 'Y')

Line 5445: , PO_SESSION_GT IDS

5441: x_distribution_id_tbl
5442: , x_distribution_rev_num_tbl
5443: FROM
5444: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5445: , PO_SESSION_GT IDS
5446: WHERE POD.po_header_id = IDS.num1
5447: AND POD.po_release_id IS NULL
5448: -- Don't pick up Release distributions when acting on a PPO/BPA/GA.
5449: -- Not using distribution_type due to dependency issues.

Line 5479: , PO_SESSION_GT IDS

5475: x_distribution_id_tbl
5476: , x_distribution_rev_num_tbl
5477: FROM
5478: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5479: , PO_SESSION_GT IDS
5480: WHERE POD.po_line_id = IDS.num1
5481: AND POD.po_release_id IS NULL
5482: -- Don't pick up SR distributions when acting on a PPO.
5483: -- Not using distribution_type due to dependency issues.

Line 5513: , PO_SESSION_GT IDS

5509: x_distribution_id_tbl
5510: , x_distribution_rev_num_tbl
5511: FROM
5512: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5513: , PO_SESSION_GT IDS
5514: WHERE POD.line_location_id = IDS.num1
5515: AND IDS.key = l_doc_level_id_key
5516: AND ( (l_revision_specified_flag = 'Y'
5517: AND POD.latest_external_flag = 'Y')

Line 5544: , PO_SESSION_GT IDS

5540: x_distribution_id_tbl
5541: , x_distribution_rev_num_tbl
5542: FROM
5543: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5544: , PO_SESSION_GT IDS
5545: WHERE POD.po_distribution_id = IDS.num1
5546: AND IDS.key = l_doc_level_id_key
5547: AND ( (l_revision_specified_flag = 'Y'
5548: AND POD.latest_external_flag = 'Y')

Line 7126: -- PO_SESSION_GT_S

7122: --Name: get_session_gt_nextval
7123: --Pre-reqs:
7124: -- None.
7125: --Modifies:
7126: -- PO_SESSION_GT_S
7127: --Locks:
7128: -- None.
7129: --Function:
7130: -- Retrieves the next sequence number from the PO_SESSION_GT_S sequence.

Line 7130: -- Retrieves the next sequence number from the PO_SESSION_GT_S sequence.

7126: -- PO_SESSION_GT_S
7127: --Locks:
7128: -- None.
7129: --Function:
7130: -- Retrieves the next sequence number from the PO_SESSION_GT_S sequence.
7131: --Returns:
7132: -- PO_SESSION_GT_S.nextval
7133: --End of Comments
7134: --------------------------------------------------------------------------------

Line 7132: -- PO_SESSION_GT_S.nextval

7128: -- None.
7129: --Function:
7130: -- Retrieves the next sequence number from the PO_SESSION_GT_S sequence.
7131: --Returns:
7132: -- PO_SESSION_GT_S.nextval
7133: --End of Comments
7134: --------------------------------------------------------------------------------
7135: FUNCTION get_session_gt_nextval
7136: RETURN NUMBER

Line 7153: SELECT PO_SESSION_GT_S.nextval

7149: END IF;
7150:
7151: l_progress := '010';
7152:
7153: SELECT PO_SESSION_GT_S.nextval
7154: INTO x_nextval
7155: FROM DUAL
7156: ;
7157: