DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on XNP_MSGS

Line 4918: FROM xnp_msgs

4914: msg_status,
4915: body_text,
4916: creation_date,
4917: description
4918: FROM xnp_msgs
4919: WHERE (msg_code like 'CSI%' OR msg_code like 'CSE%')
4920: -- AND nvl(msg_status, 'READY') <> 'PROCESSED' -- COmmented for Bug 3987286
4921: AND msg_status in ('READY','FAILED')
4922: AND msg_creation_date > p_freeze_date

Line 4966: /* from the xnp_msgs by decoding the message. Each valid txn*/

4962: /* Description : Check if there is any transactions pending */
4963: /* this Item Instance prior to the current Txn */
4964: /* */
4965: /* If p_mode is CREATE then we need to get the pending txns */
4966: /* from the xnp_msgs by decoding the message. Each valid txn*/
4967: /* will be checked against this list for further processing */
4968: /*-----------------------------------------------------------*/
4969:
4970: PROCEDURE Check_Prior_Txn