APPS.CSM_UTIL_PKG dependencies on CSM_DEFERRED_NFN_INFO

Line 1524: FROM CSM_DEFERRED_NFN_INFO

1520: -- reqd if tracking records are reapplied via MFS Admin pages
1521: IF asg_defer.is_deferred(p_user_name, p_tranid,p_pub_name, p_seqno)=FND_API.G_TRUE THEN
1522: BEGIN
1523: SELECT TRACKING_ID INTO l_tracking_id
1524: FROM CSM_DEFERRED_NFN_INFO
1525: WHERE DEFERRED_TRAN_ID=p_tranid
1526: AND CLIENT_ID=p_user_name
1527: AND SEQUENCE = p_seqno
1528: AND OBJECT_NAME=p_pub_name

Line 1538: DELETE FROM CSM_DEFERRED_NFN_INFO

1534: ,P_PK1_NAME => 'TRACKING_ID'
1535: ,P_PK1_NUM_VALUE => l_tracking_id
1536: ,P_USER_ID => asg_base.get_user_id(p_user_name)
1537: );
1538: DELETE FROM CSM_DEFERRED_NFN_INFO
1539: WHERE TRACKING_ID=l_tracking_id;
1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: NULL;