APPS.CLN_PO_SYNC_CAT_PKG dependencies on PO_INTERFACE_ERRORS

Line 1712: FROM PO_INTERFACE_ERRORS

1708: -- Cursor to retrieve all the user defined actions
1709: CURSOR PO_OPI_ERRORS(p_int_hdr_id NUMBER) IS
1710: SELECT INTERFACE_LINE_ID, BATCH_ID,
1711: TABLE_NAME, COLUMN_NAME, ERROR_MESSAGE, ERROR_MESSAGE_NAME
1712: FROM PO_INTERFACE_ERRORS
1713: WHERE INTERFACE_HEADER_ID = p_int_hdr_id;
1714: BEGIN
1715:
1716: -- Sets the debug mode to be FILE

Line 1749: from po_interface_errors

1745:
1746: -- Does PO Open Interface errored out
1747: select count(*)
1748: into l_count
1749: from po_interface_errors
1750: where interface_header_id = l_int_hdr_id;
1751:
1752: -- If errored out, open a cursor ? and get all the error rows in po_interface_errors
1753: -- and add them to collaboration message

Line 1752: -- If errored out, open a cursor ? and get all the error rows in po_interface_errors

1748: into l_count
1749: from po_interface_errors
1750: where interface_header_id = l_int_hdr_id;
1751:
1752: -- If errored out, open a cursor ? and get all the error rows in po_interface_errors
1753: -- and add them to collaboration message
1754: IF l_count = 0 THEN
1755:
1756: --Bug : 3732150