APPS.PON_LARGE_AUCTION_UTIL_PKG dependencies on PON_INTERFACE_ERRORS

Line 283: -- were inserted in pon_interface_errors

279: --
280: -- RETURN: VARCHAR2 Y/N if the request had/didn't have validation errors
281:
282: -- COMMENT: Determines if any validation errors associated with p_request_id
283: -- were inserted in pon_interface_errors
284: -- ======================================================================
285: FUNCTION request_has_errors
286: (
287: p_request_id IN pon_interface_errors.request_id%TYPE

Line 287: p_request_id IN pon_interface_errors.request_id%TYPE

283: -- were inserted in pon_interface_errors
284: -- ======================================================================
285: FUNCTION request_has_errors
286: (
287: p_request_id IN pon_interface_errors.request_id%TYPE
288: ) RETURN VARCHAR2 IS
289: l_has_errors VARCHAR2(1);
290: BEGIN
291:

Line 294: FROM pon_interface_errors

290: BEGIN
291:
292: SELECT 'Y'
293: INTO l_has_errors
294: FROM pon_interface_errors
295: WHERE request_id = p_request_id
296: AND rownum = 1;
297:
298: RETURN l_has_errors;

Line 317: p_request_id IN pon_interface_errors.request_id%TYPE

313: -- COMMENT: Counts the number of validation errors for a request
314: -- ======================================================================
315: FUNCTION request_error_count
316: (
317: p_request_id IN pon_interface_errors.request_id%TYPE
318: ) RETURN NUMBER IS
319: l_error_count NUMBER;
320: BEGIN
321:

Line 324: FROM pon_interface_errors

320: BEGIN
321:
322: SELECT count(request_id)
323: INTO l_error_count
324: FROM pon_interface_errors
325: WHERE request_id = p_request_id;
326:
327: RETURN l_error_count;
328:

Line 736: delete from pon_interface_errors

732: Delete all the errors in the interface table that have
733: expiration date marked as less than the current date
734:
735: */
736: delete from pon_interface_errors
737: where trunc(expiration_date) <= trunc(sysdate);
738:
739: /*
740: