DBA Data[Home] [Help]

APPS.WSMPINVL dependencies on WSM_INTERFACE_ERRORS

Line 5292: INSERT INTO WSM_INTERFACE_ERRORS(header_id,message ,

5288: **
5289: ** Bala Balakumar.
5290: **
5291:
5292: INSERT INTO WSM_INTERFACE_ERRORS(header_id,message ,
5293: creation_date, last_update_date, last_updated_by, created_by)
5294: SELECT transaction_id,p_message, sysdate, sysdate,
5295: last_updated_by, created_by
5296: FROM wsm_lot_split_merges_interface

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

5299: and transaction_id=p_header_id;
5300:
5301: */
5302:
5303: -- Call to WSMPUTIL to write to WSM_INTERFACE_ERRORS table.
5304: -- added by Bala Balakumar.
5305: /*BA#IIIP*/
5306:
5307: x_err_msg := (

Line 5412: FROM wsm_interface_errors wie

5408: SELECT distinct
5409: wie.header_id
5410: , wie.message_type
5411: , wie.message
5412: FROM wsm_interface_errors wie
5413: WHERE wie.request_id = requestId
5414: And wie.program_application_id = programApplnId
5415: And wie.program_id = programId;
5416: