DBA Data[Home] [Help]

APPS.PO_PDOI_PRICE_DIFF_PROCESS_PVT dependencies on PO_INTERFACE_ERRORS

Line 560: -- remove the errors for price diffs from po_interface_errors if those records are supposed to be processed

556:
557: d_position := 60;
558:
559: -- Bug 5215781:
560: -- remove the errors for price diffs from po_interface_errors if those records are supposed to be processed
561: -- after the price diff where we hit the error tolerance; And they do not belong to any line that has been
562: -- counted in g_errored_lines. That means, we want to rollback some changes made on po_interface_errors if
563: -- error tolerance is reached at some point
564: PO_INTERFACE_ERRORS_UTL.flush_errors_tbl;

Line 562: -- counted in g_errored_lines. That means, we want to rollback some changes made on po_interface_errors if

558:
559: -- Bug 5215781:
560: -- remove the errors for price diffs from po_interface_errors if those records are supposed to be processed
561: -- after the price diff where we hit the error tolerance; And they do not belong to any line that has been
562: -- counted in g_errored_lines. That means, we want to rollback some changes made on po_interface_errors if
563: -- error tolerance is reached at some point
564: PO_INTERFACE_ERRORS_UTL.flush_errors_tbl;
565:
566: FORALL i IN 1..l_remove_err_price_diff_tbl.COUNT

Line 564: PO_INTERFACE_ERRORS_UTL.flush_errors_tbl;

560: -- remove the errors for price diffs from po_interface_errors if those records are supposed to be processed
561: -- after the price diff where we hit the error tolerance; And they do not belong to any line that has been
562: -- counted in g_errored_lines. That means, we want to rollback some changes made on po_interface_errors if
563: -- error tolerance is reached at some point
564: PO_INTERFACE_ERRORS_UTL.flush_errors_tbl;
565:
566: FORALL i IN 1..l_remove_err_price_diff_tbl.COUNT
567: DELETE FROM PO_INTERFACE_ERRORS
568: WHERE price_diff_interface_id = l_remove_err_price_diff_tbl(i)

Line 567: DELETE FROM PO_INTERFACE_ERRORS

563: -- error tolerance is reached at some point
564: PO_INTERFACE_ERRORS_UTL.flush_errors_tbl;
565:
566: FORALL i IN 1..l_remove_err_price_diff_tbl.COUNT
567: DELETE FROM PO_INTERFACE_ERRORS
568: WHERE price_diff_interface_id = l_remove_err_price_diff_tbl(i)
569: AND interface_line_id = l_remove_err_line_tbl(i);
570:
571: d_position := 70;