APPS.PA_PAXTRTRX_XMLP_PKG dependencies on PA_TRANSACTION_INTERFACE

Line 123: PA_TRANSACTION_INTERFACE

119: WHERE TXN_INTERFACE_ID in (
120: SELECT
121: TXN_INTERFACE_ID
122: FROM
123: PA_TRANSACTION_INTERFACE
124: WHERE INTERFACE_ID = P_XFACE_ID
125: AND ( ( TRANSACTION_STATUS_CODE = 'A' )
126: OR ( TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR' ) ) );
127: EXCEPTION

Line 131: DELETE FROM PA_TRANSACTION_INTERFACE

127: EXCEPTION
128: WHEN NO_DATA_FOUND THEN
129: NULL;
130: END;
131: DELETE FROM PA_TRANSACTION_INTERFACE
132: WHERE INTERFACE_ID = P_XFACE_ID
133: AND ( ( TRANSACTION_STATUS_CODE = 'A' )
134: OR ( TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR' ) );
135: END IF;