DBA Data[Home] [Help]

APPS.WSMPINVL dependencies on WSM_INTERFACE_ERRORS

Line 5460: INSERT INTO WSM_INTERFACE_ERRORS(header_id,message ,

5456: **
5457: ** Bala Balakumar.
5458: **
5459:
5460: INSERT INTO WSM_INTERFACE_ERRORS(header_id,message ,
5461: creation_date, last_update_date, last_updated_by, created_by)
5462: SELECT transaction_id,p_message, sysdate, sysdate,
5463: last_updated_by, created_by
5464: FROM wsm_lot_split_merges_interface

Line 5471: -- Call to WSMPUTIL to write to WSM_INTERFACE_ERRORS table.

5467: and transaction_id=p_header_id;
5468:
5469: */
5470:
5471: -- Call to WSMPUTIL to write to WSM_INTERFACE_ERRORS table.
5472: -- added by Bala Balakumar.
5473: /*BA#IIIP*/
5474:
5475: x_err_msg := (

Line 5580: FROM wsm_interface_errors wie

5576: SELECT distinct
5577: wie.header_id
5578: , wie.message_type
5579: , wie.message
5580: FROM wsm_interface_errors wie
5581: WHERE wie.request_id = requestId
5582: And wie.program_application_id = programApplnId
5583: And wie.program_id = programId;
5584: