APPS.CSD_RECEIVE_UTIL dependencies on PO_INTERFACE_ERRORS

Line 492: /* description : Checks the PO_INTERFACE_ERRORS table to see of there are any error records created by the */

488: END validate_rcv_input;
489:
490: /*-----------------------------------------------------------------------------------------------------------*/
491: /* procedure name: CHECK_RCV_ERRORS */
492: /* description : Checks the PO_INTERFACE_ERRORS table to see of there are any error records created by the */
493: /* receiving transaction processor.. */
494: /* Called from : CSD_RECEIVE_PVT.RECEIVE_ITEM */
495: /* Input Parm : p_request_group_id NUMBER Required */
496: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/

Line 536: -- Cursor to select the receiving errors from po_interface_errors table

532: FROM rcv_transactions_interface
533: WHERE GROUP_ID = p_group_id;
534:
535:
536: -- Cursor to select the receiving errors from po_interface_errors table
537: CURSOR cur_rcv_errors (
538: p_hdr_intf_id NUMBER,
539: p_line_intf_id NUMBER
540: )

Line 543: FROM po_interface_errors

539: p_line_intf_id NUMBER
540: )
541: IS
542: SELECT column_name, error_message
543: FROM po_interface_errors
544: WHERE (interface_header_id = p_hdr_intf_id OR
545: interface_line_id = p_line_intf_id) ;
546:
547: -- Cursor to derive the transaction_details