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.QP_RESOLVE_INCOMPATABILITY_PVT dependencies on QP_PREQ_PUB

Line 1577: IF (i.modifier_level_code IN (QP_PREQ_PUB.G_LINE_LEVEL, QP_PREQ_PUB.G_ORDER_LEVEL)) THEN

1573: When OTHERS Then
1574: l_volume_attribute := null;
1575: END;
1576:
1577: IF (i.modifier_level_code IN (QP_PREQ_PUB.G_LINE_LEVEL, QP_PREQ_PUB.G_ORDER_LEVEL)) THEN
1578: IF l_volume_attribute = QP_PREQ_PUB.G_QUANTITY_ATTRIBUTE THEN
1579: l_total_value := 0;
1580: l_req_value_per_unit := v_request_qty;
1581: ELSE

Line 1578: IF l_volume_attribute = QP_PREQ_PUB.G_QUANTITY_ATTRIBUTE THEN

1574: l_volume_attribute := null;
1575: END;
1576:
1577: IF (i.modifier_level_code IN (QP_PREQ_PUB.G_LINE_LEVEL, QP_PREQ_PUB.G_ORDER_LEVEL)) THEN
1578: IF l_volume_attribute = QP_PREQ_PUB.G_QUANTITY_ATTRIBUTE THEN
1579: l_total_value := 0;
1580: l_req_value_per_unit := v_request_qty;
1581: ELSE
1582: l_total_value := i.line_quantity;

Line 1586: IF l_volume_attribute = QP_PREQ_PUB.G_QUANTITY_ATTRIBUTE THEN

1582: l_total_value := i.line_quantity;
1583: l_req_value_per_unit := v_request_qty;
1584: END IF;
1585: ELSE -- linegroup
1586: IF l_volume_attribute = QP_PREQ_PUB.G_QUANTITY_ATTRIBUTE THEN
1587: l_total_value := 0;
1588: l_req_value_per_unit := i.group_quantity;
1589: ELSE
1590: l_total_value := i.line_quantity;

Line 1749: SET pricing_status_code = QP_PREQ_PUB.G_NOT_VALID, process_status = QP_PREQ_PUB.G_NOT_VALID

1745: END IF;
1746:
1747: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1748: UPDATE qp_npreq_lines_tmp
1749: SET pricing_status_code = QP_PREQ_PUB.G_NOT_VALID, process_status = QP_PREQ_PUB.G_NOT_VALID
1750: WHERE line_index = p_line_index_tbl(i)
1751: and line_id is null; --bug 7539796
1752: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1753: UPDATE qp_npreq_ldets_tmp

Line 1754: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,

1750: WHERE line_index = p_line_index_tbl(i)
1751: and line_id is null; --bug 7539796
1752: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1753: UPDATE qp_npreq_ldets_tmp
1754: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1755: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,2000)
1756: WHERE LINE_INDEX = p_line_index_tbl(i);
1757: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1758: UPDATE qp_npreq_line_attrs_tmp

Line 1759: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,

1755: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,2000)
1756: WHERE LINE_INDEX = p_line_index_tbl(i);
1757: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1758: UPDATE qp_npreq_line_attrs_tmp
1759: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1760: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,240)
1761: WHERE LINE_INDEX = p_line_index_tbl(i);
1762: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1763: UPDATE qp_npreq_rltd_lines_tmp

Line 1764: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,

1760: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,240)
1761: WHERE LINE_INDEX = p_line_index_tbl(i);
1762: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1763: UPDATE qp_npreq_rltd_lines_tmp
1764: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1765: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,240)
1766: WHERE RELATED_LINE_INDEX = p_line_index_tbl(i);
1767: EXCEPTION
1768: WHEN OTHERS THEN

Line 1785: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,

1781: END IF;
1782:
1783: FORALL i IN p_line_detail_index_tbl.FIRST..p_line_detail_index_tbl.LAST
1784: UPDATE qp_npreq_ldets_tmp a
1785: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1786: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,2000)
1787: WHERE LINE_DETAIL_INDEX = p_line_detail_index_tbl(i) OR
1788: EXISTS (SELECT 1 --[julin/4671446] also deleting children ldets
1789: FROM qp_npreq_rltd_lines_tmp

Line 1794: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,

1790: WHERE LINE_DETAIL_INDEX = p_line_detail_index_tbl(i)
1791: AND RELATED_LINE_DETAIL_INDEX = a.LINE_DETAIL_INDEX);
1792: FORALL i IN p_line_detail_index_tbl.FIRST..p_line_detail_index_tbl.LAST
1793: UPDATE qp_npreq_rltd_lines_tmp
1794: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1795: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,240)
1796: WHERE (LINE_DETAIL_INDEX = p_line_detail_index_tbl(i) OR
1797: RELATED_LINE_DETAIL_INDEX = p_line_detail_index_tbl(i)); --[julin/4671446] also deleting children ldets
1798: EXCEPTION