eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CATALOG_INDEX_PVT dependencies on PO_ATTRIBUTE_VALUES

Line 1020: , PO_ATTRIBUTE_VALUES POATR

1016: , POH.po_header_id -- PO_HEADER_ID (Internal to PO Dev, not required by iProc)
1017: , 'BLANKET:ATTR' -- DATA INFO: Internal to PO
1018: FROM PO_LINES_ALL POL
1019: , PO_HEADERS_ALL POH
1020: , PO_ATTRIBUTE_VALUES POATR
1021: , PO_SESSION_GT GT_REMAINING_HDRS
1022: WHERE GT_REMAINING_HDRS.key = p_key_remaining_headers
1023: AND POH.po_header_id = GT_REMAINING_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID
1024: AND POL.po_header_id = POH.po_header_id

Line 1126: , PO_ATTRIBUTE_VALUES_TLP POTLP

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

Line 1456: -- PO_ATTRIBUTE_VALUES_TLP.item_description

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

Line 1465: -- PO_ATTRIBUTE_VALUES_TLP.item_description column with the description

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:

Line 1570: UPDATE PO_ATTRIBUTE_VALUES_TLP POTLP

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:

Line 1608: UPDATE PO_ATTRIBUTE_VALUES_TLP POTLP

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)

Line 1633: -- PO_ATTRIBUTE_VALUES.ip_category_id

1629: --Name: synch_item_category
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:

Line 1634: -- PO_ATTRIBUTE_VALUES_TLP.ip_category_id

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

Line 1643: -- PO_ATTRIBUTE_VALUES(TLP).ip_category_id column with the category

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:

Line 1726: PO_ATTRIBUTE_VALUES POATR,

1722: l_category_id_list,
1723: l_old_ip_category_id_list
1724: FROM PO_LINES_ALL POL,
1725: PO_HEADERS_ALL POH,
1726: PO_ATTRIBUTE_VALUES POATR,
1727: PO_SESSION_GT INPUT_HDRS
1728: WHERE POH.po_header_id = INPUT_HDRS.index_num1
1729: AND INPUT_HDRS.key = l_key
1730: AND POL.po_header_id = POH.po_header_id

Line 1738: -- PO_ATTRIBUTE_VALUES and PO_ATTRIBUTE_VALUES_TLP

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.

Line 1740: PO_ATTRIBUTE_VALUES_PVT.get_ip_category_id(l_category_id_list(i), l_new_ip_category_id);

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.
1743: IF l_new_ip_category_id <> l_old_ip_category_id_list(i) THEN
1744: UPDATE PO_ATTRIBUTE_VALUES

Line 1744: UPDATE PO_ATTRIBUTE_VALUES

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.
1743: IF l_new_ip_category_id <> l_old_ip_category_id_list(i) THEN
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

Line 1748: UPDATE PO_ATTRIBUTE_VALUES_TLP

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;

Line 1772: PO_ATTRIBUTE_VALUES POATR

1768: l_req_template_org_id_list,
1769: l_category_id_list,
1770: l_old_ip_category_id_list
1771: FROM PO_REQEXPRESS_LINES_ALL PORTL,
1772: PO_ATTRIBUTE_VALUES POATR
1773: WHERE PORTL.express_name = p_reqexpress_name
1774: AND PORTL.po_line_id = POATR.po_line_id
1775: AND PORTL.org_id = p_org_id;
1776:

Line 1782: -- PO_ATTRIBUTE_VALUES and PO_ATTRIBUTE_VALUES_TLP

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.

Line 1784: PO_ATTRIBUTE_VALUES_PVT.get_ip_category_id(l_category_id_list(i), l_new_ip_category_id);

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.
1787: IF l_new_ip_category_id <> l_old_ip_category_id_list(i) THEN
1788: UPDATE PO_ATTRIBUTE_VALUES

Line 1788: UPDATE PO_ATTRIBUTE_VALUES

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.
1787: IF l_new_ip_category_id <> l_old_ip_category_id_list(i) THEN
1788: UPDATE PO_ATTRIBUTE_VALUES
1789: SET ip_category_id = l_new_ip_category_id
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);

Line 1794: UPDATE PO_ATTRIBUTE_VALUES_TLP

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);