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_DRAFTS_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 396: UPDATE po_line_locations_all plla

392: )
393: AND pla.po_header_id = p_po_header_id;
394:
395: -- Update the revision number for all line_location locked by the current mod
396: UPDATE po_line_locations_all plla
397: SET revision_num = l_header_revision
398: WHERE EXISTS ( SELECT 'Lock exists for the shipment'
399: FROM po_entity_locks poel
400: WHERE poel.entity_pk1 = plla.line_location_id

Line 4011: -- po_headers_all, po_lines_all, po_line_locations_all, po_distributions_all,

4007: --Pre-reqs: None
4008: --Modifies:
4009: -- po_entity_locks
4010: --Locks:
4011: -- po_headers_all, po_lines_all, po_line_locations_all, po_distributions_all,
4012: -- po_headers_all_ext_b,po_lines_all_ext_b,po_line_locations_all_ext_b,
4013: -- po_distributions_all_ext_b, tl tables
4014: --Function:
4015: -- This procedure generates the change data for the passed entities PKs,

Line 4012: -- po_headers_all_ext_b,po_lines_all_ext_b,po_line_locations_all_ext_b,

4008: --Modifies:
4009: -- po_entity_locks
4010: --Locks:
4011: -- po_headers_all, po_lines_all, po_line_locations_all, po_distributions_all,
4012: -- po_headers_all_ext_b,po_lines_all_ext_b,po_line_locations_all_ext_b,
4013: -- po_distributions_all_ext_b, tl tables
4014: --Function:
4015: -- This procedure generates the change data for the passed entities PKs,
4016: -- creates entries in po_entity_locks table corresponding to the modified

Line 4879: FROM po_line_locations_all ppbr,

4875: NVL(ppbr.start_date ,G_NULL_DATE),
4876: NVL(ppbr.end_date ,G_NULL_DATE)
4877: ) p_lock_attrs ,
4878: ppbr.line_location_id
4879: FROM po_line_locations_all ppbr,
4880: po_session_gt pogt
4881: WHERE ppbr.po_line_id = pogt.char1 -- po_header_id
4882: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
4883: AND pogt.index_char2 = G_LOCK_LINE_ENTITY

Line 4999: FROM po_line_locations_all poll_base

4995: WHERE poll_draft.po_line_id = pol.po_line_id
4996: AND poll_draft.draft_id = p_draft_id
4997: MINUS
4998: SELECT line_location_id
4999: FROM po_line_locations_all poll_base
5000: WHERE poll_base.po_line_id = pol.po_line_id
5001: )
5002: AND pol.po_header_id = dft.document_id
5003: AND dft.draft_id = p_draft_id;

Line 5057: -- po_line_locations_all, locks because of line F lock.

5053: --Pre-reqs: None
5054: --Modifies:
5055: -- po_entity_locks
5056: --Locks:
5057: -- po_line_locations_all, locks because of line F lock.
5058: --Function:
5059: -- This procedure generates the change data for the passed entities PKs,
5060: -- creates entries in po_entity_locks table corresponding to the modified
5061: -- attributes, and locks the required rows in transaction tables.

Line 5163: FROM po_line_locations_all poll,

5159: NVL(poll.ship_to_organization_id ,G_NULL_NUM),
5160: NVL(poll.unit_meas_lookup_code, G_NULL_CHAR),
5161: NVL(poll.transaction_flow_header_id ,G_NULL_NUM)
5162: ) f_lock_attrs
5163: FROM po_line_locations_all poll,
5164: po_session_gt pogt
5165: WHERE poll.line_location_id = pogt.char1 -- po_line_id
5166: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
5167: AND pogt.index_char2 = G_LOCK_SHIPMENT_ENTITY

Line 5267: FROM po_line_locations_all poll,

5263: G_LOCK_SHIPMENT_ENTITY,
5264: poll.line_location_id,
5265: p_draft_id,
5266: 'F'
5267: FROM po_line_locations_all poll,
5268: po_drafts dft
5269: WHERE poll.po_header_id = dft.document_id
5270: AND dft.draft_id = p_draft_id
5271: AND (EXISTS (SELECT 'Line is modified in current txn and requires F lock'

Line 7348: -- po_line_locations_all_ext_b, po_line_locations_all_ext_tl

7344: --Pre-reqs: None
7345: --Modifies:
7346: -- po_entity_locks
7347: --Locks:
7348: -- po_line_locations_all_ext_b, po_line_locations_all_ext_tl
7349: --Function:
7350: -- This procedure generates the change data for the passed entities PKs,
7351: -- creates entries in po_entity_locks table corresponding to the modified
7352: -- attributes, and locks the required rows in transaction tables.

Line 7375: -- Identify Shipment level locks required because of change in po_line_locations_all_ext_b

7371: IF (PO_LOG.d_proc) THEN
7372: PO_LOG.proc_begin(d_module);
7373: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
7374: END IF;
7375: -- Identify Shipment level locks required because of change in po_line_locations_all_ext_b
7376: INSERT INTO po_session_gt(
7377: key,
7378: index_char1, -- records identifier
7379: index_char2, -- entity_name

Line 7488: FROM po_line_locations_all_ext_b pllb,

7484: NVL(pllb.d_ext_attr9 ,G_NULL_DATE),
7485: NVL(pllb.d_ext_attr10 ,G_NULL_DATE)
7486: ) p_lock_attrs,
7487: pllb.attr_group_id
7488: FROM po_line_locations_all_ext_b pllb,
7489: po_session_gt pogt
7490: WHERE pllb.line_location_id = pogt.char1 -- po_header_id
7491: AND pllb.draft_id = G_DRAFT_ID_MINUS_1
7492: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 7590: FROM po_line_locations_all_ext_b pllbd,

7586: NVL(pllbd.d_ext_attr9 ,G_NULL_DATE),
7587: NVL(pllbd.d_ext_attr10 ,G_NULL_DATE)
7588: ) p_lock_attrs,
7589: pllbd.attr_group_id
7590: FROM po_line_locations_all_ext_b pllbd,
7591: po_session_gt pogt
7592: WHERE pllbd.draft_id = p_draft_id
7593: AND pllbd.line_location_id = pogt.char1 -- line_location_id
7594: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 7608: -- for such attribute groups are not created in po_line_locations_all_ext_b.

7604: END IF;
7605:
7606: -- When a UDA attribute group does not have any attribute which has default
7607: -- value and user also does not enter any attribute value, then records
7608: -- for such attribute groups are not created in po_line_locations_all_ext_b.
7609: -- Now if user modifies such attribute groups in Mod, then a new record is
7610: -- created with the draft_id. We need to identify such records and lock the
7611: -- shipment as P lock.
7612: INSERT INTO po_session_gt(

Line 7633: FROM po_line_locations_all_ext_b draft

7629: AND pllbd.line_location_id = pogt.char1 -- line_location_id
7630: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
7631: AND pogt.index_char2 = G_LOCK_SHIPMENT_ENTITY
7632: AND EXISTS (SELECT draft.attr_group_id
7633: FROM po_line_locations_all_ext_b draft
7634: WHERE draft.line_location_id = pllbd.line_location_id
7635: AND draft.draft_id = p_draft_id
7636: MINUS
7637: SELECT base.attr_group_id

Line 7638: FROM po_line_locations_all_ext_b base

7634: WHERE draft.line_location_id = pllbd.line_location_id
7635: AND draft.draft_id = p_draft_id
7636: MINUS
7637: SELECT base.attr_group_id
7638: FROM po_line_locations_all_ext_b base
7639: WHERE base.line_location_id = pllbd.line_location_id
7640: AND base.draft_id = -1
7641: );
7642:

Line 7648: -- Identify Shipment level locks required because of change in po_line_locations_all_ext_tl

7644: PO_LOG.stmt_all_session_gt(d_module, d_position, G_LOCKS_REQUIRED_ID);
7645: PO_LOG.stmt(d_module,d_position ,'number of rows Inserted ',SQL%ROWCOUNT);
7646: END IF;
7647:
7648: -- Identify Shipment level locks required because of change in po_line_locations_all_ext_tl
7649: INSERT INTO po_session_gt(
7650: key,
7651: index_char1, -- records identifier
7652: index_char2, -- entity_name

Line 7712: FROM po_line_locations_all_ext_tl pllt,

7708: NVL(pllt.tl_ext_attr40 ,G_NULL_CHAR)
7709: ) p_lock_attrs,
7710: pllt.attr_group_id,
7711: pllt.language
7712: FROM po_line_locations_all_ext_tl pllt,
7713: po_session_gt pogt
7714: where pllt.line_location_id = pogt.char1 -- line_location_id
7715: AND pllt.draft_id = G_DRAFT_ID_MINUS_1
7716: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 7765: FROM po_line_locations_all_ext_tl plltd,

7761: NVL(plltd.tl_ext_attr40 ,G_NULL_CHAR)
7762: ) p_lock_attrs,
7763: plltd.attr_group_id,
7764: plltd.language
7765: FROM po_line_locations_all_ext_tl plltd,
7766: po_session_gt pogt
7767: WHERE plltd.draft_id = p_draft_id
7768: AND plltd.line_location_id = pogt.char1 -- po_header_id
7769: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 7960: -- po_headers_all, po_lines_all, po_line_locations_all, po_distributions_all

7956: --Pre-reqs:
7957: -- po_entity_locks is populated
7958: --Modifies: None
7959: --Locks:
7960: -- po_headers_all, po_lines_all, po_line_locations_all, po_distributions_all
7961: --Function:
7962: -- This procedure locks the required rows in transaction tables, and checks if
7963: -- the requested locks are compatible with existing locks.
7964: --Parameters:

Line 8051: FROM po_line_locations_all poll

8047: -- Lock shipment rows
8048: SELECT poll.po_line_id
8049: BULK COLLECT
8050: INTO l_entity_id_tbl
8051: FROM po_line_locations_all poll
8052: WHERE EXISTS (SELECT 'lock exists'
8053: FROM po_entity_locks poel
8054: WHERE poel.entity_name = G_LOCK_SHIPMENT_ENTITY
8055: AND poel.lock_by_draft_id = p_draft_id

Line 8437: FROM po_line_locations_all_ext_b

8433: END IF;
8434:
8435: FORALL itr IN 1..po_ship_ids_tbl.Count
8436: DELETE
8437: FROM po_line_locations_all_ext_b
8438: WHERE line_location_id = po_ship_ids_tbl(itr) AND draft_id = p_po_draft_id;
8439:
8440: FORALL itr IN 1..po_ship_ids_tbl.Count
8441: DELETE

Line 8442: FROM po_line_locations_all_ext_tl

8438: WHERE line_location_id = po_ship_ids_tbl(itr) AND draft_id = p_po_draft_id;
8439:
8440: FORALL itr IN 1..po_ship_ids_tbl.Count
8441: DELETE
8442: FROM po_line_locations_all_ext_tl
8443: WHERE line_location_id = po_ship_ids_tbl(itr) AND draft_id = p_po_draft_id;
8444:
8445: --Bug 13938456
8446: --Delete shipment level attachments other tham modifictaion specific attachments

Line 8515: FROM po_line_locations_all poll

8511: END IF;
8512:
8513: SELECT line_location_id
8514: BULK COLLECT INTO po_line_location_id_tbl
8515: FROM po_line_locations_all poll
8516: WHERE poll.po_line_id IN (SELECT * FROM TABLE(po_line_ids_tbl));
8517:
8518: --UCA Changes Begin.
8519: --Called before line delete as line.org_id needed to determine if uca enabled

Line 8745: DELETE FROM po_line_locations_all_ext_b

8741: WHERE line_location_id = l_line_loc_id_tbl(i)
8742: AND draft_id = p_draft_id;
8743:
8744: FORALL i IN 1..l_line_loc_id_tbl.Count()
8745: DELETE FROM po_line_locations_all_ext_b
8746: WHERE line_location_id = l_line_loc_id_tbl(i)
8747: AND draft_id = p_draft_id;
8748:
8749: FORALL i IN 1..l_line_loc_id_tbl.Count()

Line 8750: DELETE FROM po_line_locations_all_ext_tl

8746: WHERE line_location_id = l_line_loc_id_tbl(i)
8747: AND draft_id = p_draft_id;
8748:
8749: FORALL i IN 1..l_line_loc_id_tbl.Count()
8750: DELETE FROM po_line_locations_all_ext_tl
8751: WHERE line_location_id = l_line_loc_id_tbl(i)
8752: AND draft_id = p_draft_id;
8753:
8754: --Bug 13938456-