APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_ATTRIBUTE_VALUES_TLP_DRAFT

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

356: l_uom_warning_queue DBMS_SQL.NUMBER_TABLE;
357: l_price_limit_queue DBMS_SQL.NUMBER_TABLE;
358:
359: -- index of the po line for which description is changed;
360: -- we may need to update po_attribute_values_tlp_draft table
361: l_update_desc_queue DBMS_SQL.NUMBER_TABLE;
362: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;
363: l_sync_attr_id_tbl PO_TBL_NUMBER; --
364:

Line 698: -- field in po_attribute_values_tlp_draft

694: IF (l_item_desc_tbl(l_index) <> x_lines.item_desc_tbl(i)) THEN
695: l_item_desc_tbl(l_index) := x_lines.item_desc_tbl(i);
696:
697: -- record down the index because we may need to change description
698: -- field in po_attribute_values_tlp_draft
699: l_update_desc_queue(i) := i;
700: END IF;
701: END IF;
702:

Line 1447: UPDATE po_attribute_values_tlp_draft

1443: d_position := 360;
1444:
1445: -- c. update records in draft table
1446: FORALL i IN 1..l_sync_attr_tlp_id_tbl.COUNT
1447: UPDATE po_attribute_values_tlp_draft
1448: SET description = l_item_desc_tbl(i),
1449: ip_category_id = NVL(l_modified_ip_cat_id_tbl_tmp(i), ip_category_id) --
1450: WHERE attribute_values_tlp_id = l_sync_attr_tlp_id_tbl(i)
1451: AND draft_id = l_draft_id_tbl(i);

Line 4883: -- into po_attribute_values_tlp_draft

4879: --Start of Comments
4880: --Name: merge_po_attr_values_tlp_draft
4881: --Function:
4882: -- insert new attribute tlp values or update existing tlp values
4883: -- into po_attribute_values_tlp_draft
4884: --Parameters:
4885: --IN:
4886: --p_key
4887: -- key value used to join with gt table

Line 4914: MERGE INTO po_attribute_values_tlp_draft PAVTD

4910: IF (PO_LOG.d_proc) THEN
4911: PO_LOG.proc_begin(d_module);
4912: END IF;
4913:
4914: MERGE INTO po_attribute_values_tlp_draft PAVTD
4915: USING (
4916: SELECT
4917: NUM2 AS ATTRIBUTE_VALUES_TLP_ID,
4918: NUM3 AS DRAFT_ID,

Line 5879: UPDATE po_attribute_values_tlp_draft

5875: d_position := 70;
5876:
5877: -- update records in draft table
5878: FORALL i IN 1..l_sync_attr_values_tlp_id_tbl.COUNT
5879: UPDATE po_attribute_values_tlp_draft
5880: SET TL_TEXT_CAT_ATTRIBUTE1 = NULL,
5881: TL_TEXT_CAT_ATTRIBUTE2 = NULL,
5882: TL_TEXT_CAT_ATTRIBUTE3 = NULL,
5883: TL_TEXT_CAT_ATTRIBUTE4 = NULL,