APPS.XNP_MESSAGE dependencies on XNP_MSGS_S

Line 319: SELECT ( XNP_MSGS_S.nextval ) INTO x_msg_id FROM DUAL ;

315: )
316: IS
317: BEGIN
318:
319: SELECT ( XNP_MSGS_S.nextval ) INTO x_msg_id FROM DUAL ;
320:
321: END get_sequence;
322:
323: /***************************************************************************

Line 1131: UPDATE XNP_MSGS SET msg_status = p_status,

1127: -- mviswana 11/2001
1128: -- bug fix # 1882340 to populate send_rcv_date
1129:
1130: IF (p_order_id IS NULL) THEN
1131: UPDATE XNP_MSGS SET msg_status = p_status,
1132: send_rcv_date = SYSDATE,
1133: last_update_date = SYSDATE,
1134: description = description || p_error_desc
1135: WHERE msg_id = p_msg_id ;

Line 1137: UPDATE XNP_MSGS SET msg_status = p_status,

1133: last_update_date = SYSDATE,
1134: description = description || p_error_desc
1135: WHERE msg_id = p_msg_id ;
1136: ELSE
1137: UPDATE XNP_MSGS SET msg_status = p_status,
1138: send_rcv_date = SYSDATE,
1139: last_update_date = SYSDATE,
1140: description = description || p_error_desc,
1141: order_id = p_order_id,

Line 1455: UPDATE xnp_msgs SET msg_status = 'READY',

1451: BEGIN
1452:
1453: select msg_code into l_msg_header.message_code from xnp_msgs where msg_id = p_msg_id;
1454:
1455: UPDATE xnp_msgs SET msg_status = 'READY',
1456: last_update_date = SYSDATE,
1457: description = NULL
1458: WHERE msg_id = p_msg_id ;
1459: