APPS.QP_PREQ_GRP dependencies on QP_LIMIT_TRANSACTIONS

Line 41098: INDX,QP_PREQ_GRP.price_request.limit_trans_cur,QP_LIMIT_TRANSACTIONS_U1,PRICE_REQUEST_CODE,1

41094: FROM qp_npreq_lines_tmp
41095: WHERE charge_periodicity_code is NULL; -- added for recurring charges Bug # 4465168
41096:
41097: /*
41098: INDX,QP_PREQ_GRP.price_request.limit_trans_cur,QP_LIMIT_TRANSACTIONS_U1,PRICE_REQUEST_CODE,1
41099: */
41100: CURSOR limit_trans_cur IS
41101: SELECT 'X'
41102: FROM qp_limit_transactions

Line 41102: FROM qp_limit_transactions

41098: INDX,QP_PREQ_GRP.price_request.limit_trans_cur,QP_LIMIT_TRANSACTIONS_U1,PRICE_REQUEST_CODE,1
41099: */
41100: CURSOR limit_trans_cur IS
41101: SELECT 'X'
41102: FROM qp_limit_transactions
41103: WHERE price_request_code > fnd_global.local_chr(0);
41104: --WHERE price_request_code > chr(0); fix GSCC compilation warning
41105:
41106: l_product_app_id number; -- bug 3841192

Line 42784: --qp_limit_transactions table(that is, if limits functionality being used)

42780: engine_debug('------Advanced Pricing and Limits Profile is Set 2 -----------');
42781:
42782: END IF;
42783: --Call the Delete Transactions API only if there is atleast one record in
42784: --qp_limit_transactions table(that is, if limits functionality being used)
42785: OPEN limit_trans_cur;
42786: FETCH limit_trans_cur INTO l_trans;
42787:
42788: IF limit_trans_cur%FOUND THEN

Line 42789: QP_Limit_Transactions_PVT.Delete(p_control_rec.pricing_event, l_return_status);

42785: OPEN limit_trans_cur;
42786: FETCH limit_trans_cur INTO l_trans;
42787:
42788: IF limit_trans_cur%FOUND THEN
42789: QP_Limit_Transactions_PVT.Delete(p_control_rec.pricing_event, l_return_status);
42790: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
42791: RAISE E_ROUTINE_ERRORS;
42792: END IF;
42793: END IF;

Line 42850: --qp_limit_transactions table(that is, if limits functionality being used)

42846: --the transactions for the modifiers the search engine did not apply
42847: --need to call the delete API again after process_limits which will also
42848: --update the balance
42849: --Call the Delete Transactions API only if there is atleast one record in
42850: --qp_limit_transactions table(that is, if limits functionality being used)
42851: OPEN limit_trans_cur;
42852: FETCH limit_trans_cur INTO l_trans;
42853:
42854: IF limit_trans_cur%FOUND THEN

Line 42855: QP_Limit_Transactions_PVT.Delete(p_control_rec.pricing_event, l_return_status);

42851: OPEN limit_trans_cur;
42852: FETCH limit_trans_cur INTO l_trans;
42853:
42854: IF limit_trans_cur%FOUND THEN
42855: QP_Limit_Transactions_PVT.Delete(p_control_rec.pricing_event, l_return_status);
42856: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
42857: RAISE E_ROUTINE_ERRORS;
42858: END IF;--l_return_status
42859: END IF;--limit_trans_cur%FOUND