APPS.PON_LARGE_AUCTION_UTIL_PKG dependencies on PON_INTERFACE_ERRORS

Line 297: -- were inserted in pon_interface_errors

293: --
294: -- RETURN: VARCHAR2 Y/N if the request had/didn't have validation errors
295:
296: -- COMMENT: Determines if any validation errors associated with p_request_id
297: -- were inserted in pon_interface_errors
298: -- ======================================================================
299: FUNCTION request_has_errors
300: (
301: p_request_id IN pon_interface_errors.request_id%TYPE

Line 301: p_request_id IN pon_interface_errors.request_id%TYPE

297: -- were inserted in pon_interface_errors
298: -- ======================================================================
299: FUNCTION request_has_errors
300: (
301: p_request_id IN pon_interface_errors.request_id%TYPE
302: ) RETURN VARCHAR2 IS
303: l_has_errors VARCHAR2(1);
304: BEGIN
305:

Line 308: FROM pon_interface_errors

304: BEGIN
305:
306: SELECT 'Y'
307: INTO l_has_errors
308: FROM pon_interface_errors
309: WHERE request_id = p_request_id
310: AND rownum = 1;
311:
312: RETURN l_has_errors;

Line 331: p_request_id IN pon_interface_errors.request_id%TYPE

327: -- COMMENT: Counts the number of validation errors for a request
328: -- ======================================================================
329: FUNCTION request_error_count
330: (
331: p_request_id IN pon_interface_errors.request_id%TYPE
332: ) RETURN NUMBER IS
333: l_error_count NUMBER;
334: BEGIN
335:

Line 338: FROM pon_interface_errors

334: BEGIN
335:
336: SELECT count(request_id)
337: INTO l_error_count
338: FROM pon_interface_errors
339: WHERE request_id = p_request_id;
340:
341: RETURN l_error_count;
342:

Line 750: delete from pon_interface_errors

746: Delete all the errors in the interface table that have
747: expiration date marked as less than the current date
748:
749: */
750: delete from pon_interface_errors
751: where trunc(expiration_date) <= trunc(sysdate);
752:
753: /*
754: