APPS.PA_PAAPIMPR_XMLP_PKG dependencies on PA_TRANSACTION_INTERFACE

Line 97: PA_TRANSACTION_INTERFACE PTI

93: WHERE PTS.TRANSACTION_SOURCE in (
94: SELECT
95: PTI.TRANSACTION_SOURCE
96: FROM
97: PA_TRANSACTION_INTERFACE PTI
98: WHERE PTI.ORIG_TRANSACTION_REFERENCE = ORIGINAL_TRANSACTION_REFERENCE );
99: BEGIN
100: FOR rec_c1 IN C1 LOOP
101: DELETE FROM PA_TRANSACTION_XFACE_CONTROL

Line 106: PA_TRANSACTION_INTERFACE

102: WHERE INTERFACE_ID IN (
103: SELECT
104: INTERFACE_ID
105: FROM
106: PA_TRANSACTION_INTERFACE
107: WHERE TRANSACTION_SOURCE = REC_C1.TRANSACTION_SOURCE
108: AND BATCH_NAME = NVL(PA_PAAPIMPR_XMLP_PKG.BATCH_NAME
109: ,BATCH_NAME)
110: AND SYSTEM_LINKAGE = PA_PAAPIMPR_XMLP_PKG.SYSTEM_LINKAGE

Line 114: DELETE FROM PA_TRANSACTION_INTERFACE

110: AND SYSTEM_LINKAGE = PA_PAAPIMPR_XMLP_PKG.SYSTEM_LINKAGE
111: AND ORIG_TRANSACTION_REFERENCE = ORIGINAL_TRANSACTION_REFERENCE )
112: AND STATUS = 'PROCESSED';
113: IF REC_C1.PURGEABLE_FLAG = 'Y' THEN
114: DELETE FROM PA_TRANSACTION_INTERFACE
115: WHERE TRANSACTION_SOURCE = REC_C1.TRANSACTION_SOURCE
116: AND BATCH_NAME = NVL(PA_PAAPIMPR_XMLP_PKG.BATCH_NAME
117: ,BATCH_NAME)
118: AND SYSTEM_LINKAGE = PA_PAAPIMPR_XMLP_PKG.SYSTEM_LINKAGE