APPS.PO_RCVIERR_XMLP_PKG dependencies on PO_INTERFACE_ERRORS

Line 11: DELETE FROM PO_INTERFACE_ERRORS POI

7: IF (C_1 = 0 AND C_2 = 0) THEN
8: RETURN (true);
9: ELSE
10: IF P_PURGE_DATA = 'Y' THEN
11: DELETE FROM PO_INTERFACE_ERRORS POI
12: WHERE POI.INTERFACE_HEADER_ID in (
13: SELECT
14: RHI.HEADER_INTERFACE_ID
15: FROM

Line 16: PO_INTERFACE_ERRORS POI,

12: WHERE POI.INTERFACE_HEADER_ID in (
13: SELECT
14: RHI.HEADER_INTERFACE_ID
15: FROM
16: PO_INTERFACE_ERRORS POI,
17: RCV_HEADERS_INTERFACE RHI
18: WHERE POI.INTERFACE_HEADER_ID = RHI.HEADER_INTERFACE_ID
19: AND ( ( TO_DATE(TO_CHAR(TRUNC(POI.CREATION_DATE)
20: ,'DD-MON-YYYY')

Line 30: DELETE FROM PO_INTERFACE_ERRORS POI

26: OR P_END_DATE is not null ) )
27: OR ( P_START_DATE is null
28: AND P_END_DATE is null
29: AND RHI.PROCESSING_STATUS_CODE NOT IN ( 'PENDING' ) ) ) );
30: DELETE FROM PO_INTERFACE_ERRORS POI
31: WHERE POI.INTERFACE_LINE_ID in (
32: SELECT
33: RTI.INTERFACE_TRANSACTION_ID
34: FROM

Line 35: PO_INTERFACE_ERRORS POI,

31: WHERE POI.INTERFACE_LINE_ID in (
32: SELECT
33: RTI.INTERFACE_TRANSACTION_ID
34: FROM
35: PO_INTERFACE_ERRORS POI,
36: RCV_TRANSACTIONS_INTERFACE RTI
37: WHERE POI.INTERFACE_LINE_ID = RTI.INTERFACE_TRANSACTION_ID
38: AND POI.INTERFACE_TYPE = 'RCV-856'
39: AND ( ( TRUNC(TO_DATE(TO_CHAR(POI.CREATION_DATE

Line 50: DELETE FROM PO_INTERFACE_ERRORS POI

46: OR P_END_DATE is not null ) )
47: OR ( P_START_DATE is null
48: AND P_END_DATE is null
49: AND RTI.PROCESSING_STATUS_CODE NOT IN ( 'PENDING' ) ) ) );
50: DELETE FROM PO_INTERFACE_ERRORS POI
51: WHERE POI.INTERFACE_TRANSACTION_ID in (
52: SELECT
53: RTI.INTERFACE_TRANSACTION_ID
54: FROM

Line 55: PO_INTERFACE_ERRORS POI,

51: WHERE POI.INTERFACE_TRANSACTION_ID in (
52: SELECT
53: RTI.INTERFACE_TRANSACTION_ID
54: FROM
55: PO_INTERFACE_ERRORS POI,
56: RCV_TRANSACTIONS_INTERFACE RTI
57: WHERE POI.INTERFACE_TRANSACTION_ID = RTI.INTERFACE_TRANSACTION_ID
58: AND POI.INTERFACE_TYPE in ( 'RECEIVE' , 'DELIVER' )
59: AND ( ( TRUNC(TO_DATE(TO_CHAR(POI.CREATION_DATE