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 1025: , PO_ATTRIBUTE_VALUES POATR

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

Line 1110: , PO_ATTRIBUTE_VALUES_TLP POTLP

1106: , POH.po_header_id -- PO_HEADER_ID (Internal to PO Dev, not required by iProc)
1107: , 'BLANKET:TLP' -- DATA INFO: Internal to PO
1108: FROM PO_LINES_ALL POL
1109: , PO_HEADERS_ALL POH
1110: , PO_ATTRIBUTE_VALUES_TLP POTLP
1111: , PO_SESSION_GT GT_REMAINING_HDRS
1112: WHERE GT_REMAINING_HDRS.key = p_key_remaining_headers
1113: AND POH.po_header_id = GT_REMAINING_HDRS.index_num1 -- index_num1 stores the PO_HEADER_ID
1114: AND POL.po_header_id = POH.po_header_id

Line 1418: -- PO_ATTRIBUTE_VALUES_TLP.item_description

1414: --Name: synch_item_description
1415: --Pre-reqs:
1416: -- None
1417: --Modifies:
1418: -- PO_ATTRIBUTE_VALUES_TLP.item_description
1419: --Locks:
1420: -- None.
1421: --Function:
1422: -- When the item description is updated on a Blanket PO Line, it has to be

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

1423: -- updated in the TLP level as well, so that the line is searchable with the
1424: -- new description.
1425: -- This procedure is called from the ON-UPDATE trigger of the Enter PO
1426: -- form if the type_lookup_code is BLANKET. It updates the
1427: -- PO_ATTRIBUTE_VALUES_TLP.item_description column with the description
1428: -- at the line level.
1429: -- This also works the same for QUOTATIONS and REQ-TEMPLATE lines.
1430: --
1431: --Parameters:

Line 1532: UPDATE PO_ATTRIBUTE_VALUES_TLP POTLP

1528:
1529: l_progress := '050';
1530: -- For all the lines whose description have changed, update the TLP records as well.
1531: FORALL i IN 1 .. l_po_line_id_list.COUNT
1532: UPDATE PO_ATTRIBUTE_VALUES_TLP POTLP
1533: SET description = l_item_description_list(i)
1534: WHERE POTLP.po_line_id = l_po_line_id_list(i)
1535: AND language = l_created_lang_list(i);
1536:

Line 1570: UPDATE PO_ATTRIBUTE_VALUES_TLP POTLP

1566:
1567: l_progress := '080';
1568: -- For all the lines whose description have changed, update the TLP records as well.
1569: FORALL i IN 1 .. l_req_template_line_num_list.COUNT
1570: UPDATE PO_ATTRIBUTE_VALUES_TLP POTLP
1571: SET description = l_item_description_list(i)
1572: WHERE POTLP.req_template_name = l_req_template_name_list(i)
1573: AND req_template_line_num = l_req_template_line_num_list(i)
1574: AND org_id = l_req_template_org_id_list(i)

Line 1595: -- PO_ATTRIBUTE_VALUES.ip_category_id

1591: --Name: synch_item_category
1592: --Pre-reqs:
1593: -- None
1594: --Modifies:
1595: -- PO_ATTRIBUTE_VALUES.ip_category_id
1596: -- PO_ATTRIBUTE_VALUES_TLP.ip_category_id
1597: --Locks:
1598: -- None.
1599: --Function:

Line 1596: -- PO_ATTRIBUTE_VALUES_TLP.ip_category_id

1592: --Pre-reqs:
1593: -- None
1594: --Modifies:
1595: -- PO_ATTRIBUTE_VALUES.ip_category_id
1596: -- PO_ATTRIBUTE_VALUES_TLP.ip_category_id
1597: --Locks:
1598: -- None.
1599: --Function:
1600: -- When the item category is updated on a Blanket PO Line, it has to be updated

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

1601: -- in the attribute (TLP) level as well, so that the line is searchable with
1602: -- the new category.
1603: -- This procedure is called from the ON-UPDATE trigger of the Enter PO
1604: -- form if the type_lookup_code is BLANKET. It updates the
1605: -- PO_ATTRIBUTE_VALUES(TLP).ip_category_id column with the category
1606: -- at the line level.
1607: -- This also works the same for QUOTATIONS and REQ-TEMPLATE lines.
1608: --
1609: --Parameters:

Line 1688: PO_ATTRIBUTE_VALUES POATR,

1684: l_category_id_list,
1685: l_old_ip_category_id_list
1686: FROM PO_LINES_ALL POL,
1687: PO_HEADERS_ALL POH,
1688: PO_ATTRIBUTE_VALUES POATR,
1689: PO_SESSION_GT INPUT_HDRS
1690: WHERE POH.po_header_id = INPUT_HDRS.index_num1
1691: AND INPUT_HDRS.key = l_key
1692: AND POL.po_header_id = POH.po_header_id

Line 1700: -- PO_ATTRIBUTE_VALUES and PO_ATTRIBUTE_VALUES_TLP

1696: 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;
1697:
1698: l_progress := '050';
1699: -- Get the ip_category_id for all the po lines selected above and update
1700: -- PO_ATTRIBUTE_VALUES and PO_ATTRIBUTE_VALUES_TLP
1701: FOR i IN 1 .. l_po_line_id_list.COUNT LOOP
1702: PO_ATTRIBUTE_VALUES_PVT.get_ip_category_id(l_category_id_list(i), l_new_ip_category_id);
1703:
1704: -- Update ip_category_id only if changed.

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

1698: l_progress := '050';
1699: -- Get the ip_category_id for all the po lines selected above and update
1700: -- PO_ATTRIBUTE_VALUES and PO_ATTRIBUTE_VALUES_TLP
1701: FOR i IN 1 .. l_po_line_id_list.COUNT LOOP
1702: PO_ATTRIBUTE_VALUES_PVT.get_ip_category_id(l_category_id_list(i), l_new_ip_category_id);
1703:
1704: -- Update ip_category_id only if changed.
1705: IF l_new_ip_category_id <> l_old_ip_category_id_list(i) THEN
1706: UPDATE PO_ATTRIBUTE_VALUES

Line 1706: UPDATE PO_ATTRIBUTE_VALUES

1702: PO_ATTRIBUTE_VALUES_PVT.get_ip_category_id(l_category_id_list(i), l_new_ip_category_id);
1703:
1704: -- Update ip_category_id only if changed.
1705: IF l_new_ip_category_id <> l_old_ip_category_id_list(i) THEN
1706: UPDATE PO_ATTRIBUTE_VALUES
1707: SET ip_category_id = l_new_ip_category_id
1708: WHERE po_line_id = l_po_line_id_list(i);
1709:
1710: UPDATE PO_ATTRIBUTE_VALUES_TLP

Line 1710: UPDATE PO_ATTRIBUTE_VALUES_TLP

1706: UPDATE PO_ATTRIBUTE_VALUES
1707: SET ip_category_id = l_new_ip_category_id
1708: WHERE po_line_id = l_po_line_id_list(i);
1709:
1710: UPDATE PO_ATTRIBUTE_VALUES_TLP
1711: SET ip_category_id = l_new_ip_category_id
1712: WHERE po_line_id = l_po_line_id_list(i);
1713: END IF;
1714: END LOOP;

Line 1734: PO_ATTRIBUTE_VALUES POATR

1730: l_req_template_org_id_list,
1731: l_category_id_list,
1732: l_old_ip_category_id_list
1733: FROM PO_REQEXPRESS_LINES_ALL PORTL,
1734: PO_ATTRIBUTE_VALUES POATR
1735: WHERE PORTL.express_name = p_reqexpress_name
1736: AND PORTL.po_line_id = POATR.po_line_id
1737: AND PORTL.org_id = p_org_id;
1738:

Line 1744: -- PO_ATTRIBUTE_VALUES and PO_ATTRIBUTE_VALUES_TLP

1740:
1741: l_progress := '070';
1742:
1743: -- Get the ip_category_id for all the po lines selected above and update
1744: -- PO_ATTRIBUTE_VALUES and PO_ATTRIBUTE_VALUES_TLP
1745: FOR i IN 1 .. l_req_template_line_num_list.COUNT LOOP
1746: PO_ATTRIBUTE_VALUES_PVT.get_ip_category_id(l_category_id_list(i), l_new_ip_category_id);
1747:
1748: -- Update ip_category_id only if changed.

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

1742:
1743: -- Get the ip_category_id for all the po lines selected above and update
1744: -- PO_ATTRIBUTE_VALUES and PO_ATTRIBUTE_VALUES_TLP
1745: FOR i IN 1 .. l_req_template_line_num_list.COUNT LOOP
1746: PO_ATTRIBUTE_VALUES_PVT.get_ip_category_id(l_category_id_list(i), l_new_ip_category_id);
1747:
1748: -- Update ip_category_id only if changed.
1749: IF l_new_ip_category_id <> l_old_ip_category_id_list(i) THEN
1750: UPDATE PO_ATTRIBUTE_VALUES

Line 1750: UPDATE PO_ATTRIBUTE_VALUES

1746: PO_ATTRIBUTE_VALUES_PVT.get_ip_category_id(l_category_id_list(i), l_new_ip_category_id);
1747:
1748: -- Update ip_category_id only if changed.
1749: IF l_new_ip_category_id <> l_old_ip_category_id_list(i) THEN
1750: UPDATE PO_ATTRIBUTE_VALUES
1751: SET ip_category_id = l_new_ip_category_id
1752: WHERE req_template_name = l_req_template_name_list(i)
1753: AND req_template_line_num = l_req_template_line_num_list(i)
1754: AND org_id = l_req_template_org_id_list(i);

Line 1756: UPDATE PO_ATTRIBUTE_VALUES_TLP

1752: WHERE req_template_name = l_req_template_name_list(i)
1753: AND req_template_line_num = l_req_template_line_num_list(i)
1754: AND org_id = l_req_template_org_id_list(i);
1755:
1756: UPDATE PO_ATTRIBUTE_VALUES_TLP
1757: SET ip_category_id = l_new_ip_category_id
1758: WHERE req_template_name = l_req_template_name_list(i)
1759: AND req_template_line_num = l_req_template_line_num_list(i)
1760: AND org_id = l_req_template_org_id_list(i);