[Home] [Help]
480:
481: --
482: -- Generate the default translations for the Attribute TLP records.
483: -- (Call this BEFORE complete_transfer because it deletes drafts)
484: PO_ATTRIBUTE_VALUES_PVT.gen_draft_line_translations
485: (
486: p_draft_id => p_draft_id
487: , p_doc_type => l_draft_info.doc_subtype
488: );
3818: WHERE draft_id = p_draft_id
3819: AND change_accepted_flag IS NULL;
3820:
3821: d_position := 100;
3822: UPDATE po_attribute_values_draft
3823: SET change_accepted_flag = l_change_accepted_flag
3824: WHERE draft_id = p_draft_id
3825: AND change_accepted_flag IS NULL;
3826:
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:
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.
4719: PO_LOG.stmt_all_session_gt(d_module, d_position, G_LOCKS_REQUIRED_ID);
4720: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4721: END IF;
4722:
4723: -- Identify Line level locks required because of change in po_attribute_values
4724: INSERT INTO po_session_gt(
4725: key,
4726: index_char1, -- records identifier
4727: index_char2, -- entity_name
4751: nvl(poav.thumbnail_image ,G_NULL_CHAR),
4752: NVL(poav.availability ,G_NULL_CHAR)
4753: ) p_lock_attrs,
4754: poav.attribute_values_id
4755: FROM po_attribute_values poav,
4756: po_session_gt pogt
4757: WHERE poav.po_line_id = pogt.char1 -- po_line_id
4758: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
4759: AND pogt.index_char2 = G_LOCK_LINE_ENTITY
4771: nvl(poavd.thumbnail_image ,G_NULL_CHAR),
4772: NVL(poavd.availability ,G_NULL_CHAR)
4773: ) p_lock_attrs,
4774: poavd.attribute_values_id
4775: FROM po_attribute_values_draft poavd,
4776: po_session_gt pogt
4777: WHERE poavd.draft_id = p_draft_id
4778: AND poavd.po_line_id = pogt.char1 -- po_line_id
4779: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
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
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
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