APPS.PO_DRAFTS_PVT dependencies on PO_LINE_LOCATIONS_ALL_EXT_TL

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 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 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 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-