APPS.PO_DRAFTS_PVT dependencies on PO_PRICE_DIFFERENTIALS

Line 4494: -- po_lines_all, po_attribute_values, po_attribute_values_tlp, price breaks, po_price_differentials.

4490: --Pre-reqs: None
4491: --Modifies:
4492: -- po_entity_locks
4493: --Locks:
4494: -- po_lines_all, po_attribute_values, po_attribute_values_tlp, price breaks, po_price_differentials.
4495: --Function:
4496: -- This procedure generates the change data for the passed entities PKs,
4497: -- creates entries in po_entity_locks table corresponding to the modified
4498: -- attributes, and locks the required rows in transaction tables.

Line 4915: -- Identify Line level locks required because of change in po_price_differentials

4911: IF (PO_LOG.d_stmt) THEN
4912: PO_LOG.stmt_all_session_gt(d_module, d_position, G_LOCKS_REQUIRED_ID);
4913: PO_LOG.stmt(d_module,d_position ,'number of rows Inserted ',SQL%ROWCOUNT);
4914: END IF;
4915: -- Identify Line level locks required because of change in po_price_differentials
4916: INSERT INTO po_session_gt(
4917: key,
4918: index_char1, -- records identifier
4919: index_char2, -- entity_name

Line 4943: FROM po_price_differentials ppd,

4939: NVL(ppd.min_multiplier ,G_NULL_NUM),
4940: NVL(ppd.max_multiplier ,G_NULL_NUM)
4941: ) p_lock_attrs,
4942: ppd.price_differential_id
4943: FROM po_price_differentials ppd,
4944: po_session_gt pogt
4945: WHERE ppd.entity_id = pogt.char1 -- po_line_id
4946: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
4947: AND pogt.index_char2 = G_LOCK_LINE_ENTITY