APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_ATTRIBUTE_VALUES_DRAFT

Line 1349: UPDATE po_attribute_values_draft

1345: d_position := 336;
1346:
1347: -- c. update records in draft table
1348: FORALL i IN 1..l_sync_attr_id_tbl.COUNT
1349: UPDATE po_attribute_values_draft
1350: SET ip_category_id = l_modified_ip_cat_id_tbl_tmp(i)
1351: WHERE attribute_values_id = l_sync_attr_id_tbl(i)
1352: AND draft_id = l_draft_id_tbl(i);
1353:

Line 1909: -- insert or update attribute values rows into po_attribute_values_draft

1905: WHERE p_attr_values_tlp.error_flag_tbl(i) = FND_API.g_FALSE;
1906:
1907: d_position := 20;
1908:
1909: -- insert or update attribute values rows into po_attribute_values_draft
1910: merge_po_attr_values_tlp_draft
1911: (
1912: p_key => l_key,
1913: p_attr_values_tlp => p_attr_values_tlp

Line 3510: -- into po_attribute_values_draft

3506: --Start of Comments
3507: --Name: merge_po_attr_values_draft
3508: --Function:
3509: -- insert new attribute values or update existing attribute values
3510: -- into po_attribute_values_draft
3511: --Parameters:
3512: --IN:
3513: --p_key
3514: -- key value used to join in MERGE statement

Line 3541: MERGE INTO po_attribute_values_draft PAVD

3537: IF (PO_LOG.d_proc) THEN
3538: PO_LOG.proc_begin(d_module);
3539: END IF;
3540:
3541: MERGE INTO po_attribute_values_draft PAVD
3542: USING (
3543: SELECT
3544: NUM2 AS ATTRIBUTE_VALUES_ID,
3545: NUM3 AS DRAFT_ID,

Line 5726: UPDATE po_attribute_values_draft

5722: d_position := 30;
5723:
5724: -- update records in draft table
5725: FORALL i IN 1..l_sync_attr_values_id_tbl.COUNT
5726: UPDATE po_attribute_values_draft
5727: SET TEXT_CAT_ATTRIBUTE1 = NULL,
5728: TEXT_CAT_ATTRIBUTE2 = NULL,
5729: TEXT_CAT_ATTRIBUTE3 = NULL,
5730: TEXT_CAT_ATTRIBUTE4 = NULL,