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 3953: -- PO_SESSION_GT column mapping

3949: -- We can't do a FORALL ... SELECT (PL/SQL limitation),
3950: -- but we can to a FORALL ... INSERT ... RETURNING.
3951:
3952: ----------------------------------------------------------------
3953: -- PO_SESSION_GT column mapping
3954: --
3955: -- num1 doc level id
3956: -- num2 header id of num1
3957: ----------------------------------------------------------------

Line 3980: INSERT INTO PO_SESSION_GT ( key, num1 )

3976:
3977: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
3978:
3979: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
3980: INSERT INTO PO_SESSION_GT ( key, num1 )
3981: VALUES
3982: ( l_id_key
3983: , p_doc_level_id_tbl(i)
3984: )

Line 3990: UPDATE PO_SESSION_GT

3986: BULK COLLECT INTO l_rowid_char_tbl
3987: ;
3988:
3989: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
3990: UPDATE PO_SESSION_GT
3991: SET num2 =
3992: (
3993: SELECT PRL.requisition_header_id
3994: FROM PO_REQUISITION_LINES_ALL PRL

Line 4016: INSERT INTO PO_SESSION_GT ( key, num1 )

4012:
4013: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4014:
4015: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4016: INSERT INTO PO_SESSION_GT ( key, num1 )
4017: VALUES
4018: ( l_id_key
4019: , p_doc_level_id_tbl(i)
4020: )

Line 4026: UPDATE PO_SESSION_GT

4022: BULK COLLECT INTO l_rowid_char_tbl
4023: ;
4024:
4025: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4026: UPDATE PO_SESSION_GT
4027: SET num2 =
4028: (
4029: SELECT PRL.requisition_header_id
4030: FROM

Line 4069: INSERT INTO PO_SESSION_GT ( key, num1 )

4065:
4066: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4067:
4068: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4069: INSERT INTO PO_SESSION_GT ( key, num1 )
4070: VALUES
4071: ( l_id_key
4072: , p_doc_level_id_tbl(i)
4073: )

Line 4079: UPDATE PO_SESSION_GT

4075: BULK COLLECT INTO l_rowid_char_tbl
4076: ;
4077:
4078: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4079: UPDATE PO_SESSION_GT
4080: SET num2 =
4081: (
4082: SELECT POL.po_header_id
4083: FROM PO_LINES_ALL POL

Line 4105: INSERT INTO PO_SESSION_GT ( key, num1 )

4101:
4102: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4103:
4104: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4105: INSERT INTO PO_SESSION_GT ( key, num1 )
4106: VALUES
4107: ( l_id_key
4108: , p_doc_level_id_tbl(i)
4109: )

Line 4115: UPDATE PO_SESSION_GT

4111: BULK COLLECT INTO l_rowid_char_tbl
4112: ;
4113:
4114: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4115: UPDATE PO_SESSION_GT
4116: SET num2 =
4117: (
4118: SELECT DECODE( p_doc_type
4119: , g_doc_type_RELEASE, POLL.po_release_id

Line 4144: INSERT INTO PO_SESSION_GT ( key, num1 )

4140:
4141: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4142:
4143: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4144: INSERT INTO PO_SESSION_GT ( key, num1 )
4145: VALUES
4146: ( l_id_key
4147: , p_doc_level_id_tbl(i)
4148: )

Line 4154: UPDATE PO_SESSION_GT

4150: BULK COLLECT INTO l_rowid_char_tbl
4151: ;
4152:
4153: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4154: UPDATE PO_SESSION_GT
4155: SET num2 =
4156: (
4157: SELECT DECODE( p_doc_type
4158: , g_doc_type_RELEASE, POD.po_release_id

Line 4290: -- PO_SESSION_GT column mapping

4286: -- 2. Join to the appropriate tables to bulk collect the line ids.
4287: ----------------------------------------------------
4288:
4289: ---------------------------------------
4290: -- PO_SESSION_GT column mapping
4291: --
4292: -- num1 doc_level_id
4293: ---------------------------------------
4294:

Line 4300: INSERT INTO PO_SESSION_GT ( key, num1 )

4296:
4297: l_progress := '110';
4298:
4299: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4300: INSERT INTO PO_SESSION_GT ( key, num1 )
4301: VALUES ( l_id_key, p_doc_level_id_tbl(i) )
4302: ;
4303:
4304: l_progress := '120';

Line 4319: , PO_SESSION_GT IDS

4315: SELECT PRL.requisition_line_id
4316: BULK COLLECT INTO x_line_id_tbl
4317: FROM
4318: PO_REQUISITION_LINES_ALL PRL
4319: , PO_SESSION_GT IDS
4320: WHERE PRL.requisition_header_id = IDS.num1
4321: AND IDS.key = l_id_key
4322: ;
4323:

Line 4339: , PO_SESSION_GT IDS

4335: SELECT POL.po_line_id
4336: BULK COLLECT INTO x_line_id_tbl
4337: FROM
4338: PO_LINES_ALL POL
4339: , PO_SESSION_GT IDS
4340: WHERE POL.po_header_id = IDS.num1
4341: AND IDS.key = l_id_key
4342: ;
4343:

Line 4368: -- PO_SESSION_GT column mapping

4364: -- We can't do a FORALL ... SELECT (PL/SQL limitation),
4365: -- but we can to a FORALL ... INSERT ... RETURNING.
4366:
4367: ----------------------------------------------------------------
4368: -- PO_SESSION_GT column mapping
4369: --
4370: -- num1 doc level id
4371: -- num2 line id of num1
4372: ----------------------------------------------------------------

Line 4381: INSERT INTO PO_SESSION_GT ( key, num1 )

4377:
4378: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4379:
4380: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4381: INSERT INTO PO_SESSION_GT ( key, num1 )
4382: VALUES
4383: ( l_id_key
4384: , p_doc_level_id_tbl(i)
4385: )

Line 4391: UPDATE PO_SESSION_GT

4387: BULK COLLECT INTO l_rowid_char_tbl
4388: ;
4389:
4390: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4391: UPDATE PO_SESSION_GT
4392: SET num2 =
4393: (
4394: SELECT POLL.po_line_id
4395: FROM PO_LINE_LOCATIONS_ALL POLL

Line 4420: -- PO_SESSION_GT column mapping

4416: -- We can't do a FORALL ... SELECT (PL/SQL limitation),
4417: -- but we can to a FORALL ... INSERT ... RETURNING.
4418:
4419: ----------------------------------------------------------------
4420: -- PO_SESSION_GT column mapping
4421: --
4422: -- num1 doc level id
4423: -- num2 line id of num1
4424: ----------------------------------------------------------------

Line 4440: INSERT INTO PO_SESSION_GT ( key, num1 )

4436:
4437: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4438:
4439: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4440: INSERT INTO PO_SESSION_GT ( key, num1 )
4441: VALUES
4442: ( l_id_key
4443: , p_doc_level_id_tbl(i)
4444: )

Line 4450: UPDATE PO_SESSION_GT

4446: BULK COLLECT INTO l_rowid_char_tbl
4447: ;
4448:
4449: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4450: UPDATE PO_SESSION_GT
4451: SET num2 =
4452: (
4453: SELECT PRD.requisition_line_id
4454: FROM PO_REQ_DISTRIBUTIONS_ALL PRD

Line 4476: INSERT INTO PO_SESSION_GT ( key, num1 )

4472:
4473: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4474:
4475: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4476: INSERT INTO PO_SESSION_GT ( key, num1 )
4477: VALUES
4478: ( l_id_key
4479: , p_doc_level_id_tbl(i)
4480: )

Line 4486: UPDATE PO_SESSION_GT

4482: BULK COLLECT INTO l_rowid_char_tbl
4483: ;
4484:
4485: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4486: UPDATE PO_SESSION_GT
4487: SET num2 =
4488: (
4489: SELECT POD.po_line_id
4490: FROM PO_DISTRIBUTIONS_ALL POD

Line 4620: -- PO_SESSION_GT column mapping

4616:
4617: -- Load the entity ids into the scratchpad.
4618:
4619: ---------------------------------------
4620: -- PO_SESSION_GT column mapping
4621: --
4622: -- num1 document_level_id
4623: ---------------------------------------
4624:

Line 4630: INSERT INTO PO_SESSION_GT ( key, num1 )

4626:
4627: l_progress := '210';
4628:
4629: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4630: INSERT INTO PO_SESSION_GT ( key, num1 )
4631: VALUES ( l_doc_level_id_key, p_doc_level_id_tbl(i) )
4632: ;
4633:
4634: l_progress := '220';

Line 4654: , PO_SESSION_GT IDS

4650: SELECT POLL.line_location_id
4651: BULK COLLECT INTO x_line_location_id_tbl
4652: FROM
4653: PO_LINE_LOCATIONS_ALL POLL
4654: , PO_SESSION_GT IDS
4655: WHERE POLL.po_release_id = IDS.num1
4656: AND IDS.key = l_doc_level_id_key
4657: ;
4658:

Line 4672: , PO_SESSION_GT IDS

4668: SELECT POLL.line_location_id
4669: BULK COLLECT INTO x_line_location_id_tbl
4670: FROM
4671: PO_LINE_LOCATIONS_ALL POLL
4672: , PO_SESSION_GT IDS
4673: WHERE POLL.po_header_id = IDS.num1
4674: AND POLL.shipment_type <> g_ship_type_SCHEDULED
4675: AND POLL.shipment_type <> g_ship_type_BLANKET
4676: -- don't pick up release shipments for POs/PAs

Line 4693: , PO_SESSION_GT IDS

4689: SELECT POLL.line_location_id
4690: BULK COLLECT INTO x_line_location_id_tbl
4691: FROM
4692: PO_LINE_LOCATIONS_ALL POLL
4693: , PO_SESSION_GT IDS
4694: WHERE POLL.po_line_id = IDS.num1
4695: AND POLL.shipment_type <> g_ship_type_SCHEDULED
4696: AND POLL.shipment_type <> g_ship_type_BLANKET
4697: -- don't pick up release shipments for POs/PAs

Line 4711: -- PO_SESSION_GT column mapping

4707: -- We can't do a FORALL ... SELECT (PL/SQL limitation),
4708: -- but we can to a FORALL ... INSERT ... RETURNING.
4709:
4710: ----------------------------------------------------------------
4711: -- PO_SESSION_GT column mapping
4712: --
4713: -- num1 doc level id
4714: -- num2 line location id of num1
4715: ----------------------------------------------------------------

Line 4725: INSERT INTO PO_SESSION_GT ( key, num1 )

4721:
4722: /* Start Bug 3292870: Split query to make it compatible with 8i db. */
4723:
4724: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4725: INSERT INTO PO_SESSION_GT ( key, num1 )
4726: VALUES
4727: ( l_doc_level_id_key
4728: , p_doc_level_id_tbl(i)
4729: )

Line 4735: UPDATE PO_SESSION_GT

4731: BULK COLLECT INTO l_rowid_char_tbl
4732: ;
4733:
4734: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4735: UPDATE PO_SESSION_GT
4736: SET num2 =
4737: (
4738: SELECT POD.line_location_id
4739: FROM PO_DISTRIBUTIONS_ALL POD

Line 4864: -- PO_SESSION_GT column mapping

4860:
4861: -- Load the entity ids into the scratchpad.
4862:
4863: ---------------------------------------
4864: -- PO_SESSION_GT column mapping
4865: --
4866: -- num1 document_level_id
4867: ---------------------------------------
4868:

Line 4874: INSERT INTO PO_SESSION_GT ( key, num1 )

4870:
4871: l_progress := '210';
4872:
4873: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
4874: INSERT INTO PO_SESSION_GT ( key, num1 )
4875: VALUES ( l_doc_level_id_key, p_doc_level_id_tbl(i) )
4876: ;
4877:
4878: l_progress := '220';

Line 4904: , PO_SESSION_GT IDS

4900: BULK COLLECT INTO x_distribution_id_tbl
4901: FROM
4902: PO_REQUISITION_LINES_ALL PRL
4903: , PO_REQ_DISTRIBUTIONS_ALL PRD
4904: , PO_SESSION_GT IDS
4905: WHERE PRL.requisition_header_id = IDS.num1
4906: AND PRD.requisition_line_id = PRL.requisition_line_id
4907: AND IDS.key = l_doc_level_id_key
4908: ;

Line 4923: , PO_SESSION_GT IDS

4919: SELECT PRD.distribution_id
4920: BULK COLLECT INTO x_distribution_id_tbl
4921: FROM
4922: PO_REQ_DISTRIBUTIONS_ALL PRD
4923: , PO_SESSION_GT IDS
4924: WHERE PRD.requisition_line_id = IDS.num1
4925: AND IDS.key = l_doc_level_id_key
4926: ;
4927:

Line 4960: , PO_SESSION_GT IDS

4956: SELECT POD.po_distribution_id
4957: BULK COLLECT INTO x_distribution_id_tbl
4958: FROM
4959: PO_DISTRIBUTIONS_ALL POD
4960: , PO_SESSION_GT IDS
4961: WHERE POD.po_release_id = IDS.num1
4962: AND IDS.key = l_doc_level_id_key
4963: ;
4964:

Line 4978: , PO_SESSION_GT IDS

4974: SELECT POD.po_distribution_id
4975: BULK COLLECT INTO x_distribution_id_tbl
4976: FROM
4977: PO_DISTRIBUTIONS_ALL POD
4978: , PO_SESSION_GT IDS
4979: WHERE POD.po_header_id = IDS.num1
4980: AND POD.po_release_id IS NULL
4981: -- Don't pick up Release distributions when acting on a PPO/BPA/GA.
4982: -- Not using distribution_type due to dependency issues.

Line 4999: , PO_SESSION_GT IDS

4995: SELECT POD.po_distribution_id
4996: BULK COLLECT INTO x_distribution_id_tbl
4997: FROM
4998: PO_DISTRIBUTIONS_ALL POD
4999: , PO_SESSION_GT IDS
5000: WHERE POD.po_line_id = IDS.num1
5001: AND POD.po_release_id IS NULL
5002: -- Don't pick up SR distributions when acting on a PPO.
5003: -- Not using distribution_type due to dependency issues.

Line 5020: , PO_SESSION_GT IDS

5016: SELECT POD.po_distribution_id
5017: BULK COLLECT INTO x_distribution_id_tbl
5018: FROM
5019: PO_DISTRIBUTIONS_ALL POD
5020: , PO_SESSION_GT IDS
5021: WHERE POD.line_location_id = IDS.num1
5022: AND IDS.key = l_doc_level_id_key
5023: ;
5024:

Line 5141: -- PO_SESSION_GT column mapping

5137:
5138: -- Load the entity ids into the scratchpad.
5139:
5140: ---------------------------------------
5141: -- PO_SESSION_GT column mapping
5142: --
5143: -- num1 document_level_id
5144: ---------------------------------------
5145:

Line 5151: INSERT INTO PO_SESSION_GT ( key, num1 )

5147:
5148: l_progress := '210';
5149:
5150: FORALL i IN 1 .. p_doc_level_id_tbl.COUNT
5151: INSERT INTO PO_SESSION_GT ( key, num1 )
5152: VALUES ( l_doc_level_id_key, p_doc_level_id_tbl(i) )
5153: ;
5154:
5155: l_progress := '220';

Line 5206: , PO_SESSION_GT IDS

5202: x_distribution_id_tbl
5203: , x_distribution_rev_num_tbl
5204: FROM
5205: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5206: , PO_SESSION_GT IDS
5207: WHERE POD.po_release_id = IDS.num1
5208: AND IDS.key = l_doc_level_id_key
5209: AND ( (l_revision_specified_flag = 'Y'
5210: AND POD.latest_external_flag = 'Y')

Line 5237: , PO_SESSION_GT IDS

5233: x_distribution_id_tbl
5234: , x_distribution_rev_num_tbl
5235: FROM
5236: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5237: , PO_SESSION_GT IDS
5238: WHERE POD.po_header_id = IDS.num1
5239: AND POD.po_release_id IS NULL
5240: -- Don't pick up Release distributions when acting on a PPO/BPA/GA.
5241: -- Not using distribution_type due to dependency issues.

Line 5271: , PO_SESSION_GT IDS

5267: x_distribution_id_tbl
5268: , x_distribution_rev_num_tbl
5269: FROM
5270: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5271: , PO_SESSION_GT IDS
5272: WHERE POD.po_line_id = IDS.num1
5273: AND POD.po_release_id IS NULL
5274: -- Don't pick up SR distributions when acting on a PPO.
5275: -- Not using distribution_type due to dependency issues.

Line 5305: , PO_SESSION_GT IDS

5301: x_distribution_id_tbl
5302: , x_distribution_rev_num_tbl
5303: FROM
5304: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5305: , PO_SESSION_GT IDS
5306: WHERE POD.line_location_id = IDS.num1
5307: AND IDS.key = l_doc_level_id_key
5308: AND ( (l_revision_specified_flag = 'Y'
5309: AND POD.latest_external_flag = 'Y')

Line 5336: , PO_SESSION_GT IDS

5332: x_distribution_id_tbl
5333: , x_distribution_rev_num_tbl
5334: FROM
5335: PO_DISTRIBUTIONS_ARCHIVE_ALL POD
5336: , PO_SESSION_GT IDS
5337: WHERE POD.po_distribution_id = IDS.num1
5338: AND IDS.key = l_doc_level_id_key
5339: AND ( (l_revision_specified_flag = 'Y'
5340: AND POD.latest_external_flag = 'Y')

Line 6918: -- PO_SESSION_GT_S

6914: --Name: get_session_gt_nextval
6915: --Pre-reqs:
6916: -- None.
6917: --Modifies:
6918: -- PO_SESSION_GT_S
6919: --Locks:
6920: -- None.
6921: --Function:
6922: -- Retrieves the next sequence number from the PO_SESSION_GT_S sequence.

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

6918: -- PO_SESSION_GT_S
6919: --Locks:
6920: -- None.
6921: --Function:
6922: -- Retrieves the next sequence number from the PO_SESSION_GT_S sequence.
6923: --Returns:
6924: -- PO_SESSION_GT_S.nextval
6925: --End of Comments
6926: --------------------------------------------------------------------------------

Line 6924: -- PO_SESSION_GT_S.nextval

6920: -- None.
6921: --Function:
6922: -- Retrieves the next sequence number from the PO_SESSION_GT_S sequence.
6923: --Returns:
6924: -- PO_SESSION_GT_S.nextval
6925: --End of Comments
6926: --------------------------------------------------------------------------------
6927: FUNCTION get_session_gt_nextval
6928: RETURN NUMBER

Line 6945: SELECT PO_SESSION_GT_S.nextval

6941: END IF;
6942:
6943: l_progress := '010';
6944:
6945: SELECT PO_SESSION_GT_S.nextval
6946: INTO x_nextval
6947: FROM DUAL
6948: ;
6949: