APPS.PO_DRAFTS_PVT dependencies on PO_ATTRIBUTE_VALUES_TLP

Line 3828: UPDATE po_attribute_values_tlp_draft

3824: WHERE draft_id = p_draft_id
3825: AND change_accepted_flag IS NULL;
3826:
3827: d_position := 110;
3828: UPDATE po_attribute_values_tlp_draft
3829: SET change_accepted_flag = l_change_accepted_flag
3830: WHERE draft_id = p_draft_id
3831: AND change_accepted_flag IS NULL;
3832:

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 4791: -- Identify Line level locks required because of change in po_attribute_values_tlp

4787: PO_LOG.stmt_all_session_gt(d_module, d_position, G_LOCKS_REQUIRED_ID);
4788: PO_LOG.stmt(d_module,d_position ,'number of rows Inserted ',SQL%ROWCOUNT);
4789: END IF;
4790:
4791: -- Identify Line level locks required because of change in po_attribute_values_tlp
4792: INSERT INTO po_session_gt(
4793: key,
4794: index_char1, -- records identifier
4795: index_char2, -- entity_name

Line 4818: FROM po_attribute_values_tlp poavt,

4814: NVL(poavt.ALIAS ,G_NULL_CHAR),
4815: NVL(poavt.comments ,G_NULL_CHAR)
4816: ) p_lock_attrs,
4817: poavt.attribute_values_tlp_id
4818: FROM po_attribute_values_tlp poavt,
4819: po_session_gt pogt
4820: WHERE poavt.po_line_id = pogt.char1 -- po_line_id
4821: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
4822: AND pogt.index_char2 = G_LOCK_LINE_ENTITY

Line 4833: FROM po_attribute_values_tlp_draft poavtd,

4829: NVL(poavtd.ALIAS ,G_NULL_CHAR),
4830: NVL(poavtd.comments ,G_NULL_CHAR)
4831: ) p_lock_attrs,
4832: poavtd.attribute_values_tlp_id
4833: FROM po_attribute_values_tlp_draft poavtd,
4834: po_session_gt pogt
4835: WHERE poavtd.draft_id = p_draft_id
4836: AND poavtd.po_line_id = pogt.char1 -- po_line_id
4837: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID