APPS.QP_RESOLVE_INCOMPATABILITY_PVT dependencies on QP_NPREQ_RLTD_LINES_TMP

Line 1727: UPDATE qp_npreq_rltd_lines_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
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

Line 1753: FROM qp_npreq_rltd_lines_tmp

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

Line 1757: UPDATE qp_npreq_rltd_lines_tmp

1753: FROM qp_npreq_rltd_lines_tmp
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

Line 1782: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd

1778: -- [prarasto/4141235] find loser prg line indexes to be deleted, incompatibility group
1779: --frontported fix done in 4134088
1780: CURSOR l_del_prg_lines_grp_cur IS
1781: SELECT rltd.RELATED_LINE_INDEX
1782: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd
1783: WHERE ldets.INCOMPATABILITY_GRP_CODE = p_incomp_grp_id
1784: AND ldets.LINE_INDEX = p_line_index
1785: AND ldets.PRICING_PHASE_ID = p_pricing_phase_id
1786: AND ldets.CREATED_FROM_LIST_LINE_ID <> p_list_line_id

Line 1796: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd

1792: -- [prarasto/4141235] find loser prg line indexes to be deleted, incompatibility group
1793: --frontported fix done in 4134088
1794: CURSOR l_del_oid_ldets_grp_cur IS
1795: SELECT rltd.RELATED_LINE_DETAIL_INDEX
1796: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd
1797: WHERE ldets.INCOMPATABILITY_GRP_CODE = p_incomp_grp_id
1798: AND ldets.LINE_INDEX = p_line_index
1799: AND ldets.PRICING_PHASE_ID = p_pricing_phase_id
1800: AND ldets.CREATED_FROM_LIST_LINE_ID <> p_list_line_id

Line 1810: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd

1806: -- [prarasto/4141235] find loser prg line indexes to be deleted, incompatibility group
1807: --frontported fix done in 4134088
1808: CURSOR l_del_prg_lines_excl_cur IS
1809: SELECT rltd.RELATED_LINE_INDEX
1810: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd
1811: WHERE ldets.LINE_INDEX = p_line_index
1812: AND ldets.PRICING_PHASE_ID = p_pricing_phase_id
1813: AND ldets.CREATED_FROM_LIST_LINE_ID <> p_list_line_id
1814: AND ldets.LINE_DETAIL_TYPE_CODE <> QP_PREQ_GRP.G_CHILD_DETAIL_TYPE

Line 1823: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd

1819: -- [prarasto/4141235] find loser prg line indexes to be deleted, incompatibility group
1820: --frontported fix done in 4134088
1821: CURSOR l_del_oid_ldets_excl_cur IS
1822: SELECT rltd.RELATED_LINE_DETAIL_INDEX
1823: FROM qp_npreq_ldets_tmp ldets, qp_npreq_rltd_lines_tmp rltd
1824: WHERE ldets.LINE_INDEX = p_line_index
1825: AND ldets.PRICING_PHASE_ID = p_pricing_phase_id
1826: AND ldets.CREATED_FROM_LIST_LINE_ID <> p_list_line_id
1827: AND ldets.LINE_DETAIL_TYPE_CODE <> QP_PREQ_GRP.G_CHILD_DETAIL_TYPE