DBA Data[Home] [Help]

APPS.CSM_AUTO_SYNC_NFN_PKG dependencies on CSM_AUTO_SYNC_NFN_INQ

Line 31: FROM csm_auto_sync_nfn_inq

27:
28:
29: CURSOR c_auto_sync_nfn_inq( b_user_name VARCHAR2, b_tranid NUMBER) IS
30: SELECT *
31: FROM csm_auto_sync_nfn_inq
32: WHERE tranid$$ = b_tranid
33: AND clid$$cs = b_user_name;
34: -----------------------------------------------------------------------------------------------------------
35:

Line 318: -- delete csm_auto_sync_nfn_inq where clid$$cs = l_user_name and notification_id = l_notification_id;

314: RAISE NO_DATA_FOUND;
315: END IF;
316:
317: -- success
318: -- delete csm_auto_sync_nfn_inq where clid$$cs = l_user_name and notification_id = l_notification_id;
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: EXCEPTION
322: