DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_LOC_PROCESS_PVT dependencies on PO_INTERFACE_ERRORS

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

3195:
3196: d_position := 60;
3197:
3198: -- Bug 5215781:
3199: -- remove the errors for price breaks from po_interface_errors if those records are supposed to be processed
3200: -- after the price break where we hit the error tolerance; And they do not belong to any line that has
3201: -- already been counted in g_errored_lines. That means, we want to rollback some changes on po_interface_errors
3202: -- if error tolerance is reached at some point
3203: PO_INTERFACE_ERRORS_UTL.flush_errors_tbl;

Line 3201: -- already been counted in g_errored_lines. That means, we want to rollback some changes on po_interface_errors

3197:
3198: -- Bug 5215781:
3199: -- remove the errors for price breaks from po_interface_errors if those records are supposed to be processed
3200: -- after the price break where we hit the error tolerance; And they do not belong to any line that has
3201: -- already been counted in g_errored_lines. That means, we want to rollback some changes on po_interface_errors
3202: -- if error tolerance is reached at some point
3203: PO_INTERFACE_ERRORS_UTL.flush_errors_tbl;
3204:
3205: FORALL i IN 1..l_remove_err_line_loc_tbl.COUNT

Line 3203: PO_INTERFACE_ERRORS_UTL.flush_errors_tbl;

3199: -- remove the errors for price breaks from po_interface_errors if those records are supposed to be processed
3200: -- after the price break where we hit the error tolerance; And they do not belong to any line that has
3201: -- already been counted in g_errored_lines. That means, we want to rollback some changes on po_interface_errors
3202: -- if error tolerance is reached at some point
3203: PO_INTERFACE_ERRORS_UTL.flush_errors_tbl;
3204:
3205: FORALL i IN 1..l_remove_err_line_loc_tbl.COUNT
3206: DELETE FROM PO_INTERFACE_ERRORS
3207: WHERE interface_line_location_id = l_remove_err_line_loc_tbl(i)

Line 3206: DELETE FROM PO_INTERFACE_ERRORS

3202: -- if error tolerance is reached at some point
3203: PO_INTERFACE_ERRORS_UTL.flush_errors_tbl;
3204:
3205: FORALL i IN 1..l_remove_err_line_loc_tbl.COUNT
3206: DELETE FROM PO_INTERFACE_ERRORS
3207: WHERE interface_line_location_id = l_remove_err_line_loc_tbl(i)
3208: AND interface_line_id = l_remove_err_line_tbl(i);
3209:
3210: d_position := 70;