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 1568: IF (i.modifier_level_code IN (QP_PREQ_PUB.G_LINE_LEVEL, QP_PREQ_PUB.G_ORDER_LEVEL)) THEN

1564: When OTHERS Then
1565: l_volume_attribute := null;
1566: END;
1567:
1568: IF (i.modifier_level_code IN (QP_PREQ_PUB.G_LINE_LEVEL, QP_PREQ_PUB.G_ORDER_LEVEL)) THEN
1569: IF l_volume_attribute = QP_PREQ_PUB.G_QUANTITY_ATTRIBUTE THEN
1570: l_total_value := 0;
1571: l_req_value_per_unit := v_request_qty;
1572: ELSE

Line 1569: IF l_volume_attribute = QP_PREQ_PUB.G_QUANTITY_ATTRIBUTE THEN

1565: l_volume_attribute := null;
1566: END;
1567:
1568: IF (i.modifier_level_code IN (QP_PREQ_PUB.G_LINE_LEVEL, QP_PREQ_PUB.G_ORDER_LEVEL)) THEN
1569: IF l_volume_attribute = QP_PREQ_PUB.G_QUANTITY_ATTRIBUTE THEN
1570: l_total_value := 0;
1571: l_req_value_per_unit := v_request_qty;
1572: ELSE
1573: l_total_value := i.line_quantity;

Line 1577: IF l_volume_attribute = QP_PREQ_PUB.G_QUANTITY_ATTRIBUTE THEN

1573: l_total_value := i.line_quantity;
1574: l_req_value_per_unit := v_request_qty;
1575: END IF;
1576: ELSE -- linegroup
1577: IF l_volume_attribute = QP_PREQ_PUB.G_QUANTITY_ATTRIBUTE THEN
1578: l_total_value := 0;
1579: l_req_value_per_unit := i.group_quantity;
1580: ELSE
1581: l_total_value := i.line_quantity;

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

1709: END IF;
1710:
1711: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1712: UPDATE qp_npreq_lines_tmp
1713: SET pricing_status_code = QP_PREQ_PUB.G_NOT_VALID, process_status = QP_PREQ_PUB.G_NOT_VALID
1714: WHERE line_index = p_line_index_tbl(i)
1715: and line_id is null; --bug 7539796
1716: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1717: UPDATE qp_npreq_ldets_tmp

Line 1718: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,

1714: WHERE line_index = p_line_index_tbl(i)
1715: and line_id is null; --bug 7539796
1716: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1717: UPDATE qp_npreq_ldets_tmp
1718: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1719: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,2000)
1720: WHERE LINE_INDEX = p_line_index_tbl(i);
1721: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1722: UPDATE qp_npreq_line_attrs_tmp

Line 1723: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,

1719: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,2000)
1720: WHERE LINE_INDEX = p_line_index_tbl(i);
1721: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1722: UPDATE qp_npreq_line_attrs_tmp
1723: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1724: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,240)
1725: WHERE LINE_INDEX = p_line_index_tbl(i);
1726: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1727: UPDATE qp_npreq_rltd_lines_tmp

Line 1728: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,

1724: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,240)
1725: WHERE LINE_INDEX = p_line_index_tbl(i);
1726: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1727: UPDATE qp_npreq_rltd_lines_tmp
1728: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1729: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,240)
1730: WHERE RELATED_LINE_INDEX = p_line_index_tbl(i);
1731: EXCEPTION
1732: WHEN OTHERS THEN

Line 1749: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,

1745: END IF;
1746:
1747: FORALL i IN p_line_detail_index_tbl.FIRST..p_line_detail_index_tbl.LAST
1748: UPDATE qp_npreq_ldets_tmp a
1749: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1750: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,2000)
1751: WHERE LINE_DETAIL_INDEX = p_line_detail_index_tbl(i) OR
1752: EXISTS (SELECT 1 --[julin/4671446] also deleting children ldets
1753: FROM qp_npreq_rltd_lines_tmp

Line 1758: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,

1754: WHERE LINE_DETAIL_INDEX = p_line_detail_index_tbl(i)
1755: AND RELATED_LINE_DETAIL_INDEX = a.LINE_DETAIL_INDEX);
1756: FORALL i IN p_line_detail_index_tbl.FIRST..p_line_detail_index_tbl.LAST
1757: UPDATE qp_npreq_rltd_lines_tmp
1758: SET PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_DELETED,
1759: PRICING_STATUS_TEXT = substr(p_pricing_status_text,1,240)
1760: WHERE (LINE_DETAIL_INDEX = p_line_detail_index_tbl(i) OR
1761: RELATED_LINE_DETAIL_INDEX = p_line_detail_index_tbl(i)); --[julin/4671446] also deleting children ldets
1762: EXCEPTION