[Home] [Help]
1122: , POH.po_header_id -- PO_HEADER_ID (Internal to PO Dev, not required by iProc)
1123: , 'BLANKET:TLP' -- DATA INFO: Internal to PO
1124: FROM PO_LINES_ALL POL
1125: , PO_HEADERS_ALL POH
1126: , PO_ATTRIBUTE_VALUES_TLP POTLP
1127: , PO_SESSION_GT GT_REMAINING_HDRS
1128: WHERE GT_REMAINING_HDRS.key = p_key_remaining_headers
1129: AND POH.po_header_id = GT_REMAINING_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID
1130: AND POL.po_header_id = POH.po_header_id
1452: --Name: synch_item_description
1453: --Pre-reqs:
1454: -- None
1455: --Modifies:
1456: -- PO_ATTRIBUTE_VALUES_TLP.item_description
1457: --Locks:
1458: -- None.
1459: --Function:
1460: -- When the item description is updated on a Blanket PO Line, it has to be
1461: -- updated in the TLP level as well, so that the line is searchable with the
1462: -- new description.
1463: -- This procedure is called from the ON-UPDATE trigger of the Enter PO
1464: -- form if the type_lookup_code is BLANKET. It updates the
1465: -- PO_ATTRIBUTE_VALUES_TLP.item_description column with the description
1466: -- at the line level.
1467: -- This also works the same for QUOTATIONS and REQ-TEMPLATE lines.
1468: --
1469: --Parameters:
1566:
1567: l_progress := '050';
1568: -- For all the lines whose description have changed, update the TLP records as well.
1569: FORALL i IN 1 .. l_po_line_id_list.COUNT
1570: UPDATE PO_ATTRIBUTE_VALUES_TLP POTLP
1571: SET description = l_item_description_list(i)
1572: WHERE POTLP.po_line_id = l_po_line_id_list(i)
1573: AND language = l_created_lang_list(i);
1574:
1604:
1605: l_progress := '080';
1606: -- For all the lines whose description have changed, update the TLP records as well.
1607: FORALL i IN 1 .. l_req_template_line_num_list.COUNT
1608: UPDATE PO_ATTRIBUTE_VALUES_TLP POTLP
1609: SET description = l_item_description_list(i)
1610: WHERE POTLP.req_template_name = l_req_template_name_list(i)
1611: AND req_template_line_num = l_req_template_line_num_list(i)
1612: AND org_id = l_req_template_org_id_list(i)
1630: --Pre-reqs:
1631: -- None
1632: --Modifies:
1633: -- PO_ATTRIBUTE_VALUES.ip_category_id
1634: -- PO_ATTRIBUTE_VALUES_TLP.ip_category_id
1635: --Locks:
1636: -- None.
1637: --Function:
1638: -- When the item category is updated on a Blanket PO Line, it has to be updated
1639: -- in the attribute (TLP) level as well, so that the line is searchable with
1640: -- the new category.
1641: -- This procedure is called from the ON-UPDATE trigger of the Enter PO
1642: -- form if the type_lookup_code is BLANKET. It updates the
1643: -- PO_ATTRIBUTE_VALUES(TLP).ip_category_id column with the category
1644: -- at the line level.
1645: -- This also works the same for QUOTATIONS and REQ-TEMPLATE lines.
1646: --
1647: --Parameters:
1734: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_LINE category ids selected to synch='||SQL%rowcount); END IF;
1735:
1736: l_progress := '050';
1737: -- Get the ip_category_id for all the po lines selected above and update
1738: -- PO_ATTRIBUTE_VALUES and PO_ATTRIBUTE_VALUES_TLP
1739: FOR i IN 1 .. l_po_line_id_list.COUNT LOOP
1740: PO_ATTRIBUTE_VALUES_PVT.get_ip_category_id(l_category_id_list(i), l_new_ip_category_id);
1741:
1742: -- Update ip_category_id only if changed.
1744: UPDATE PO_ATTRIBUTE_VALUES
1745: SET ip_category_id = l_new_ip_category_id
1746: WHERE po_line_id = l_po_line_id_list(i);
1747:
1748: UPDATE PO_ATTRIBUTE_VALUES_TLP
1749: SET ip_category_id = l_new_ip_category_id
1750: WHERE po_line_id = l_po_line_id_list(i);
1751: END IF;
1752: END LOOP;
1778:
1779: l_progress := '070';
1780:
1781: -- Get the ip_category_id for all the po lines selected above and update
1782: -- PO_ATTRIBUTE_VALUES and PO_ATTRIBUTE_VALUES_TLP
1783: FOR i IN 1 .. l_req_template_line_num_list.COUNT LOOP
1784: PO_ATTRIBUTE_VALUES_PVT.get_ip_category_id(l_category_id_list(i), l_new_ip_category_id);
1785:
1786: -- Update ip_category_id only if changed.
1790: WHERE req_template_name = l_req_template_name_list(i)
1791: AND req_template_line_num = l_req_template_line_num_list(i)
1792: AND org_id = l_req_template_org_id_list(i);
1793:
1794: UPDATE PO_ATTRIBUTE_VALUES_TLP
1795: SET ip_category_id = l_new_ip_category_id
1796: WHERE req_template_name = l_req_template_name_list(i)
1797: AND req_template_line_num = l_req_template_line_num_list(i)
1798: AND org_id = l_req_template_org_id_list(i);