APPS.CSM_PROFILE_EVENT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

SELECT acc.access_id,acc.user_id FROM  csm_profile_option_values_acc acc
WHERE NOT EXISTS (SELECT 1 FROM fnd_profile_option_values val
				WHERE acc.profile_option_id = val.profile_option_id
				AND acc.application_id = val.application_id
				AND acc.level_id = val.level_id
				AND acc.level_value = val.level_value
				AND (acc.level_id <> 10003 OR acc.level_value_application_id=val.level_value_application_id))
UNION
SELECT access_id,user_id FROM csm_profile_option_values_acc ACC
WHERE NOT EXISTS( SELECT 1 FROM  FND_PROFILE_OPTIONS OPT
                   WHERE OPT.PROFILE_OPTION_ID = ACC.PROFILE_OPTION_ID
                   AND   OPT.APPLICATION_ID = ACC.APPLICATION_ID
		           AND NVL(OPT.start_date_active, SYSDATE) <= SYSDATE
                   AND NVL(OPT.end_date_active,   SYSDATE) >= SYSDATE
				   AND (opt.profile_option_name = 'CSF_M_RECIPIENTS_BOUNDARY'
						OR opt.profile_option_name = 'CSF_MOBILE_TASK_TIMES_UPDATABLE'
						OR opt.profile_option_name = 'CSF_DEBRIEF_OVERLAPPING_LABOR'
						OR opt.profile_option_name  = 'INC_DEFAULT_INCIDENT_SEVERITY'
						OR opt.profile_option_name  = 'INC_DEFAULT_INCIDENT_URGENCY'
						OR opt.profile_option_name  = 'INC_DEFAULT_INCIDENT_STATUS'
						OR opt.profile_option_name  = 'INC_DEFAULT_INCIDENT_TYPE'
						OR opt.profile_option_name  = 'JTF_TIME_UOM_CLASS'
						OR opt.profile_option_name  = 'ICX_PREFERRED_CURRENCY'
						OR opt.profile_option_name  = 'JTF_TASK_DEFAULT_ASSIGNEE_STATUS'
						OR opt.profile_option_name  = 'CS_SR_RESTRICT_IB'
						OR opt.profile_option_name  = 'SERVER_TIMEZONE_ID'
						OR opt.profile_option_name  = 'CLIENT_TIMEZONE_ID'
						OR opt.profile_option_name  = 'CSF_BUSINESS_PROCESS'
						OR opt.profile_option_name  = 'CSM_SEARCH_RESULT_SET_SIZE'
						OR opt.profile_option_name  = 'CSM_IB_ITEMS_AT_LOCATION'
						OR opt.profile_option_name  = 'CSM_ITEM_CATEGORY_SET_FILTER'
						OR opt.profile_option_name  = 'CSM_ITEM_CATEGORY_FILTER'
						OR opt.profile_option_name  = 'CS_INV_VALIDATION_ORG'
						OR opt.profile_option_name  = 'CSM_ENABLE_CREATE_SR'
						OR opt.profile_option_name  = 'CSM_ENABLE_CREATE_TASK'
						OR opt.profile_option_name  = 'CSM_ENABLE_UPDATE_ASSIGNMENTS'
						OR opt.profile_option_name  = 'CSM_ENABLE_VIEW_CUST_PRODUCTS'
						OR opt.profile_option_name  = 'CSM_MAX_READINGS_PER_COUNTER'
						OR opt.profile_option_name =  'CSF_RETURN_REASON'
						OR opt.profile_option_name  = 'CSFW_DEFAULT_DISTANCE_UNIT'
						OR opt.profile_option_name  = 'CSF_CAPTURE_TRAVEL'
						OR opt.profile_option_name  = 'CSM_LABOR_LINE_TOTAL_CHECK'
						OR opt.profile_option_name  = 'ICX_DATE_FORMAT_MASK'
						OR opt.profile_option_name  = 'JTM_TIMEPICKER_FORMAT'
						OR opt.profile_option_name  = 'CSM_TIME_REASONABILITY_CHECK_APPLY'
						OR opt.profile_option_name  = 'ICX_NUMERIC_CHARACTERS'
						OR opt.profile_option_name  = 'CSF_LABOR_DEBRIEF_DEFAULT_UOM'
						OR opt.profile_option_name  = 'CSF_UOM_HOURS'
						OR opt.profile_option_name  = 'CSZ_DEFAULT_CONTACT_BY'
						OR opt.profile_option_name  = 'HZ_REF_TERRITORY'
						OR opt.profile_option_name  = 'HZ_REF_LANG'
						OR opt.profile_option_name  = 'HZ_LANG_FOR_COUNTRY_DISPLAY'
						OR opt.profile_option_name  = 'CSM_MAX_ATTACHMENT_SIZE'  --For PPC
						OR opt.profile_option_name  = 'CSF_UOM_MINUTES'
						OR opt.profile_option_name  = 'CSF_DEFAULT_TASK_STATUS_PERSONAL'
						OR opt.profile_option_name  = 'CSF_DEFAULT_TASK_TYPE_PERSONAL'
						OR opt.profile_option_name  = 'CSF:DEFAULT DEBRIEF BUSINESS PROCESS'
						OR opt.profile_option_name  = 'CSF:DEFAULT DEBRIEF TRANSACTION TYPE'
						OR opt.profile_option_name  = 'INV:EXPENSE_TO_ASSET_TRANSFER'
						OR opt.profile_option_name  = 'JTF_PROFILE_DEFAULT_CURRENCY'
						OR opt.profile_option_name  = 'CSF_DEFAULT_TASK_ASSIGNED_STATUS'
						OR opt.profile_option_name  = 'JTF_TASK_DEFAULT_TASK_STATUS'
						OR opt.profile_option_name  = 'JTF_TASK_DEFAULT_TASK_PRIORITY'
						OR opt.profile_option_name  = 'CSFW_PLANNED_TASK_WINDOW'
						OR opt.profile_option_name  = 'CS_SR_CONTACT_MANDATORY'
						OR opt.profile_option_name  = 'CSM_RESTRICT_DEBRIEF'
						OR opt.profile_option_name  = 'CSM_RESTRICT_ORDERS'
						OR opt.profile_option_name  = 'CSM_RESTRICT_TRANSFERS'
						OR opt.profile_option_name  = 'JTF_TASK_DEFAULT_TASK_TYPE'
						OR opt.profile_option_name  = 'CSM_ACCOUNT_MESSAGE_INTERCEPTION'
						OR opt.profile_option_name  = 'CSM_AS_DATA_DOWNLOAD_INTERVAL'
						OR opt.profile_option_name  = 'CSM_AS_DATA_UPLOAD_INTERVAL'
						OR opt.profile_option_name  = 'CSM_ENABLE_AS_STATUS_NFN'
						OR opt.profile_option_name  = 'CSM_NFN_SYNC_ERROR'
						OR opt.profile_option_name  = 'CSM_NOTIFY_DEFERRED'
						OR opt.profile_option_name  = 'CSF_MANDATORY_LABOR_DEBRIEF'
						OR opt.profile_option_name  = 'CSF_MANDATORY_RESOLUTION_CODE'
						OR opt.profile_option_name  = 'CSF_DEFAULT_LABOR_DEBRIEF_DATETIME'
						OR opt.profile_option_name  = 'CSF_RESTRICT_SERVICE_REQUEST_CREATION_ TO_ SCHEDULED_SITES'
						OR opt.profile_option_name  = 'CSM_WIRELESS_URL'
						OR opt.profile_option_name  = 'CSM_ONLINE_ACCESS'
						OR opt.profile_option_name  = 'CSF:DEFAULT DEBRIEF BUSINESS PROCESS'
						OR opt.profile_option_name  = 'CSF_DEFAULT_LABOR_DEBRIEF_DATETIME'
						OR opt.profile_option_name  = 'CSF_DEFAULT_DEBRIEF_SAC_TRAVEL'
						OR opt.profile_option_name  = 'CSM_ALLOW_FREE_FORM_IB'
						OR opt.profile_option_name  = 'CSF: MANDATORY_LABOR_DEBRIEF'
						OR opt.profile_option_name  = 'CSF_DEBRIEF_LABOR_SAC'
						OR opt.profile_option_name  = 'CSF_DEBRIEF_TRAVEL_SAC'
						OR opt.profile_option_name  = 'JTF_NTS_NOTE_STATUS'
						or opt.profile_option_name  = 'CSM_FREE_FORM_ITEM'
						or opt.profile_option_name  = 'CSF_DEBRIEF_SERVICE_DATE'
						OR opt.profile_option_name  = 'CSM_DIS_TASK_SCHED_CONFLICT_WARNING'
						OR opt.profile_option_name  = 'JTF_NTS_NOTE_TYPE'
						OR opt.profile_option_name  = 'CSF_DEBRIEF_RESTRICT_INSTANCE'
						OR opt.profile_option_name  = 'CSF_ENABLE_RETURN_ROUTING_DBF'
						OR opt.profile_option_name  = 'CSP_PART_REQ_DEF_SHIP_TO'
						OR opt.profile_option_name  = 'CSF_GOOGLE_MAP_KEY'
						OR opt.profile_option_name  = 'CSF_GOOGLE_MAP_CLIENT_ID'
						OR opt.profile_option_name  = 'CSF_GOOGLE_MAP_ADDENDUM'
						OR opt.profile_option_name  = 'CSM_CUSTOMIZATION_KEY'
						OR opt.profile_option_name  = 'CSM_DFLT_TASK_STATUS_SYNC_UPD'));

Line: 130

SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID,au.user_id,application_id,profile_option_id,level_id,level_value,LEVEL_VALUE_APPLICATION_ID,
       fnd_profile.value_specific(profile_option_name,au.user_id,au.responsibility_id,au.APP_ID) PRF_VALUE,profile_option_name prf_name
FROM asg_user au,
	(SELECT opt.profile_option_name,val.application_id, val.profile_option_id,au.user_id,max(val.level_id) as LEVEL_ID ,
		   decode(max(val.level_id),10004,au.user_id,10003,asg_base.get_resp_id(au.user_name),10002,asg_base.get_application_id(au.user_name),0) LEVEL_VALUE,
		   decode(max(val.level_id),10003,max(level_value_application_id),null) LEVEL_VALUE_APPLICATION_ID
	FROM   fnd_profile_options opt,
		   fnd_profile_option_values val,
		   asg_user au
	WHERE opt.profile_option_name in ( 'CSF_M_RECIPIENTS_BOUNDARY' ,'CSF_MOBILE_TASK_TIMES_UPDATABLE' ,'CSF_DEBRIEF_OVERLAPPING_LABOR' ,'INC_DEFAULT_INCIDENT_SEVERITY'
	  ,'INC_DEFAULT_INCIDENT_URGENCY' ,'JTF_TIME_UOM_CLASS' ,'ICX_PREFERRED_CURRENCY' ,'JTF_TASK_DEFAULT_ASSIGNEE_STATUS' ,'CS_SR_RESTRICT_IB' ,'SERVER_TIMEZONE_ID'
	  ,'CLIENT_TIMEZONE_ID' ,'CSF_BUSINESS_PROCESS' ,'CSM_SEARCH_RESULT_SET_SIZE' ,'CSM_IB_ITEMS_AT_LOCATION' ,'CSM_ITEM_CATEGORY_SET_FILTER' ,'CSM_ITEM_CATEGORY_FILTER'
	  ,'CS_INV_VALIDATION_ORG' ,'INC_DEFAULT_INCIDENT_TYPE' ,'INC_DEFAULT_INCIDENT_STATUS' ,'CSM_ENABLE_CREATE_SR'
	  ,'CSM_ENABLE_CREATE_TASK' ,'CSM_ENABLE_UPDATE_ASSIGNMENTS'
	  ,'CSM_ENABLE_VIEW_CUST_PRODUCTS' ,'CSM_MAX_READINGS_PER_COUNTER' ,'CSF_RETURN_REASON' ,'CSFW_DEFAULT_DISTANCE_UNIT'
	  ,'CSF_CAPTURE_TRAVEL' ,'CSM_LABOR_LINE_TOTAL_CHECK'
	  ,'ICX_DATE_FORMAT_MASK' ,'JTM_TIMEPICKER_FORMAT' ,'CSM_TIME_REASONABILITY_CHECK_APPLY','ICX_NUMERIC_CHARACTERS' ,'CSF_LABOR_DEBRIEF_DEFAULT_UOM'
	  ,'CSF_UOM_HOURS' ,'CSZ_DEFAULT_CONTACT_BY' ,'HZ_REF_TERRITORY' ,'HZ_REF_LANG' ,'HZ_LANG_FOR_COUNTRY_DISPLAY' ,'CSM_MAX_ATTACHMENT_SIZE','CSF_UOM_MINUTES'
	  ,'CSF_DEFAULT_TASK_STATUS_PERSONAL' ,'CSF_DEFAULT_TASK_TYPE_PERSONAL'   ,'CSF:DEFAULT DEBRIEF BUSINESS PROCESS' ,'CSF:DEFAULT DEBRIEF TRANSACTION TYPE'
	  ,'INV:EXPENSE_TO_ASSET_TRANSFER' ,'JTF_PROFILE_DEFAULT_CURRENCY' ,'CSF_DEFAULT_TASK_ASSIGNED_STATUS'
	  ,'JTF_TASK_DEFAULT_TASK_STATUS' ,'JTF_TASK_DEFAULT_TASK_PRIORITY'
	  ,'CSFW_PLANNED_TASK_WINDOW' ,'CS_SR_CONTACT_MANDATORY' ,'CSM_RESTRICT_DEBRIEF' ,'CSM_RESTRICT_ORDERS' ,'CSM_RESTRICT_TRANSFERS' ,'JTF_TASK_DEFAULT_TASK_TYPE'
	  ,'CSM_ACCOUNT_MESSAGE_INTERCEPTION' ,'CSM_AS_DATA_DOWNLOAD_INTERVAL','CSM_AS_DATA_UPLOAD_INTERVAL'
	  ,'CSM_ENABLE_AS_STATUS_NFN' ,'CSM_NFN_SYNC_ERROR' ,'CSM_NOTIFY_DEFERRED'
	  ,'CSF_MANDATORY_LABOR_DEBRIEF','CSF_MANDATORY_RESOLUTION_CODE' ,'CSF_DEFAULT_LABOR_DEBRIEF_DATETIME' ,'CSF_RESTRICT_SERVICE_REQUEST_CREATION_ TO_ SCHEDULED_SITES'
	  ,'CSM_WIRELESS_URL' ,'CSM_ONLINE_ACCESS' ,'CSF:DEFAULT DEBRIEF BUSINESS PROCESS' ,'CSF_DEFAULT_LABOR_DEBRIEF_DATETIME' ,'CSF_DEFAULT_DEBRIEF_SAC_TRAVEL'
	  ,'CSM_ALLOW_FREE_FORM_IB' ,'CSF: MANDATORY_LABOR_DEBRIEF'   ,'CSF_DEBRIEF_LABOR_SAC' ,'CSF_DEBRIEF_TRAVEL_SAC' ,'JTF_NTS_NOTE_STATUS' ,'CSM_FREE_FORM_ITEM'
	  ,'CSF_DEBRIEF_SERVICE_DATE','CSM_DIS_TASK_SCHED_CONFLICT_WARNING' ,'JTF_NTS_NOTE_TYPE','CSF_DEBRIEF_RESTRICT_INSTANCE' ,'CSF_ENABLE_RETURN_ROUTING_DBF'
	  ,'CSP_PART_REQ_DEF_SHIP_TO','CSF_GOOGLE_MAP_KEY','CSF_GOOGLE_MAP_CLIENT_ID','CSF_GOOGLE_MAP_ADDENDUM','CSM_CUSTOMIZATION_KEY','CSM_DFLT_TASK_STATUS_SYNC_UPD')
	AND val.application_id = opt.application_id
	AND val.profile_option_id = opt.profile_option_id
	AND NVL(opt.start_date_active, SYSDATE) <= SYSDATE
	AND NVL(opt.end_date_active,   SYSDATE) >= SYSDATE
	AND level_id in (10001,10002,10003,10004)
	AND (level_id<> 10002 OR level_value=au.APP_ID)
	AND (level_id <> 10003 OR level_value=au.responsibility_id)
	AND (level_id <> 10004 OR level_value=au.user_id)
	AND au.enabled='Y'
	group by  opt.profile_option_name,val.application_id, val.profile_option_id,au.user_id,au.user_name
	) tab
WHERE au.USER_ID=tab.user_id
AND not exists(SELECT 1 FROM csm_profile_option_values_acc acc
               WHERE acc.application_id = tab.application_id
			   AND acc.profile_option_id = tab.profile_option_id
			   AND acc.user_id = tab.user_id);

Line: 179

SELECT acc.access_id,acc.user_id,val.level_id,val.level_value,val.LEVEL_VALUE_APPLICATION_ID,val.profile_option_value
FROM fnd_profile_option_values val,
     csm_profile_option_values_acc acc,asg_user au
WHERE  val.profile_option_id = acc.profile_option_id
 AND val.application_id     = acc.application_id
 AND val.level_id in (10001,10002,10003,10004)
 AND (val.level_id<> 10002 OR val.level_value=au.app_id)
 AND (val.level_id <> 10003 OR val.level_value=au.responsibility_id)
 AND (val.level_id <> 10004 OR val.level_value=au.user_id)
 AND au.user_id=acc.user_id
 AND (
     acc.level_id < val.level_id    --finer level profile available
     OR
     (acc.level_id           = val.level_id                   --current level modified
      AND acc.level_value        = val.level_value
      AND (acc.level_id <> 10003 OR acc.level_value_application_id=val.level_value_application_id)
      AND NVL(val.profile_option_value,-1) <> NVL(acc.profile_option_value,-1)
      )
  );

Line: 216

 /*****DELETES*****************/

 CSM_UTIL_PKG.LOG('Processing Deletes' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

Line: 222

  	 l_tab_access_id.DELETE;

Line: 223

	 l_tab_user_id.DELETE;

Line: 227

	 CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from csm_profile_option_values_acc' ,
						 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

Line: 239

		DELETE FROM csm_profile_option_values_acc WHERE access_id = l_tab_access_id(i);

Line: 246

  /*****************UPDATES*****************/

  CSM_UTIL_PKG.LOG('Processing Updates' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

Line: 252

  	 l_tab_access_id.DELETE;

Line: 253

	 l_tab_user_id.DELETE;

Line: 254

	 l_tab_l_id.DELETE;

Line: 255

	 l_tab_l_val.DELETE;

Line: 256

	 l_tab_lva_id.DELETE;

Line: 257

	 l_tab_pf_val.DELETE;

Line: 262

	 CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records in  csm_profile_option_values_acc' ,
						 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

Line: 274

		UPDATE csm_profile_option_values_acc
		SET LEVEL_ID = l_tab_l_id(i)
		   ,LEVEL_VALUE = l_tab_l_val(i)
		   ,LEVEL_VALUE_APPLICATION_ID =l_tab_lva_id(i)
		   ,profile_option_value = l_tab_pf_val(i)
		   ,last_update_date = sysdate
		WHERE access_id = l_tab_access_id(i);

Line: 287

  /********************* INSERTS *****************************/

  CSM_UTIL_PKG.LOG('Processing Inserts' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

Line: 293

  	 l_tab_access_id.DELETE;

Line: 294

	 l_tab_user_id.DELETE;

Line: 295

	 l_tab_app_id.DELETE;

Line: 296

	 l_tab_prf_id.DELETE;

Line: 297

	 l_tab_l_id.DELETE;

Line: 298

	 l_tab_l_val.DELETE;

Line: 299

	 l_tab_lva_id.DELETE;

Line: 300

	 l_tab_pf_val.DELETE;

Line: 301

     l_tab_prf_name.DELETE;

Line: 307

	 CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_profile_option_values_acc' ,
						 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

Line: 312

       INSERT INTO csm_profile_option_values_acc(access_id, user_id, application_id, profile_option_id,
                                            level_id, level_value, level_value_application_id, profile_option_value,profile_option_name,
                                            created_by,creation_date, last_updated_by, last_update_date, last_update_login )
                                    VALUES (l_tab_access_id(I),l_tab_user_id(I),l_tab_app_id(I),l_tab_prf_id(I),
	                                        l_tab_l_id(I),l_tab_l_val(I),l_tab_lva_id(I),l_tab_pf_val(I),l_tab_prf_name(I),
                                            fnd_global.user_id, sysdate, fnd_global.user_id,sysdate, fnd_global.login_id);

Line: 333

  UPDATE jtm_con_request_data
  SET last_run_date = sysdate,
      last_update_date = SYSDATE
  WHERE package_name = 'CSM_PROFILE_EVENT_PKG'
    AND procedure_name = 'REFRESH_ACC';

Line: 370

SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID,au.user_id,application_id,profile_option_id,level_id,level_value,LEVEL_VALUE_APPLICATION_ID,
       fnd_profile.value_specific(profile_option_name,au.user_id,au.responsibility_id,au.APP_ID) PRF_VALUE,profile_option_name prf_name
FROM asg_user au,
	(SELECT opt.profile_option_name,val.application_id, val.profile_option_id,au.user_id,max(val.level_id) as LEVEL_ID ,
		   decode(max(val.level_id),10004,au.user_id,10003,asg_base.get_resp_id(au.user_name),10002,asg_base.get_application_id(au.user_name),0) LEVEL_VALUE,
		   decode(max(val.level_id),10003,max(level_value_application_id),null) LEVEL_VALUE_APPLICATION_ID
	FROM   fnd_profile_options opt,
		   fnd_profile_option_values val,
		   asg_user au
	WHERE opt.profile_option_name in ( 'CSF_M_RECIPIENTS_BOUNDARY' ,'CSF_MOBILE_TASK_TIMES_UPDATABLE' ,'CSF_DEBRIEF_OVERLAPPING_LABOR'
	,'INC_DEFAULT_INCIDENT_SEVERITY' ,'INC_DEFAULT_INCIDENT_URGENCY'
	  ,'JTF_TIME_UOM_CLASS' ,'ICX_PREFERRED_CURRENCY' ,'JTF_TASK_DEFAULT_ASSIGNEE_STATUS' ,'CS_SR_RESTRICT_IB' ,'SERVER_TIMEZONE_ID'
	  ,'CLIENT_TIMEZONE_ID' ,'CSF_BUSINESS_PROCESS'
	  ,'CSM_SEARCH_RESULT_SET_SIZE' ,'CSM_IB_ITEMS_AT_LOCATION' ,'CSM_ITEM_CATEGORY_SET_FILTER' ,'CSM_ITEM_CATEGORY_FILTER'
	  ,'CS_INV_VALIDATION_ORG' ,'INC_DEFAULT_INCIDENT_TYPE'
	  ,'INC_DEFAULT_INCIDENT_STATUS' ,'CSM_ENABLE_CREATE_SR' ,'CSM_ENABLE_CREATE_TASK' ,'CSM_ENABLE_UPDATE_ASSIGNMENTS'
	  ,'CSM_ENABLE_VIEW_CUST_PRODUCTS' ,'CSM_MAX_READINGS_PER_COUNTER'
	  ,'CSF_RETURN_REASON' ,'CSFW_DEFAULT_DISTANCE_UNIT' ,'CSF_CAPTURE_TRAVEL' ,'CSM_LABOR_LINE_TOTAL_CHECK'   ,'ICX_DATE_FORMAT_MASK'
	  ,'JTM_TIMEPICKER_FORMAT' ,'CSM_TIME_REASONABILITY_CHECK_APPLY'
	  ,'ICX_NUMERIC_CHARACTERS' ,'CSF_LABOR_DEBRIEF_DEFAULT_UOM' ,'CSF_UOM_HOURS' ,'CSZ_DEFAULT_CONTACT_BY'
	  ,'HZ_REF_TERRITORY' ,'HZ_REF_LANG' ,'HZ_LANG_FOR_COUNTRY_DISPLAY' ,'CSM_MAX_ATTACHMENT_SIZE'
	  ,'CSF_UOM_MINUTES' ,'CSF_DEFAULT_TASK_STATUS_PERSONAL' ,'CSF_DEFAULT_TASK_TYPE_PERSONAL'   ,'CSF:DEFAULT DEBRIEF BUSINESS PROCESS'
	  ,'CSF:DEFAULT DEBRIEF TRANSACTION TYPE','INV:EXPENSE_TO_ASSET_TRANSFER' ,'JTF_PROFILE_DEFAULT_CURRENCY' ,'CSF_DEFAULT_TASK_ASSIGNED_STATUS'
	  ,'JTF_TASK_DEFAULT_TASK_STATUS' ,'JTF_TASK_DEFAULT_TASK_PRIORITY' ,'CSFW_PLANNED_TASK_WINDOW'
	  ,'CS_SR_CONTACT_MANDATORY' ,'CSM_RESTRICT_DEBRIEF' ,'CSM_RESTRICT_ORDERS' ,'CSM_RESTRICT_TRANSFERS' ,'JTF_TASK_DEFAULT_TASK_TYPE'
	  ,'CSM_ACCOUNT_MESSAGE_INTERCEPTION' ,'CSM_AS_DATA_DOWNLOAD_INTERVAL'
	  ,'CSM_AS_DATA_UPLOAD_INTERVAL' ,'CSM_ENABLE_AS_STATUS_NFN' ,'CSM_NFN_SYNC_ERROR' ,'CSM_NOTIFY_DEFERRED'
	  ,'CSF_MANDATORY_LABOR_DEBRIEF' ,'CSF_MANDATORY_RESOLUTION_CODE'
	  ,'CSF_DEFAULT_LABOR_DEBRIEF_DATETIME' ,'CSF_RESTRICT_SERVICE_REQUEST_CREATION_ TO_ SCHEDULED_SITES' ,'CSM_WIRELESS_URL'
	  ,'CSM_ONLINE_ACCESS' ,'CSF:DEFAULT DEBRIEF BUSINESS PROCESS'
	  ,'CSF_DEFAULT_LABOR_DEBRIEF_DATETIME' ,'CSF_DEFAULT_DEBRIEF_SAC_TRAVEL' ,'CSM_ALLOW_FREE_FORM_IB' ,'CSF: MANDATORY_LABOR_DEBRIEF'
	  ,'CSF_DEBRIEF_LABOR_SAC' ,'CSF_DEBRIEF_TRAVEL_SAC'
	  ,'JTF_NTS_NOTE_STATUS' ,'CSM_FREE_FORM_ITEM' ,'CSF_DEBRIEF_SERVICE_DATE' ,'CSM_DIS_TASK_SCHED_CONFLICT_WARNING'
	  ,'JTF_NTS_NOTE_TYPE','CSF_DEBRIEF_RESTRICT_INSTANCE' ,'CSF_ENABLE_RETURN_ROUTING_DBF','CSP_PART_REQ_DEF_SHIP_TO'
	  ,'CSF_GOOGLE_MAP_KEY','CSF_GOOGLE_MAP_CLIENT_ID','CSF_GOOGLE_MAP_ADDENDUM','CSM_CUSTOMIZATION_KEY','CSM_DFLT_TASK_STATUS_SYNC_UPD')
	AND val.application_id = opt.application_id
	AND val.profile_option_id = opt.profile_option_id
	AND NVL(opt.start_date_active, SYSDATE) <= SYSDATE
	AND NVL(opt.end_date_active,   SYSDATE) >= SYSDATE
	AND level_id in (10001,10002,10003,10004)
	AND (level_id<> 10002 OR level_value=au.APP_ID)
	AND (level_id <> 10003 OR level_value=au.responsibility_id)
	AND (level_id <> 10004 OR level_value=au.user_id)
	AND au.user_id=p_user_id
	group by  opt.profile_option_name,val.application_id, val.profile_option_id,au.user_id,au.user_name
	) tab
WHERE au.USER_ID=tab.user_id
AND not exists(SELECT 1 FROM csm_profile_option_values_acc acc
               WHERE acc.application_id = tab.application_id
			   AND acc.profile_option_id = tab.profile_option_id
			   AND acc.user_id = tab.user_id);

Line: 438

 CSM_UTIL_PKG.LOG('Entering Profile Inserts Acc for new user: '||p_user_id , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

Line: 442

  	 l_tab_access_id.DELETE;

Line: 443

	 l_tab_user_id.DELETE;

Line: 444

	 l_tab_app_id.DELETE;

Line: 445

	 l_tab_prf_id.DELETE;

Line: 446

	 l_tab_l_id.DELETE;

Line: 447

	 l_tab_l_val.DELETE;

Line: 448

	 l_tab_lva_id.DELETE;

Line: 449

	 l_tab_pf_val.DELETE;

Line: 450

	 l_tab_prf_name.DELETE;

Line: 456

	 CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_profile_option_values_acc' ,
						 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

Line: 461

       INSERT INTO csm_profile_option_values_acc(access_id, user_id, application_id, profile_option_id,
                                            level_id, level_value, level_value_application_id, profile_option_value,profile_option_name,
                                            created_by,creation_date, last_updated_by, last_update_date, last_update_login )
                                    VALUES (l_tab_access_id(I),l_tab_user_id(I),l_tab_app_id(I),l_tab_prf_id(I),
	                                        l_tab_l_id(I),l_tab_l_val(I),l_tab_lva_id(I),l_tab_pf_val(I),l_tab_prf_name(I),
                                            fnd_global.user_id, sysdate, fnd_global.user_id,sysdate, fnd_global.login_id);

Line: 478

  CSM_UTIL_PKG.LOG('Leaving Profile Insert Acc for user'||p_user_id , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

Line: 489

	IF PROFILES with no "value" set, is required, then add this inside "tab" of insert cursor  */
	/*
	 UNION ALL
    SELECT opt.profile_option_name,opt.application_id, opt.profile_option_id,au.user_id,null as LEVEL_ID , null LEVEL_VALUE, null LEVEL_VALUE_APPLICATION_ID
	FROM   fnd_profile_options opt,asg_user au
    WHERE opt.profile_option_name in ( 'CSF_M_RECIPIENTS_BOUNDARY' ,'CSF_MOBILE_TASK_TIMES_UPDATABLE' ,'CSF_DEBRIEF_OVERLAPPING_LABOR'
	,'INC_DEFAULT_INCIDENT_SEVERITY' ,'INC_DEFAULT_INCIDENT_URGENCY'
	  ,'JTF_TIME_UOM_CLASS' ,'ICX_PREFERRED_CURRENCY' ,'JTF_TASK_DEFAULT_ASSIGNEE_STATUS' ,'CS_SR_RESTRICT_IB' ,'SERVER_TIMEZONE_ID'
	  ,'CLIENT_TIMEZONE_ID' ,'CSF_BUSINESS_PROCESS'
	  ,'CSM_SEARCH_RESULT_SET_SIZE' ,'CSM_IB_ITEMS_AT_LOCATION' ,'CSM_ITEM_CATEGORY_SET_FILTER' ,'CSM_ITEM_CATEGORY_FILTER'
	  ,'CS_INV_VALIDATION_ORG' ,'INC_DEFAULT_INCIDENT_TYPE'
	  ,'INC_DEFAULT_INCIDENT_STATUS' ,'CSM_ENABLE_CREATE_SR' ,'CSM_ENABLE_CREATE_TASK' ,'CSM_ENABLE_UPDATE_ASSIGNMENTS'
	  ,'CSM_ENABLE_VIEW_CUST_PRODUCTS' ,'CSM_MAX_READINGS_PER_COUNTER'
	  ,'CSF_RETURN_REASON' ,'CSFW_DEFAULT_DISTANCE_UNIT' ,'CSF_CAPTURE_TRAVEL' ,'CSM_LABOR_LINE_TOTAL_CHECK'   ,'ICX_DATE_FORMAT_MASK'
	  ,'JTM_TIMEPICKER_FORMAT' ,'CSM_TIME_REASONABILITY_CHECK_APPLY'
	  ,'ICX_NUMERIC_CHARACTERS' ,'CSF_LABOR_DEBRIEF_DEFAULT_UOM' ,'CSF_UOM_HOURS' ,'CSZ_DEFAULT_CONTACT_BY'
	  ,'HZ_REF_TERRITORY' ,'HZ_REF_LANG' ,'HZ_LANG_FOR_COUNTRY_DISPLAY' ,'CSM_MAX_ATTACHMENT_SIZE'
	  ,'CSF_UOM_MINUTES' ,'CSF_DEFAULT_TASK_STATUS_PERSONAL' ,'CSF_DEFAULT_TASK_TYPE_PERSONAL'   ,'CSF:DEFAULT DEBRIEF BUSINESS PROCESS'
	  ,'CSF:DEFAULT DEBRIEF TRANSACTION TYPE','INV:EXPENSE_TO_ASSET_TRANSFER' ,'JTF_PROFILE_DEFAULT_CURRENCY' ,'CSF_DEFAULT_TASK_ASSIGNED_STATUS'
	  ,'JTF_TASK_DEFAULT_TASK_STATUS' ,'JTF_TASK_DEFAULT_TASK_PRIORITY' ,'CSFW_PLANNED_TASK_WINDOW'
	  ,'CS_SR_CONTACT_MANDATORY' ,'CSM_RESTRICT_DEBRIEF' ,'CSM_RESTRICT_ORDERS' ,'CSM_RESTRICT_TRANSFERS' ,'JTF_TASK_DEFAULT_TASK_TYPE'
	  ,'CSM_ACCOUNT_MESSAGE_INTERCEPTION' ,'CSM_AS_DATA_DOWNLOAD_INTERVAL'
	  ,'CSM_AS_DATA_UPLOAD_INTERVAL' ,'CSM_ENABLE_AS_STATUS_NFN' ,'CSM_NFN_SYNC_ERROR' ,'CSM_NOTIFY_DEFERRED'
	  ,'CSF_MANDATORY_LABOR_DEBRIEF' ,'CSF_MANDATORY_RESOLUTION_CODE'
	  ,'CSF_DEFAULT_LABOR_DEBRIEF_DATETIME' ,'CSF_RESTRICT_SERVICE_REQUEST_CREATION_ TO_ SCHEDULED_SITES' ,'CSM_WIRELESS_URL'
	  ,'CSM_ONLINE_ACCESS' ,'CSF:DEFAULT DEBRIEF BUSINESS PROCESS'
	  ,'CSF_DEFAULT_LABOR_DEBRIEF_DATETIME' ,'CSF_DEFAULT_DEBRIEF_SAC_TRAVEL' ,'CSM_ALLOW_FREE_FORM_IB' ,'CSF: MANDATORY_LABOR_DEBRIEF'
	  ,'CSF_DEBRIEF_LABOR_SAC' ,'CSF_DEBRIEF_TRAVEL_SAC'
	  ,'JTF_NTS_NOTE_STATUS' ,'CSM_FREE_FORM_ITEM' ,'CSF_DEBRIEF_SERVICE_DATE' ,'CSM_DIS_TASK_SCHED_CONFLICT_WARNING'
	  ,'JTF_NTS_NOTE_TYPE','CSF_DEBRIEF_RESTRICT_INSTANCE' ,'CSF_ENABLE_RETURN_ROUTING_DBF','CSP_PART_REQ_DEF_SHIP_TO'
	  ,'CSF_GOOGLE_MAP_KEY','CSF_GOOGLE_MAP_CLIENT_ID','CSF_GOOGLE_MAP_ADDENDUM','CSM_CUSTOMIZATION_KEY','CSM_DFLT_TASK_STATUS_SYNC_UPD')
	AND NVL(opt.start_date_active, SYSDATE) <= SYSDATE
	AND NVL(opt.end_date_active,   SYSDATE) >= SYSDATE
	AND NOT EXISTS(SELECT 1 FROM fnd_profile_option_values val WHERE val.application_id = opt.application_id AND val.profile_option_id = opt.profile_option_id)
	AND au.enabled='Y'
	*/

		/****** AFTER INSERT IS COMPLETE, there may be profiles with values set not at site but at app/resp/user level not macthing user-s ; don't think it;s required to be downloaded

Line: 530

    SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID,au.user_id,opt.profile_option_name,opt.application_id, opt.profile_option_id,au.user_id,
	      null as LEVEL_ID , null LEVEL_VALUE, null LEVEL_VALUE_APPLICATION_ID,opt.profile_option_name
	FROM   fnd_profile_options opt,asg_user au
    WHERE opt.profile_option_name in ( 'CSF_M_RECIPIENTS_BOUNDARY' ,'CSF_MOBILE_TASK_TIMES_UPDATABLE' ,'CSF_DEBRIEF_OVERLAPPING_LABOR'
	,'INC_DEFAULT_INCIDENT_SEVERITY' ,'INC_DEFAULT_INCIDENT_URGENCY'
	  ,'JTF_TIME_UOM_CLASS' ,'ICX_PREFERRED_CURRENCY' ,'JTF_TASK_DEFAULT_ASSIGNEE_STATUS' ,'CS_SR_RESTRICT_IB' ,'SERVER_TIMEZONE_ID'
	  ,'CLIENT_TIMEZONE_ID' ,'CSF_BUSINESS_PROCESS'
	  ,'CSM_SEARCH_RESULT_SET_SIZE' ,'CSM_IB_ITEMS_AT_LOCATION' ,'CSM_ITEM_CATEGORY_SET_FILTER' ,'CSM_ITEM_CATEGORY_FILTER'
	  ,'CS_INV_VALIDATION_ORG' ,'INC_DEFAULT_INCIDENT_TYPE'
	  ,'INC_DEFAULT_INCIDENT_STATUS' ,'CSM_ENABLE_CREATE_SR' ,'CSM_ENABLE_CREATE_TASK' ,'CSM_ENABLE_UPDATE_ASSIGNMENTS'
	  ,'CSM_ENABLE_VIEW_CUST_PRODUCTS' ,'CSM_MAX_READINGS_PER_COUNTER'
	  ,'CSF_RETURN_REASON' ,'CSFW_DEFAULT_DISTANCE_UNIT' ,'CSF_CAPTURE_TRAVEL' ,'CSM_LABOR_LINE_TOTAL_CHECK'   ,'ICX_DATE_FORMAT_MASK'
	  ,'JTM_TIMEPICKER_FORMAT' ,'CSM_TIME_REASONABILITY_CHECK_APPLY'
	  ,'ICX_NUMERIC_CHARACTERS' ,'CSF_LABOR_DEBRIEF_DEFAULT_UOM' ,'CSF_UOM_HOURS' ,'CSZ_DEFAULT_CONTACT_BY'
	  ,'HZ_REF_TERRITORY' ,'HZ_REF_LANG' ,'HZ_LANG_FOR_COUNTRY_DISPLAY' ,'CSM_MAX_ATTACHMENT_SIZE'
	  ,'CSF_UOM_MINUTES' ,'CSF_DEFAULT_TASK_STATUS_PERSONAL' ,'CSF_DEFAULT_TASK_TYPE_PERSONAL'   ,'CSF:DEFAULT DEBRIEF BUSINESS PROCESS'
	  ,'CSF:DEFAULT DEBRIEF TRANSACTION TYPE','INV:EXPENSE_TO_ASSET_TRANSFER' ,'JTF_PROFILE_DEFAULT_CURRENCY' ,'CSF_DEFAULT_TASK_ASSIGNED_STATUS'
	  ,'JTF_TASK_DEFAULT_TASK_STATUS' ,'JTF_TASK_DEFAULT_TASK_PRIORITY' ,'CSFW_PLANNED_TASK_WINDOW'
	  ,'CS_SR_CONTACT_MANDATORY' ,'CSM_RESTRICT_DEBRIEF' ,'CSM_RESTRICT_ORDERS' ,'CSM_RESTRICT_TRANSFERS' ,'JTF_TASK_DEFAULT_TASK_TYPE'
	  ,'CSM_ACCOUNT_MESSAGE_INTERCEPTION' ,'CSM_AS_DATA_DOWNLOAD_INTERVAL'
	  ,'CSM_AS_DATA_UPLOAD_INTERVAL' ,'CSM_ENABLE_AS_STATUS_NFN' ,'CSM_NFN_SYNC_ERROR' ,'CSM_NOTIFY_DEFERRED'
	  ,'CSF_MANDATORY_LABOR_DEBRIEF' ,'CSF_MANDATORY_RESOLUTION_CODE'
	  ,'CSF_DEFAULT_LABOR_DEBRIEF_DATETIME' ,'CSF_RESTRICT_SERVICE_REQUEST_CREATION_ TO_ SCHEDULED_SITES' ,'CSM_WIRELESS_URL'
	  ,'CSM_ONLINE_ACCESS' ,'CSF:DEFAULT DEBRIEF BUSINESS PROCESS'
	  ,'CSF_DEFAULT_LABOR_DEBRIEF_DATETIME' ,'CSF_DEFAULT_DEBRIEF_SAC_TRAVEL' ,'CSM_ALLOW_FREE_FORM_IB' ,'CSF: MANDATORY_LABOR_DEBRIEF'
	  ,'CSF_DEBRIEF_LABOR_SAC' ,'CSF_DEBRIEF_TRAVEL_SAC'
	  ,'JTF_NTS_NOTE_STATUS' ,'CSM_FREE_FORM_ITEM' ,'CSF_DEBRIEF_SERVICE_DATE' ,'CSM_DIS_TASK_SCHED_CONFLICT_WARNING'
	  ,'JTF_NTS_NOTE_TYPE','CSF_DEBRIEF_RESTRICT_INSTANCE' ,'CSF_ENABLE_RETURN_ROUTING_DBF','CSP_PART_REQ_DEF_SHIP_TO'
	  ,'CSF_GOOGLE_MAP_KEY','CSF_GOOGLE_MAP_CLIENT_ID','CSF_GOOGLE_MAP_ADDENDUM','CSM_CUSTOMIZATION_KEY','CSM_DFLT_TASK_STATUS_SYNC_UPD')
	AND NVL(opt.start_date_active, SYSDATE) <= SYSDATE
	AND NVL(opt.end_date_active,   SYSDATE) >= SYSDATE
	AND NOT EXISTS(SELECT 1 FROM csm_profile_option_values_acc acc WHERE acc.application_id = opt.application_id AND acc.profile_option_id = opt.profile_option_id)
	AND au.enabled='Y'
	*/

END CSM_PROFILE_EVENT_PKG;