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_LINES_TMP

Line 490: INDX,qp_limit_balance_check_pvt.recheck_balance.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1

486: l_message := FND_MESSAGE.GET;
487:
488: --Update the lines_tmp table with the translated error message.
489: /*
490: INDX,qp_limit_balance_check_pvt.recheck_balance.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1
491: */
492: --sql statement upd1
493: UPDATE qp_npreq_lines_tmp
494: SET pricing_status_text = l_message,

Line 493: UPDATE qp_npreq_lines_tmp

489: /*
490: INDX,qp_limit_balance_check_pvt.recheck_balance.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1
491: */
492: --sql statement upd1
493: UPDATE qp_npreq_lines_tmp
494: SET pricing_status_text = l_message,
495: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
496: WHERE line_index = g_limit_balance_line(i).line_index;
497:

Line 534: INDX,qp_limit_balance_check_pvt.recheck_balance.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1

530: l_message := FND_MESSAGE.GET;
531:
532: --Update the lines_tmp table with the translated error message.
533: /*
534: INDX,qp_limit_balance_check_pvt.recheck_balance.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1
535: */
536: --sql statement upd3
537: UPDATE qp_npreq_lines_tmp
538: SET pricing_status_text = l_message,

Line 537: UPDATE qp_npreq_lines_tmp

533: /*
534: INDX,qp_limit_balance_check_pvt.recheck_balance.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1
535: */
536: --sql statement upd3
537: UPDATE qp_npreq_lines_tmp
538: SET pricing_status_text = l_message,
539: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
540: WHERE line_index = g_limit_balance_line(i).line_index;
541:

Line 617: INDX,qp_limit_balance_check_pvt.recheck_balance.upd5,qp_npreq_lines_tmp_N1,LINE_INDEX,1

613: l_message := FND_MESSAGE.GET;
614:
615: --Update the lines_tmp table with the translated error message.
616: /*
617: INDX,qp_limit_balance_check_pvt.recheck_balance.upd5,qp_npreq_lines_tmp_N1,LINE_INDEX,1
618: */
619: --sql statement upd5
620: UPDATE qp_npreq_lines_tmp
621: SET pricing_status_text = l_message,

Line 620: UPDATE qp_npreq_lines_tmp

616: /*
617: INDX,qp_limit_balance_check_pvt.recheck_balance.upd5,qp_npreq_lines_tmp_N1,LINE_INDEX,1
618: */
619: --sql statement upd5
620: UPDATE qp_npreq_lines_tmp
621: SET pricing_status_text = l_message,
622: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
623: WHERE line_index = g_limit_balance_line(i).line_index;
624:

Line 661: INDX,qp_limit_balance_check_pvt.recheck_balance.upd7,qp_npreq_lines_tmp_N1,LINE_INDEX,1

657: l_message := FND_MESSAGE.GET;
658:
659: --Update the lines_tmp table with the translated error message.
660: /*
661: INDX,qp_limit_balance_check_pvt.recheck_balance.upd7,qp_npreq_lines_tmp_N1,LINE_INDEX,1
662: */
663: --sql statement upd7
664: UPDATE qp_npreq_lines_tmp
665: SET pricing_status_text = l_message,

Line 664: UPDATE qp_npreq_lines_tmp

660: /*
661: INDX,qp_limit_balance_check_pvt.recheck_balance.upd7,qp_npreq_lines_tmp_N1,LINE_INDEX,1
662: */
663: --sql statement upd7
664: UPDATE qp_npreq_lines_tmp
665: SET pricing_status_text = l_message,
666: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
667: WHERE line_index = g_limit_balance_line(i).line_index;
668:

Line 983: INDX,qp_limit_balance_check_pvt.check_balance.upd9,qp_npreq_lines_tmp_N1,LINE_INDEX,1

979: l_message := FND_MESSAGE.GET;
980:
981: --Update the lines_tmp table with the translated error message.
982: /*
983: INDX,qp_limit_balance_check_pvt.check_balance.upd9,qp_npreq_lines_tmp_N1,LINE_INDEX,1
984: */
985: --sql statement upd9
986: UPDATE qp_npreq_lines_tmp
987: SET pricing_status_text = l_message,

Line 986: UPDATE qp_npreq_lines_tmp

982: /*
983: INDX,qp_limit_balance_check_pvt.check_balance.upd9,qp_npreq_lines_tmp_N1,LINE_INDEX,1
984: */
985: --sql statement upd9
986: UPDATE qp_npreq_lines_tmp
987: SET pricing_status_text = l_message,
988: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
989: WHERE line_index = g_limit_balance_line(i).line_index;
990:

Line 1023: INDX,qp_limit_balance_check_pvt.check_balance.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1

1019: l_message := FND_MESSAGE.GET;
1020:
1021: --Update the lines_tmp table with the translated error message.
1022: /*
1023: INDX,qp_limit_balance_check_pvt.check_balance.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1024: */
1025: --sql statement upd1
1026: UPDATE qp_npreq_lines_tmp
1027: SET pricing_status_text = l_message,

Line 1026: UPDATE qp_npreq_lines_tmp

1022: /*
1023: INDX,qp_limit_balance_check_pvt.check_balance.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1024: */
1025: --sql statement upd1
1026: UPDATE qp_npreq_lines_tmp
1027: SET pricing_status_text = l_message,
1028: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1029: WHERE line_index = g_limit_balance_line(i).line_index;
1030:

Line 1067: INDX,qp_limit_balance_check_pvt.check_balance.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1

1063: l_message := FND_MESSAGE.GET;
1064: l_message := substr(ltrim(rtrim(l_message))||l_message, 1, 2000);
1065: --Update the lines_tmp table with the translated error message.
1066: /*
1067: INDX,qp_limit_balance_check_pvt.check_balance.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1068: */
1069: --sql statement upd3
1070: UPDATE qp_npreq_lines_tmp
1071: SET pricing_status_text = l_message,

Line 1070: UPDATE qp_npreq_lines_tmp

1066: /*
1067: INDX,qp_limit_balance_check_pvt.check_balance.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1068: */
1069: --sql statement upd3
1070: UPDATE qp_npreq_lines_tmp
1071: SET pricing_status_text = l_message,
1072: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1073: WHERE line_index = g_limit_balance_line(i).line_index;
1074:

Line 1511: INDX,qp_limit_balance_check_pvt.check_balance.upd11,qp_npreq_lines_tmp_N1,LINE_INDEX,1

1507: l_message := FND_MESSAGE.GET;
1508:
1509: --Update the lines_tmp table with the translated error message.
1510: /*
1511: INDX,qp_limit_balance_check_pvt.check_balance.upd11,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1512: */
1513: --sql statement upd11
1514: UPDATE qp_npreq_lines_tmp
1515: SET pricing_status_text = l_message,

Line 1514: UPDATE qp_npreq_lines_tmp

1510: /*
1511: INDX,qp_limit_balance_check_pvt.check_balance.upd11,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1512: */
1513: --sql statement upd11
1514: UPDATE qp_npreq_lines_tmp
1515: SET pricing_status_text = l_message,
1516: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1517: WHERE line_index = g_limit_balance_line(i).line_index;
1518:

Line 1551: INDX,qp_limit_balance_check_pvt.check_balance.upd5,qp_npreq_lines_tmp_N1,LINE_INDEX,1

1547: l_message := FND_MESSAGE.GET;
1548:
1549: --Update the lines_tmp table with the translated error message.
1550: /*
1551: INDX,qp_limit_balance_check_pvt.check_balance.upd5,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1552: */
1553: --sql statement upd5
1554: UPDATE qp_npreq_lines_tmp
1555: SET pricing_status_text = l_message,

Line 1554: UPDATE qp_npreq_lines_tmp

1550: /*
1551: INDX,qp_limit_balance_check_pvt.check_balance.upd5,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1552: */
1553: --sql statement upd5
1554: UPDATE qp_npreq_lines_tmp
1555: SET pricing_status_text = l_message,
1556: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1557: WHERE line_index = g_limit_balance_line(i).line_index;
1558:

Line 1597: INDX,qp_limit_balance_check_pvt.check_balance.upd7,qp_npreq_lines_tmp_N1,LINE_INDEX,1

1593: l_message := substr(ltrim(rtrim(l_message))||l_message, 1, 2000);
1594:
1595: --Update the lines_tmp table with the translated error message.
1596: /*
1597: INDX,qp_limit_balance_check_pvt.check_balance.upd7,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1598: */
1599: --sql statement upd7
1600: UPDATE qp_npreq_lines_tmp
1601: SET pricing_status_text = l_message,

Line 1600: UPDATE qp_npreq_lines_tmp

1596: /*
1597: INDX,qp_limit_balance_check_pvt.check_balance.upd7,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1598: */
1599: --sql statement upd7
1600: UPDATE qp_npreq_lines_tmp
1601: SET pricing_status_text = l_message,
1602: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1603: WHERE line_index = g_limit_balance_line(i).line_index;
1604:

Line 1839: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1

1835: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
1836: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
1837: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,5
1838: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,6
1839: INDX,qp_limit_balance_check_pvt.process_limits.limits_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1840: */
1841: CURSOR limits_cur
1842: IS
1843: --Statement to select line-level limits for pure Non-each and mixed cases

Line 1878: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q

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
1882: AND r.applied_flag = 'Y' -- [5385851/5322832]

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 1992: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q

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
1996: AND r.applied_flag = 'Y' -- [5385851/5322832]

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 2393: INDX,qp_limit_balance_check_pvt.process_limits.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1

2389:
2390: END IF;
2391: --Update Hold_Code
2392: /*
2393: INDX,qp_limit_balance_check_pvt.process_limits.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1
2394: */
2395: --sql statement upd3
2396: UPDATE qp_npreq_lines_tmp
2397: SET hold_code = DECODE(hold_code, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, l_hold_code)

Line 2396: UPDATE qp_npreq_lines_tmp

2392: /*
2393: INDX,qp_limit_balance_check_pvt.process_limits.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1
2394: */
2395: --sql statement upd3
2396: UPDATE qp_npreq_lines_tmp
2397: SET hold_code = DECODE(hold_code, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, l_hold_code)
2398: WHERE line_index = g_limit_balance_line(j).line_index;
2399:
2400: IF l_debug = FND_API.G_TRUE THEN

Line 2774: INDX,qp_limit_balance_check_pvt.process_limits.upd9,qp_npreq_lines_tmp_N1,LINE_INDEX,1

2770: g_limit_balance_line(j).operand_value);
2771:
2772: END IF;
2773: /*
2774: INDX,qp_limit_balance_check_pvt.process_limits.upd9,qp_npreq_lines_tmp_N1,LINE_INDEX,1
2775: */
2776: --sql statement upd9
2777:
2778: UPDATE qp_npreq_lines_tmp

Line 2778: UPDATE qp_npreq_lines_tmp

2774: INDX,qp_limit_balance_check_pvt.process_limits.upd9,qp_npreq_lines_tmp_N1,LINE_INDEX,1
2775: */
2776: --sql statement upd9
2777:
2778: UPDATE qp_npreq_lines_tmp
2779: SET hold_code = DECODE(hold_code, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, l_hold_code)
2780: WHERE line_index = g_limit_balance_line(j).line_index;
2781:
2782: IF g_limit_balance_line(j).transaction_amount is null THEN