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_LIMIT_BALANCE_CHECK_PVT dependencies on QP_NPREQ_LDETS_TMP

Line 500: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

496: WHERE line_index = g_limit_balance_line(i).line_index;
497:
498: --Update the ldets_tmp table with the translated error message.
499: /*
500: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
501: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
502: */
503: --sql statement upd2
504: UPDATE qp_npreq_ldets_tmp

Line 501: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

497:
498: --Update the ldets_tmp table with the translated error message.
499: /*
500: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
501: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
502: */
503: --sql statement upd2
504: UPDATE qp_npreq_ldets_tmp
505: SET pricing_status_text = l_message,

Line 504: UPDATE qp_npreq_ldets_tmp

500: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
501: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
502: */
503: --sql statement upd2
504: UPDATE qp_npreq_ldets_tmp
505: SET pricing_status_text = l_message,
506: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
507: WHERE line_index = g_limit_balance_line(i).line_index
508: AND created_from_list_line_id =

Line 544: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

540: WHERE line_index = g_limit_balance_line(i).line_index;
541:
542: --Update the ldets_tmp table with the translated error message.
543: /*
544: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
545: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
546: */
547: --sql statement upd4
548: UPDATE qp_npreq_ldets_tmp

Line 545: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

541:
542: --Update the ldets_tmp table with the translated error message.
543: /*
544: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
545: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
546: */
547: --sql statement upd4
548: UPDATE qp_npreq_ldets_tmp
549: SET pricing_status_text = l_message,

Line 548: UPDATE qp_npreq_ldets_tmp

544: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
545: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
546: */
547: --sql statement upd4
548: UPDATE qp_npreq_ldets_tmp
549: SET pricing_status_text = l_message,
550: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
551: WHERE line_index = g_limit_balance_line(i).line_index
552: AND created_from_list_line_id =

Line 627: INDX,qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

623: WHERE line_index = g_limit_balance_line(i).line_index;
624:
625: --Update the ldets_tmp table with the translated error message.
626: /*
627: INDX,qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
628: INDX qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
629: */
630: --sql statement upd6
631: UPDATE qp_npreq_ldets_tmp

Line 628: INDX qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

624:
625: --Update the ldets_tmp table with the translated error message.
626: /*
627: INDX,qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
628: INDX qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
629: */
630: --sql statement upd6
631: UPDATE qp_npreq_ldets_tmp
632: SET pricing_status_text = l_message,

Line 631: UPDATE qp_npreq_ldets_tmp

627: INDX,qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
628: INDX qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
629: */
630: --sql statement upd6
631: UPDATE qp_npreq_ldets_tmp
632: SET pricing_status_text = l_message,
633: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
634: WHERE line_index = g_limit_balance_line(i).line_index
635: AND created_from_list_line_id =

Line 671: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

667: WHERE line_index = g_limit_balance_line(i).line_index;
668:
669: --Update the ldets_tmp table with the translated error message.
670: /*
671: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
672: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
673: */
674: --sql statement upd8
675: UPDATE qp_npreq_ldets_tmp

Line 672: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

668:
669: --Update the ldets_tmp table with the translated error message.
670: /*
671: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
672: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
673: */
674: --sql statement upd8
675: UPDATE qp_npreq_ldets_tmp
676: SET pricing_status_text = l_message,

Line 675: UPDATE qp_npreq_ldets_tmp

671: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
672: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
673: */
674: --sql statement upd8
675: UPDATE qp_npreq_ldets_tmp
676: SET pricing_status_text = l_message,
677: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
678: WHERE line_index = g_limit_balance_line(i).line_index
679: AND created_from_list_line_id =

Line 993: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

989: WHERE line_index = g_limit_balance_line(i).line_index;
990:
991: --Update the ldets_tmp table with the translated error message.
992: /*
993: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
994: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
995: */
996: --sql statement upd10
997: UPDATE qp_npreq_ldets_tmp

Line 994: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

990:
991: --Update the ldets_tmp table with the translated error message.
992: /*
993: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
994: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
995: */
996: --sql statement upd10
997: UPDATE qp_npreq_ldets_tmp
998: SET pricing_status_text = l_message,

Line 997: UPDATE qp_npreq_ldets_tmp

993: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
994: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
995: */
996: --sql statement upd10
997: UPDATE qp_npreq_ldets_tmp
998: SET pricing_status_text = l_message,
999: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1000: WHERE line_index = g_limit_balance_line(i).line_index
1001: AND created_from_list_line_id =

Line 1033: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

1029: WHERE line_index = g_limit_balance_line(i).line_index;
1030:
1031: --Update the ldets_tmp table with the translated error message.
1032: /*
1033: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1034: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1035: */
1036: --sql statement upd2
1037: UPDATE qp_npreq_ldets_tmp

Line 1034: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

1030:
1031: --Update the ldets_tmp table with the translated error message.
1032: /*
1033: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1034: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1035: */
1036: --sql statement upd2
1037: UPDATE qp_npreq_ldets_tmp
1038: SET pricing_status_text = l_message,

Line 1037: UPDATE qp_npreq_ldets_tmp

1033: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1034: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1035: */
1036: --sql statement upd2
1037: UPDATE qp_npreq_ldets_tmp
1038: SET pricing_status_text = l_message,
1039: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1040: WHERE line_index = g_limit_balance_line(i).line_index
1041: AND created_from_list_line_id =

Line 1077: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

1073: WHERE line_index = g_limit_balance_line(i).line_index;
1074:
1075: --Update the ldets_tmp table with the translated error message.
1076: /*
1077: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1078: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1079: */
1080: --sql statement upd4
1081: UPDATE qp_npreq_ldets_tmp

Line 1078: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

1074:
1075: --Update the ldets_tmp table with the translated error message.
1076: /*
1077: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1078: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1079: */
1080: --sql statement upd4
1081: UPDATE qp_npreq_ldets_tmp
1082: SET pricing_status_text = l_message,

Line 1081: UPDATE qp_npreq_ldets_tmp

1077: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1078: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1079: */
1080: --sql statement upd4
1081: UPDATE qp_npreq_ldets_tmp
1082: SET pricing_status_text = l_message,
1083: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1084: WHERE line_index = g_limit_balance_line(i).line_index
1085: AND created_from_list_line_id =

Line 1521: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

1517: WHERE line_index = g_limit_balance_line(i).line_index;
1518:
1519: --Update the ldets_tmp table with the translated error message.
1520: /*
1521: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1522: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1523: */
1524: --sql statement upd12
1525: UPDATE qp_npreq_ldets_tmp

Line 1522: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

1518:
1519: --Update the ldets_tmp table with the translated error message.
1520: /*
1521: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1522: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1523: */
1524: --sql statement upd12
1525: UPDATE qp_npreq_ldets_tmp
1526: SET pricing_status_text = l_message,

Line 1525: UPDATE qp_npreq_ldets_tmp

1521: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1522: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1523: */
1524: --sql statement upd12
1525: UPDATE qp_npreq_ldets_tmp
1526: SET pricing_status_text = l_message,
1527: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1528: WHERE line_index = g_limit_balance_line(i).line_index
1529: AND created_from_list_line_id =

Line 1561: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

1557: WHERE line_index = g_limit_balance_line(i).line_index;
1558:
1559: --Update the ldets_tmp table with the translated error message.
1560: /*
1561: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1562: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1563: */
1564: --sql statement upd6
1565: UPDATE qp_npreq_ldets_tmp

Line 1562: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

1558:
1559: --Update the ldets_tmp table with the translated error message.
1560: /*
1561: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1562: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1563: */
1564: --sql statement upd6
1565: UPDATE qp_npreq_ldets_tmp
1566: SET pricing_status_text = l_message,

Line 1565: UPDATE qp_npreq_ldets_tmp

1561: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1562: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1563: */
1564: --sql statement upd6
1565: UPDATE qp_npreq_ldets_tmp
1566: SET pricing_status_text = l_message,
1567: pricing_status_code =
1568: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1569: WHERE line_index = g_limit_balance_line(i).line_index

Line 1607: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

1603: WHERE line_index = g_limit_balance_line(i).line_index;
1604:
1605: --Update the ldets_tmp table with the translated error message.
1606: /*
1607: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1608: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1609: */
1610: --sql statement upd8
1611: UPDATE qp_npreq_ldets_tmp

Line 1608: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

1604:
1605: --Update the ldets_tmp table with the translated error message.
1606: /*
1607: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1608: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1609: */
1610: --sql statement upd8
1611: UPDATE qp_npreq_ldets_tmp
1612: SET pricing_status_text = l_message,

Line 1611: UPDATE qp_npreq_ldets_tmp

1607: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1608: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1609: */
1610: --sql statement upd8
1611: UPDATE qp_npreq_ldets_tmp
1612: SET pricing_status_text = l_message,
1613: pricing_status_code =
1614: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1615: WHERE line_index = g_limit_balance_line(i).line_index

Line 1828: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1

1824: PROCEDURE Process_Limits(x_return_status OUT NOCOPY VARCHAR2,
1825: x_return_text OUT NOCOPY VARCHAR2)
1826: IS
1827: /*
1828: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
1829: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,HEADER_LIMIT_EXISTS,2
1830: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_HEADER_ID,1
1831: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_LINE_ID,2
1832: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMIT_ATTRIBUTES_N1,LIMIT_ID,1

Line 1829: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,HEADER_LIMIT_EXISTS,2

1825: x_return_text OUT NOCOPY VARCHAR2)
1826: IS
1827: /*
1828: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
1829: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,HEADER_LIMIT_EXISTS,2
1830: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_HEADER_ID,1
1831: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_LINE_ID,2
1832: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMIT_ATTRIBUTES_N1,LIMIT_ID,1
1833: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1

Line 1877: FROM qp_npreq_ldets_tmp r, qp_limits l,

1873: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
1874: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
1875: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
1876: q.priced_quantity quantity_wanted
1877: FROM qp_npreq_ldets_tmp r, qp_limits l,
1878: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q
1879: WHERE r.created_from_list_header_id = l.list_header_id
1880: AND r.created_from_list_line_id = l.list_line_id
1881: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 1946: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q

1942: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
1943: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
1944: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
1945: q.priced_quantity quantity_wanted
1946: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q
1947: WHERE r.created_from_list_header_id = l.list_header_id
1948: AND r.created_from_list_line_id = l.list_line_id
1949: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
1950: AND r.applied_flag = 'Y' -- [5385851/5322832]

Line 1991: FROM qp_npreq_ldets_tmp r, qp_limits l,

1987: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
1988: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
1989: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
1990: q.priced_quantity quantity_wanted
1991: FROM qp_npreq_ldets_tmp r, qp_limits l,
1992: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q
1993: WHERE r.created_from_list_header_id = l.list_header_id
1994: AND l.list_line_id = -1
1995: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 2060: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q

2056: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
2057: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
2058: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
2059: q.priced_quantity quantity_wanted
2060: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q
2061: WHERE r.created_from_list_header_id = l.list_header_id
2062: AND l.list_line_id = -1
2063: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2064: AND r.applied_flag = 'Y' -- [5385851/5322832]

Line 2316: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

2312:
2313: END IF;
2314: --Do the following update for all list line types
2315: /*
2316: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2317: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2318: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2319: */
2320: --sql statement upd1

Line 2317: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2

2313: END IF;
2314: --Do the following update for all list line types
2315: /*
2316: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2317: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2318: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2319: */
2320: --sql statement upd1
2321: UPDATE qp_npreq_ldets_tmp

Line 2318: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

2314: --Do the following update for all list line types
2315: /*
2316: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2317: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2318: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2319: */
2320: --sql statement upd1
2321: UPDATE qp_npreq_ldets_tmp
2322: SET operand_value = g_limit_balance_line(j).operand_value,

Line 2321: UPDATE qp_npreq_ldets_tmp

2317: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2318: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2319: */
2320: --sql statement upd1
2321: UPDATE qp_npreq_ldets_tmp
2322: SET operand_value = g_limit_balance_line(j).operand_value,
2323: benefit_qty = g_limit_balance_line(j).benefit_qty,
2324: limit_code = l_limit_code,
2325: limit_text = l_limit_text

Line 2335: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

2331: --Update the Child Break Lines for 'PBH' lines
2332: IF g_limit_balance_line(j).created_from_list_line_type = 'PBH'
2333: THEN
2334: /*
2335: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2336: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2337: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2338: INDX,qp_limit_balance_check_pvt.process_limits.upd2,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2339: */

Line 2336: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2

2332: IF g_limit_balance_line(j).created_from_list_line_type = 'PBH'
2333: THEN
2334: /*
2335: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2336: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2337: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2338: INDX,qp_limit_balance_check_pvt.process_limits.upd2,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2339: */
2340: --sql statement upd2

Line 2337: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

2333: THEN
2334: /*
2335: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2336: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2337: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2338: INDX,qp_limit_balance_check_pvt.process_limits.upd2,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2339: */
2340: --sql statement upd2
2341: UPDATE qp_npreq_ldets_tmp a

Line 2341: UPDATE qp_npreq_ldets_tmp a

2337: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2338: INDX,qp_limit_balance_check_pvt.process_limits.upd2,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2339: */
2340: --sql statement upd2
2341: UPDATE qp_npreq_ldets_tmp a
2342: SET a.operand_value = DECODE(
2343: g_limit_balance_line(j).operand_calculation_code,
2344: '%', (g_limit_balance_line(j).least_percent/100) *
2345: g_limit_balance_line(j).operand_value,

Line 2495: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

2491: QP_PREQ_GRP.engine_debug('Header Level Limit '||
2492: l_limit_rec.limit_id ||' not available');
2493: END IF;
2494: /*
2495: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2496: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2497: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4
2498: */
2499: --sql statement upd5

Line 2496: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2

2492: l_limit_rec.limit_id ||' not available');
2493: END IF;
2494: /*
2495: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2496: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2497: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4
2498: */
2499: --sql statement upd5
2500: UPDATE qp_npreq_ldets_tmp

Line 2497: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4

2493: END IF;
2494: /*
2495: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2496: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2497: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4
2498: */
2499: --sql statement upd5
2500: UPDATE qp_npreq_ldets_tmp
2501: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED

Line 2500: UPDATE qp_npreq_ldets_tmp

2496: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2497: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4
2498: */
2499: --sql statement upd5
2500: UPDATE qp_npreq_ldets_tmp
2501: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED
2502: WHERE created_from_list_header_id =
2503: l_limit_rec.created_from_list_header_id
2504: AND line_index = l_limit_rec.line_index

Line 2515: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

2511: QP_PREQ_GRP.engine_debug('Line Level Limit '||
2512: l_limit_rec.limit_id ||' not available');
2513: END IF;
2514: /*
2515: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2516: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2517: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2518: */
2519: --sql statement upd6

Line 2516: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2

2512: l_limit_rec.limit_id ||' not available');
2513: END IF;
2514: /*
2515: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2516: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2517: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2518: */
2519: --sql statement upd6
2520: UPDATE qp_npreq_ldets_tmp

Line 2517: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

2513: END IF;
2514: /*
2515: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2516: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2517: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2518: */
2519: --sql statement upd6
2520: UPDATE qp_npreq_ldets_tmp
2521: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED

Line 2520: UPDATE qp_npreq_ldets_tmp

2516: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2517: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2518: */
2519: --sql statement upd6
2520: UPDATE qp_npreq_ldets_tmp
2521: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED
2522: WHERE created_from_list_line_id =
2523: l_limit_rec.created_from_list_line_id
2524: AND line_index = l_limit_rec.line_index

Line 2691: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

2687:
2688: END IF;
2689: --Do the following update for all list line types
2690: /*
2691: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2692: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2693: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2694: */
2695: --sql statement upd7

Line 2692: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2

2688: END IF;
2689: --Do the following update for all list line types
2690: /*
2691: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2692: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2693: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2694: */
2695: --sql statement upd7
2696: UPDATE qp_npreq_ldets_tmp

Line 2693: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

2689: --Do the following update for all list line types
2690: /*
2691: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2692: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2693: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2694: */
2695: --sql statement upd7
2696: UPDATE qp_npreq_ldets_tmp
2697: SET operand_value = g_limit_balance_line(j).operand_value,

Line 2696: UPDATE qp_npreq_ldets_tmp

2692: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2693: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2694: */
2695: --sql statement upd7
2696: UPDATE qp_npreq_ldets_tmp
2697: SET operand_value = g_limit_balance_line(j).operand_value,
2698: benefit_qty = g_limit_balance_line(j).benefit_qty,
2699: limit_code = l_limit_code,
2700: limit_text = l_limit_text

Line 2713: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

2709:
2710: --Update the Child Break Lines for 'PBH' lines
2711: IF g_limit_balance_line(j).created_from_list_line_type = 'PBH' THEN
2712: /*
2713: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2714: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2715: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2716: INDX,qp_limit_balance_check_pvt.process_limits.upd8,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2717: */

Line 2714: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2

2710: --Update the Child Break Lines for 'PBH' lines
2711: IF g_limit_balance_line(j).created_from_list_line_type = 'PBH' THEN
2712: /*
2713: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2714: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2715: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2716: INDX,qp_limit_balance_check_pvt.process_limits.upd8,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2717: */
2718: --sql statement upd8

Line 2715: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5

2711: IF g_limit_balance_line(j).created_from_list_line_type = 'PBH' THEN
2712: /*
2713: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2714: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2715: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2716: INDX,qp_limit_balance_check_pvt.process_limits.upd8,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2717: */
2718: --sql statement upd8
2719: UPDATE qp_npreq_ldets_tmp a

Line 2719: UPDATE qp_npreq_ldets_tmp a

2715: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2716: INDX,qp_limit_balance_check_pvt.process_limits.upd8,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2717: */
2718: --sql statement upd8
2719: UPDATE qp_npreq_ldets_tmp a
2720: SET a.operand_value = DECODE(
2721: g_limit_balance_line(j).operand_calculation_code,
2722: '%', (g_limit_balance_line(j).least_percent/100) *
2723: g_limit_balance_line(j).operand_value,