APPS.RCV_OPSM_DLV_BE_PKG dependencies on FND_PROFILE

Line 48: g_asn_debug VARCHAR2(1):= NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');

44: m number:=1;
45:
46: l_module_name CONSTANT VARCHAR2(1000):= 'rcv.plsql.'||G_PKG_NAME||'.'||'RCV_OPSM_DLV_EVENT';
47: l_msg_data VARCHAR2(2000):=NULL;
48: g_asn_debug VARCHAR2(1):= NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
49:
50: TYPE delivery_count IS TABLE OF NUMBER INDEX BY VARCHAR2(255);
51: del_count delivery_count;
52:

Line 589: g_asn_debug VARCHAR2(1):= NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');

585: l_count NUMBER:=0;
586: l_count1 NUMBER:=0;
587: l_module_name CONSTANT VARCHAR2(100):= 'rcv.plsql.' ||G_PKG_NAME || '.' || 'RCV_OPSM_CHECK';
588: l_msg_data VARCHAR2(2000):=NULL;
589: g_asn_debug VARCHAR2(1):= NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
590:
591: CURSOR c_opsm_items
592: IS
593: SELECT ROLV.item_id,ROLV.organization_id