DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on XNP_MSGS

Line 5005: FROM xnp_msgs

5001: msg_status,
5002: body_text,
5003: creation_date,
5004: description
5005: FROM xnp_msgs
5006: WHERE (msg_code like 'CSI%' OR msg_code like 'CSE%')
5007: -- AND nvl(msg_status, 'READY') <> 'PROCESSED' -- COmmented for Bug 3987286
5008: AND msg_status in ('READY','FAILED')
5009: AND msg_creation_date > p_freeze_date

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

5055: /* Description : Check if there is any transactions pending */
5056: /* this Item Instance prior to the current Txn */
5057: /* */
5058: /* If p_mode is CREATE then we need to get the pending txns */
5059: /* from the xnp_msgs by decoding the message. Each valid txn*/
5060: /* will be checked against this list for further processing */
5061: /*-----------------------------------------------------------*/
5062:
5063: PROCEDURE Check_Prior_Txn