APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_ATTRIBUTE_VALUES_TLP_DRAFT

Line 352: -- we may need to update po_attribute_values_tlp_draft table

348: l_uom_warning_queue DBMS_SQL.NUMBER_TABLE;
349: l_price_limit_queue DBMS_SQL.NUMBER_TABLE;
350:
351: -- index of the po line for which description is changed;
352: -- we may need to update po_attribute_values_tlp_draft table
353: l_update_desc_queue DBMS_SQL.NUMBER_TABLE;
354: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;
355:
356: -- lines for which we need to null out the cat based attribute values

Line 653: -- field in po_attribute_values_tlp_draft

649: IF (l_item_desc_tbl(l_index) <> x_lines.item_desc_tbl(i)) THEN
650: l_item_desc_tbl(l_index) := x_lines.item_desc_tbl(i);
651:
652: -- record down the index because we may need to change description
653: -- field in po_attribute_values_tlp_draft
654: l_update_desc_queue(i) := i;
655: END IF;
656: END IF;
657:

Line 1254: UPDATE po_attribute_values_tlp_draft

1250: d_position := 360;
1251:
1252: -- c. update records in draft table
1253: FORALL i IN 1..l_sync_attr_tlp_id_tbl.COUNT
1254: UPDATE po_attribute_values_tlp_draft
1255: SET description = l_item_desc_tbl(i)
1256: WHERE attribute_values_tlp_id = l_sync_attr_tlp_id_tbl(i)
1257: AND draft_id = l_draft_id_tbl(i);
1258:

Line 4543: -- into po_attribute_values_tlp_draft

4539: --Start of Comments
4540: --Name: merge_po_attr_values_tlp_draft
4541: --Function:
4542: -- insert new attribute tlp values or update existing tlp values
4543: -- into po_attribute_values_tlp_draft
4544: --Parameters:
4545: --IN:
4546: --p_key
4547: -- key value used to join with gt table

Line 4574: MERGE INTO po_attribute_values_tlp_draft PAVTD

4570: IF (PO_LOG.d_proc) THEN
4571: PO_LOG.proc_begin(d_module);
4572: END IF;
4573:
4574: MERGE INTO po_attribute_values_tlp_draft PAVTD
4575: USING (
4576: SELECT
4577: NUM2 AS ATTRIBUTE_VALUES_TLP_ID,
4578: NUM3 AS DRAFT_ID,

Line 5539: UPDATE po_attribute_values_tlp_draft

5535: d_position := 70;
5536:
5537: -- update records in draft table
5538: FORALL i IN 1..l_sync_attr_values_tlp_id_tbl.COUNT
5539: UPDATE po_attribute_values_tlp_draft
5540: SET TL_TEXT_CAT_ATTRIBUTE1 = NULL,
5541: TL_TEXT_CAT_ATTRIBUTE2 = NULL,
5542: TL_TEXT_CAT_ATTRIBUTE3 = NULL,
5543: TL_TEXT_CAT_ATTRIBUTE4 = NULL,