DBA Data[Home] [Help]

APPS.OKS_QA_DATA_INTEGRITY dependencies on QP_UTIL_PUB

Line 575: QP_UTIL_PUB.Validate_Price_list_Curr_code(

571: Close get_price_list; */
572:
573: -- Check for hdr level pricelist only for entered status contracts.
574: IF l_hdr_ste_code = 'ENTERED' THEN
575: QP_UTIL_PUB.Validate_Price_list_Curr_code(
576: l_price_list_id => l_price_list_id
577: , l_currency_code => l_currency_code
578: , l_pricing_effective_date => l_pricing_effective_date
579: , l_validate_result => l_validate_result);

Line 602: QP_UTIL_PUB.Validate_Price_list_Curr_code(

598: CLOSE get_renewal_info;
599:
600: IF NVL(l_renewal_price_list_id, - 99) <> - 99 THEN
601:
602: QP_UTIL_PUB.Validate_Price_list_Curr_code(
603: l_price_list_id => l_renewal_price_list_id
604: , l_currency_code => l_currency_code
605: , l_pricing_effective_date => l_pricing_effective_date
606: , l_validate_result => l_validate_result);

Line 631: QP_UTIL_PUB.Validate_Price_list_Curr_code(

627: IF get_status%FOUND THEN
628: l_price_list_id := cur_rec.price_list_id;
629: l_line_number := cur_rec.line_number;
630:
631: QP_UTIL_PUB.Validate_Price_list_Curr_code(
632: l_price_list_id => l_price_list_id
633: , l_currency_code => l_currency_code
634: , l_pricing_effective_date => l_pricing_effective_date
635: , l_validate_result => l_validate_result);

Line 664: QP_UTIL_PUB.Validate_Price_list_Curr_code(

660: EXIT WHEN (l_line_number_tbl.count = 0);
661:
662: FOR i IN l_line_number_tbl.FIRST..l_line_number_tbl.LAST LOOP
663:
664: QP_UTIL_PUB.Validate_Price_list_Curr_code(
665: l_price_list_id => l_price_list_id_tbl(i)
666: ,l_currency_code => l_currency_code
667: ,l_pricing_effective_date => l_pricing_effective_date
668: ,l_validate_result => l_validate_result);