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 523: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

519: WHERE line_index = g_limit_balance_line(i).line_index;
520:
521: --Update the ldets_tmp table with the translated error message.
522: /*
523: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
524: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
525: */
526: --sql statement upd2
527: UPDATE qp_npreq_ldets_tmp

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

520:
521: --Update the ldets_tmp table with the translated error message.
522: /*
523: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
524: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
525: */
526: --sql statement upd2
527: UPDATE qp_npreq_ldets_tmp
528: SET pricing_status_text = l_message,

Line 527: UPDATE qp_npreq_ldets_tmp

523: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
524: INDX,qp_limit_balance_check_pvt.recheck_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
525: */
526: --sql statement upd2
527: UPDATE qp_npreq_ldets_tmp
528: SET pricing_status_text = l_message,
529: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
530: WHERE line_index = g_limit_balance_line(i).line_index
531: AND created_from_list_line_id =

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

563: WHERE line_index = g_limit_balance_line(i).line_index;
564:
565: --Update the ldets_tmp table with the translated error message.
566: /*
567: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
568: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
569: */
570: --sql statement upd4
571: UPDATE qp_npreq_ldets_tmp

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

564:
565: --Update the ldets_tmp table with the translated error message.
566: /*
567: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
568: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
569: */
570: --sql statement upd4
571: UPDATE qp_npreq_ldets_tmp
572: SET pricing_status_text = l_message,

Line 571: UPDATE qp_npreq_ldets_tmp

567: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
568: INDX,qp_limit_balance_check_pvt.recheck_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
569: */
570: --sql statement upd4
571: UPDATE qp_npreq_ldets_tmp
572: SET pricing_status_text = l_message,
573: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
574: WHERE line_index = g_limit_balance_line(i).line_index
575: AND created_from_list_line_id =

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

646: WHERE line_index = g_limit_balance_line(i).line_index;
647:
648: --Update the ldets_tmp table with the translated error message.
649: /*
650: INDX,qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
651: INDX qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
652: */
653: --sql statement upd6
654: UPDATE qp_npreq_ldets_tmp

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

647:
648: --Update the ldets_tmp table with the translated error message.
649: /*
650: INDX,qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
651: INDX qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
652: */
653: --sql statement upd6
654: UPDATE qp_npreq_ldets_tmp
655: SET pricing_status_text = l_message,

Line 654: UPDATE qp_npreq_ldets_tmp

650: INDX,qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
651: INDX qp_limit_balance_check_pvt.recheck_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
652: */
653: --sql statement upd6
654: UPDATE qp_npreq_ldets_tmp
655: SET pricing_status_text = l_message,
656: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
657: WHERE line_index = g_limit_balance_line(i).line_index
658: AND created_from_list_line_id =

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

690: WHERE line_index = g_limit_balance_line(i).line_index;
691:
692: --Update the ldets_tmp table with the translated error message.
693: /*
694: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
695: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
696: */
697: --sql statement upd8
698: UPDATE qp_npreq_ldets_tmp

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

691:
692: --Update the ldets_tmp table with the translated error message.
693: /*
694: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
695: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
696: */
697: --sql statement upd8
698: UPDATE qp_npreq_ldets_tmp
699: SET pricing_status_text = l_message,

Line 698: UPDATE qp_npreq_ldets_tmp

694: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
695: INDX,qp_limit_balance_check_pvt.recheck_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
696: */
697: --sql statement upd8
698: UPDATE qp_npreq_ldets_tmp
699: SET pricing_status_text = l_message,
700: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
701: WHERE line_index = g_limit_balance_line(i).line_index
702: AND created_from_list_line_id =

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

1013: WHERE line_index = g_limit_balance_line(i).line_index;
1014:
1015: --Update the ldets_tmp table with the translated error message.
1016: /*
1017: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1018: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1019: */
1020: --sql statement upd10
1021: UPDATE qp_npreq_ldets_tmp

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

1014:
1015: --Update the ldets_tmp table with the translated error message.
1016: /*
1017: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1018: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1019: */
1020: --sql statement upd10
1021: UPDATE qp_npreq_ldets_tmp
1022: SET pricing_status_text = l_message,

Line 1021: UPDATE qp_npreq_ldets_tmp

1017: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1018: INDX,qp_limit_balance_check_pvt.check_balance.upd10,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1019: */
1020: --sql statement upd10
1021: UPDATE qp_npreq_ldets_tmp
1022: SET pricing_status_text = l_message,
1023: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1024: WHERE line_index = g_limit_balance_line(i).line_index
1025: AND created_from_list_line_id =

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

1053: WHERE line_index = g_limit_balance_line(i).line_index;
1054:
1055: --Update the ldets_tmp table with the translated error message.
1056: /*
1057: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1058: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1059: */
1060: --sql statement upd2
1061: UPDATE qp_npreq_ldets_tmp

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

1054:
1055: --Update the ldets_tmp table with the translated error message.
1056: /*
1057: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1058: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1059: */
1060: --sql statement upd2
1061: UPDATE qp_npreq_ldets_tmp
1062: SET pricing_status_text = l_message,

Line 1061: UPDATE qp_npreq_ldets_tmp

1057: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1058: INDX,qp_limit_balance_check_pvt.check_balance.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1059: */
1060: --sql statement upd2
1061: UPDATE qp_npreq_ldets_tmp
1062: SET pricing_status_text = l_message,
1063: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1064: WHERE line_index = g_limit_balance_line(i).line_index
1065: AND created_from_list_line_id =

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

1097: WHERE line_index = g_limit_balance_line(i).line_index;
1098:
1099: --Update the ldets_tmp table with the translated error message.
1100: /*
1101: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1102: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1103: */
1104: --sql statement upd4
1105: UPDATE qp_npreq_ldets_tmp

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

1098:
1099: --Update the ldets_tmp table with the translated error message.
1100: /*
1101: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1102: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1103: */
1104: --sql statement upd4
1105: UPDATE qp_npreq_ldets_tmp
1106: SET pricing_status_text = l_message,

Line 1105: UPDATE qp_npreq_ldets_tmp

1101: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1102: INDX,qp_limit_balance_check_pvt.check_balance.upd4,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1103: */
1104: --sql statement upd4
1105: UPDATE qp_npreq_ldets_tmp
1106: SET pricing_status_text = l_message,
1107: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1108: WHERE line_index = g_limit_balance_line(i).line_index
1109: AND created_from_list_line_id =

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

1543: WHERE line_index = g_limit_balance_line(i).line_index;
1544:
1545: --Update the ldets_tmp table with the translated error message.
1546: /*
1547: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1548: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1549: */
1550: --sql statement upd12
1551: UPDATE qp_npreq_ldets_tmp

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

1544:
1545: --Update the ldets_tmp table with the translated error message.
1546: /*
1547: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1548: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1549: */
1550: --sql statement upd12
1551: UPDATE qp_npreq_ldets_tmp
1552: SET pricing_status_text = l_message,

Line 1551: UPDATE qp_npreq_ldets_tmp

1547: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1548: INDX,qp_limit_balance_check_pvt.check_balance.upd12,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1549: */
1550: --sql statement upd12
1551: UPDATE qp_npreq_ldets_tmp
1552: SET pricing_status_text = l_message,
1553: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1554: WHERE line_index = g_limit_balance_line(i).line_index
1555: AND created_from_list_line_id =

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

1583: WHERE line_index = g_limit_balance_line(i).line_index;
1584:
1585: --Update the ldets_tmp table with the translated error message.
1586: /*
1587: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1588: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1589: */
1590: --sql statement upd6
1591: UPDATE qp_npreq_ldets_tmp

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

1584:
1585: --Update the ldets_tmp table with the translated error message.
1586: /*
1587: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1588: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1589: */
1590: --sql statement upd6
1591: UPDATE qp_npreq_ldets_tmp
1592: SET pricing_status_text = l_message,

Line 1591: UPDATE qp_npreq_ldets_tmp

1587: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1588: INDX,qp_limit_balance_check_pvt.check_balance.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1589: */
1590: --sql statement upd6
1591: UPDATE qp_npreq_ldets_tmp
1592: SET pricing_status_text = l_message,
1593: pricing_status_code =
1594: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1595: WHERE line_index = g_limit_balance_line(i).line_index

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

1629: WHERE line_index = g_limit_balance_line(i).line_index;
1630:
1631: --Update the ldets_tmp table with the translated error message.
1632: /*
1633: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1634: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1635: */
1636: --sql statement upd8
1637: UPDATE qp_npreq_ldets_tmp

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

1630:
1631: --Update the ldets_tmp table with the translated error message.
1632: /*
1633: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1634: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1635: */
1636: --sql statement upd8
1637: UPDATE qp_npreq_ldets_tmp
1638: SET pricing_status_text = l_message,

Line 1637: UPDATE qp_npreq_ldets_tmp

1633: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
1634: INDX,qp_limit_balance_check_pvt.check_balance.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
1635: */
1636: --sql statement upd8
1637: UPDATE qp_npreq_ldets_tmp
1638: SET pricing_status_text = l_message,
1639: pricing_status_code =
1640: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1641: WHERE line_index = g_limit_balance_line(i).line_index

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

1885: PROCEDURE Process_Limits(x_return_status OUT NOCOPY VARCHAR2,
1886: x_return_text OUT NOCOPY VARCHAR2)
1887: IS
1888: /*
1889: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
1890: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,HEADER_LIMIT_EXISTS,2
1891: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_HEADER_ID,1
1892: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_LINE_ID,2
1893: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMIT_ATTRIBUTES_N1,LIMIT_ID,1

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

1886: x_return_text OUT NOCOPY VARCHAR2)
1887: IS
1888: /*
1889: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
1890: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_ldets_tmp_N4,HEADER_LIMIT_EXISTS,2
1891: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_HEADER_ID,1
1892: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMITS_N1,LIST_LINE_ID,2
1893: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,QP_LIMIT_ATTRIBUTES_N1,LIMIT_ID,1
1894: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1

Line 1938: FROM qp_npreq_ldets_tmp r, qp_limits l,

1934: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
1935: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
1936: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
1937: q.priced_quantity quantity_wanted
1938: FROM qp_npreq_ldets_tmp r, qp_limits l,
1939: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q
1940: WHERE r.created_from_list_header_id = l.list_header_id
1941: AND r.created_from_list_line_id = l.list_line_id
1942: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

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

2003: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
2004: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
2005: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
2006: q.priced_quantity quantity_wanted
2007: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q
2008: WHERE r.created_from_list_header_id = l.list_header_id
2009: AND r.created_from_list_line_id = l.list_line_id
2010: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2011: AND r.applied_flag = 'Y' -- [5385851/5322832]

Line 2052: FROM qp_npreq_ldets_tmp r, qp_limits l,

2048: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
2049: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
2050: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
2051: q.priced_quantity quantity_wanted
2052: FROM qp_npreq_ldets_tmp r, qp_limits l,
2053: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q
2054: WHERE r.created_from_list_header_id = l.list_header_id
2055: AND l.list_line_id = -1
2056: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

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

2117: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
2118: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
2119: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
2120: q.priced_quantity quantity_wanted
2121: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q
2122: WHERE r.created_from_list_header_id = l.list_header_id
2123: AND l.list_line_id = -1
2124: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2125: AND r.applied_flag = 'Y' -- [5385851/5322832]

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

2373:
2374: END IF;
2375: --Do the following update for all list line types
2376: /*
2377: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2378: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2379: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2380: */
2381: --sql statement upd1

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

2374: END IF;
2375: --Do the following update for all list line types
2376: /*
2377: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2378: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2379: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2380: */
2381: --sql statement upd1
2382: UPDATE qp_npreq_ldets_tmp

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

2375: --Do the following update for all list line types
2376: /*
2377: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2378: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2379: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2380: */
2381: --sql statement upd1
2382: UPDATE qp_npreq_ldets_tmp
2383: SET operand_value = g_limit_balance_line(j).operand_value,

Line 2382: UPDATE qp_npreq_ldets_tmp

2378: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2379: INDX,qp_limit_balance_check_pvt.process_limits.upd1,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2380: */
2381: --sql statement upd1
2382: UPDATE qp_npreq_ldets_tmp
2383: SET operand_value = g_limit_balance_line(j).operand_value,
2384: benefit_qty = g_limit_balance_line(j).benefit_qty,
2385: limit_code = l_limit_code,
2386: limit_text = l_limit_text

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

2392: --Update the Child Break Lines for 'PBH' lines
2393: IF g_limit_balance_line(j).created_from_list_line_type = 'PBH'
2394: THEN
2395: /*
2396: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2397: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2398: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2399: INDX,qp_limit_balance_check_pvt.process_limits.upd2,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2400: */

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

2393: IF g_limit_balance_line(j).created_from_list_line_type = 'PBH'
2394: THEN
2395: /*
2396: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2397: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2398: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2399: INDX,qp_limit_balance_check_pvt.process_limits.upd2,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2400: */
2401: --sql statement upd2

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

2394: THEN
2395: /*
2396: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2397: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2398: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2399: INDX,qp_limit_balance_check_pvt.process_limits.upd2,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2400: */
2401: --sql statement upd2
2402: UPDATE qp_npreq_ldets_tmp a

Line 2402: UPDATE qp_npreq_ldets_tmp a

2398: INDX,qp_limit_balance_check_pvt.process_limits.upd2,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2399: INDX,qp_limit_balance_check_pvt.process_limits.upd2,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2400: */
2401: --sql statement upd2
2402: UPDATE qp_npreq_ldets_tmp a
2403: SET a.operand_value = DECODE(
2404: g_limit_balance_line(j).operand_calculation_code,
2405: '%', (g_limit_balance_line(j).least_percent/100) *
2406: g_limit_balance_line(j).operand_value,

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

2552: QP_PREQ_GRP.engine_debug('Header Level Limit '||
2553: l_limit_rec.limit_id ||' not available');
2554: END IF;
2555: /*
2556: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2557: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2558: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4
2559: */
2560: --sql statement upd5

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

2553: l_limit_rec.limit_id ||' not available');
2554: END IF;
2555: /*
2556: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2557: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2558: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4
2559: */
2560: --sql statement upd5
2561: UPDATE qp_npreq_ldets_tmp

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

2554: END IF;
2555: /*
2556: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2557: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2558: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4
2559: */
2560: --sql statement upd5
2561: UPDATE qp_npreq_ldets_tmp
2562: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED

Line 2561: UPDATE qp_npreq_ldets_tmp

2557: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2558: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4
2559: */
2560: --sql statement upd5
2561: UPDATE qp_npreq_ldets_tmp
2562: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED
2563: WHERE created_from_list_header_id =
2564: l_limit_rec.created_from_list_header_id
2565: AND line_index = l_limit_rec.line_index

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

2572: QP_PREQ_GRP.engine_debug('Line Level Limit '||
2573: l_limit_rec.limit_id ||' not available');
2574: END IF;
2575: /*
2576: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2577: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2578: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2579: */
2580: --sql statement upd6

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

2573: l_limit_rec.limit_id ||' not available');
2574: END IF;
2575: /*
2576: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2577: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2578: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2579: */
2580: --sql statement upd6
2581: UPDATE qp_npreq_ldets_tmp

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

2574: END IF;
2575: /*
2576: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2577: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2578: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2579: */
2580: --sql statement upd6
2581: UPDATE qp_npreq_ldets_tmp
2582: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED

Line 2581: UPDATE qp_npreq_ldets_tmp

2577: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2578: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2579: */
2580: --sql statement upd6
2581: UPDATE qp_npreq_ldets_tmp
2582: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED
2583: WHERE created_from_list_line_id =
2584: l_limit_rec.created_from_list_line_id
2585: AND line_index = l_limit_rec.line_index

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

2748:
2749: END IF;
2750: --Do the following update for all list line types
2751: /*
2752: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2753: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2754: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2755: */
2756: --sql statement upd7

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

2749: END IF;
2750: --Do the following update for all list line types
2751: /*
2752: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2753: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2754: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2755: */
2756: --sql statement upd7
2757: UPDATE qp_npreq_ldets_tmp

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

2750: --Do the following update for all list line types
2751: /*
2752: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2753: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2754: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2755: */
2756: --sql statement upd7
2757: UPDATE qp_npreq_ldets_tmp
2758: SET operand_value = g_limit_balance_line(j).operand_value,

Line 2757: UPDATE qp_npreq_ldets_tmp

2753: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2754: INDX,qp_limit_balance_check_pvt.process_limits.upd7,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2755: */
2756: --sql statement upd7
2757: UPDATE qp_npreq_ldets_tmp
2758: SET operand_value = g_limit_balance_line(j).operand_value,
2759: benefit_qty = g_limit_balance_line(j).benefit_qty,
2760: limit_code = l_limit_code,
2761: limit_text = l_limit_text

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

2770:
2771: --Update the Child Break Lines for 'PBH' lines
2772: IF g_limit_balance_line(j).created_from_list_line_type = 'PBH' THEN
2773: /*
2774: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2775: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2776: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2777: INDX,qp_limit_balance_check_pvt.process_limits.upd8,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2778: */

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

2771: --Update the Child Break Lines for 'PBH' lines
2772: IF g_limit_balance_line(j).created_from_list_line_type = 'PBH' THEN
2773: /*
2774: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2775: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2776: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2777: INDX,qp_limit_balance_check_pvt.process_limits.upd8,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2778: */
2779: --sql statement upd8

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

2772: IF g_limit_balance_line(j).created_from_list_line_type = 'PBH' THEN
2773: /*
2774: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,LINE_INDEX,1
2775: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
2776: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2777: INDX,qp_limit_balance_check_pvt.process_limits.upd8,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2778: */
2779: --sql statement upd8
2780: UPDATE qp_npreq_ldets_tmp a

Line 2780: UPDATE qp_npreq_ldets_tmp a

2776: INDX,qp_limit_balance_check_pvt.process_limits.upd8,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2777: INDX,qp_limit_balance_check_pvt.process_limits.upd8,QP_RLTD_LINES_TMP_INDEX,LINE_INDEX,1
2778: */
2779: --sql statement upd8
2780: UPDATE qp_npreq_ldets_tmp a
2781: SET a.operand_value = DECODE(
2782: g_limit_balance_line(j).operand_calculation_code,
2783: '%', (g_limit_balance_line(j).least_percent/100) *
2784: g_limit_balance_line(j).operand_value,