APPS.CSM_PROFILE_EVENT_PKG SQL Statements

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

Line: 14

SELECT au.user_id
FROM   asg_user_pub_resps aupr,
       asg_user au
WHERE  aupr.pub_name = 'SERVICEP'
AND    aupr.responsibility_id = p_resp_id
AND    au.user_name = aupr.user_name;

Line: 32

PROCEDURE insert_profiles_acc(p_access_id IN number, p_user_id IN number, p_application_id IN number,
                              p_profile_option_id IN number, p_level_id IN number,
                              p_level_value IN number, p_level_value_application_id IN number,
                              p_profile_option_value IN varchar2, p_creation_date IN date)
IS
BEGIN
  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,
                                            created_by,
                                            creation_date,
                                            last_updated_by,
                                            last_update_date,
                                            last_update_login
                                            )
                                    VALUES (p_access_id,
                                            p_user_id,
                                            p_application_id,
                                            p_profile_option_id,
                                            p_level_id,
                                            p_level_value,
                                            p_level_value_application_id,
                                            p_profile_option_value,
                                            fnd_global.user_id,
                                            p_creation_date,
                                            fnd_global.user_id,
                                            p_creation_date,
                                            fnd_global.login_id
                                            );

Line: 70

END insert_profiles_acc;

Line: 84

l_prog_update_date  jtm_con_request_data.last_run_date%TYPE;

Line: 101

SELECT nvl(last_run_date, (sysdate - 365*50))
FROM   jtm_con_request_data
WHERE  package_name   = 'CSM_PROFILE_EVENT_PKG'
AND    procedure_name = 'REFRESH_ACC';

Line: 107

/*WHENEVER A NEW PROFILE IS ADDED TO INSERT CURSOR, PLEASE DON'T FORGET TO ADD
THAT PROFILE TO C_PURGE CURSOR WHICH WILL OTHERWISE REMOVE IT*/
--Cursor to insert all profiles(without profile value)
CURSOR l_profiles_wovalue_ins_csr
IS
SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID, au.user_id ,
       opt.profile_option_id,  opt.application_id
FROM   fnd_profile_options opt,
       ASG_USER au
WHERE (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  = '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  = 'INC_DEFAULT_INCIDENT_TYPE'
  OR opt.profile_option_name  = 'INC_DEFAULT_INCIDENT_STATUS'
  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'   --new CSM profile, obsoleted CSL profile
  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' --new CSM profile, obsoleted CSL profile
  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'
  )
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.profile_option_id  = opt.profile_option_id
 AND acc.application_id       = opt.application_id
 AND acc.user_id              = au.user_id
);

Line: 186

SELECT val.application_id, val.profile_option_id, val.level_id, val.level_value,
       val.level_value_application_id, val.profile_option_value, opt.profile_option_name
FROM   fnd_profile_options opt,
       fnd_profile_option_values val
WHERE (opt.profile_option_name = 'CSF_M_RECIPIENTS_BOUNDARY'
--  OR opt.profile_option_name = 'CSF_M_AGENDA_ALLOWCHANGESCOMPLETEDTASK'   ---end_dated
  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  = '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  = 'INC_DEFAULT_INCIDENT_TYPE'
  OR opt.profile_option_name  = 'INC_DEFAULT_INCIDENT_STATUS'
  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'
  --R 12 updates
  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'   --new CSM profile, obsoleted CSL profile
  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' --new CSM profile, obsoleted CSL profile
  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'
  )
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 (  (val.level_id = 10001)
    OR (val.level_id = 10004 AND val.level_value IN (SELECT USER_ID FROM ASG_USER WHERE ENABLED= 'Y'))
    OR (val.level_id = 10002 AND val.level_value = p_csm_appl_id)
    OR (val.level_id = 10003 AND val.level_value = p_csm_resp_id)
    )
AND NOT EXISTS
(SELECT 1
 FROM csm_profile_option_values_acc acc
 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
 UNION
 SELECT 1
 FROM csm_profile_option_values_acc acc,
      fnd_responsibility resp
 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
 AND acc.level_value = resp.responsibility_id
 AND acc.level_value_application_id = resp.application_id
 AND SYSDATE BETWEEN nvl(resp.start_date, sysdate) AND nvl(resp.end_date, sysdate)
 )
 ORDER BY val.application_id, val.profile_option_id, val.level_id desc ;

Line: 283

SELECT val.application_id,
  val.profile_option_id,
  val.level_id,
  val.level_value,
  val.level_value_application_id,
  val.profile_option_value,
  acc.user_id,
  acc.access_id
FROM fnd_profile_option_values val,
     csm_profile_option_values_acc acc
WHERE val.profile_option_id = acc.profile_option_id
 AND val.application_id     = acc.application_id
 AND acc.level_id           = val.level_id
 AND acc.level_value        = val.level_value
 AND NVL(val.profile_option_value,-1) <> NVL(acc.profile_option_value,-1);

Line: 302

SELECT acc.access_id, acc.application_id, acc.profile_option_id, acc.level_id, acc.level_value,
       acc.level_value_application_id, acc.profile_option_value, opt.profile_option_name,
       acc.user_id
FROM  csm_profile_option_values_acc acc,
      fnd_profile_options opt
WHERE acc.profile_option_id = opt.profile_option_id
AND   acc.application_id = opt.application_id
AND acc.level_id IS NOT NULL
AND acc.level_value IS NOT NULL
AND (opt.profile_option_name = 'CSF_M_RECIPIENTS_BOUNDARY'
--  OR opt.profile_option_name = 'CSF_M_AGENDA_ALLOWCHANGESCOMPLETEDTASK'
  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  = '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  = 'INC_DEFAULT_INCIDENT_TYPE'
  OR opt.profile_option_name  = 'INC_DEFAULT_INCIDENT_STATUS'
  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'
  --R 12 updates
  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'
  )
AND NOT EXISTS
(SELECT 1
 FROM fnd_profile_option_values val
 WHERE val.application_id = acc.application_id
 AND val.profile_option_id = acc.profile_option_id
 AND val.level_id = acc.level_id
 AND val.level_value = acc.level_value
 AND val.level_id <> 10003
 UNION
 SELECT 1
 FROM fnd_profile_option_values val,
      fnd_responsibility resp
 WHERE val.application_id = acc.application_id
 AND val.profile_option_id = acc.profile_option_id
 AND val.level_id = acc.level_id
 AND val.level_value = acc.level_value
 AND val.level_id = 10003
 AND val.level_value = resp.responsibility_id
 AND val.level_value_application_id = resp.application_id
 AND SYSDATE BETWEEN nvl(resp.start_date, sysdate) AND nvl(resp.end_date, sysdate)
 )
 ORDER BY acc.profile_option_id, acc.level_id desc
 FOR UPDATE OF acc.profile_option_value, acc.level_id, acc.level_value nowait
 ;

Line: 396

 SELECT /*+ index(ACC CSM_PROFILE_VALUES_ACC_N1) */
        ACC.APPLICATION_ID,
        ACC.PROFILE_OPTION_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   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'  --For PPC
                   , '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'
                 )
                 AND NVL(OPT.start_date_active, SYSDATE) <= SYSDATE
                 AND NVL(OPT.end_date_active,   SYSDATE) >= SYSDATE
                 );

Line: 471

 SELECT ACC.ACCESS_ID,ACC.USER_ID
 FROM   csm_profile_option_values_acc ACC
 WHERE ACC.APPLICATION_ID= b_app_id
 AND   ACC.PROFILE_OPTION_ID= b_prfopt_id;

Line: 479

SELECT access_id, profile_option_value, level_id
FROM csm_profile_option_values_acc
WHERE profile_option_id = p_profile_option_id
AND user_id = p_user_id
ORDER BY level_id desc
FOR UPDATE OF profile_option_value, level_id, level_value, last_update_date nowait;

Line: 493

SELECT val.profile_option_value,
       val.level_id,
       val.level_value,
       val.level_value_application_id,
       val.profile_option_id
FROM fnd_profile_options       opt,
     fnd_profile_option_values val
WHERE opt.profile_option_name = p_profile_option_name
AND NVL(opt.start_date_active, SYSDATE) <= SYSDATE
AND NVL(opt.end_date_active,   SYSDATE) >= SYSDATE
AND opt.application_id      = val.application_id
AND opt.profile_option_id   = val.profile_option_id
AND ( ( val.level_id      = 10001
      )
        OR
      ( val.level_id    = 10002    AND
        val.level_value = p_csm_app_id
      ) OR
      ( val.level_id    = 10003    AND
        val.level_value = p_csm_resp_id
      ) OR
      ( val.level_id    = 10004    AND
        val.level_value = p_user_id
       )
    )
ORDER BY val.level_id DESC;

Line: 527

SELECT val.profile_option_value,
       val.level_id,
       val.level_value,
       val.level_value_application_id
FROM fnd_profile_options       opt,
     fnd_profile_option_values val
WHERE opt.profile_option_name = p_profile_option_name
AND NVL(opt.start_date_active, SYSDATE) <= SYSDATE
AND NVL(opt.end_date_active,   SYSDATE) >= SYSDATE
AND opt.application_id      = val.application_id
AND opt.profile_option_id   = val.profile_option_id
AND ( ( val.level_id      = 10001
      )
      OR
     ( val.level_id    = 10002    AND
       val.level_value = p_csm_app_id
     ) OR
     ( val.level_id    = 10003    AND
      val.level_value = p_csm_resp_id
     ) OR
     ( val.level_id    = 10004    AND
       val.level_value = p_user_level_value
     )
   )
ORDER BY val.level_id DESC;

Line: 554

SELECT APPLICATION_ID
FROM fnd_application
where application_short_name = 'CSM';

Line: 559

select RESPONSIBILITY_ID
from   ASG_USER
where  USER_ID = c_user_id;

Line: 564

SELECT csm_profiles_acc_s.NEXTVAL
FROM dual;

Line: 586

 FETCH l_last_run_date_csr INTO l_prog_update_date;

Line: 601

  CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_tab.count||' records',
                             'CSM_PROFILE_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);

Line: 616

    DELETE FROM csm_profile_option_values_acc WHERE ACCESS_ID=l_acc_tab(J);

Line: 626

           insert_profiles_acc(r_profiles_ins_rec.access_id,r_profiles_ins_rec.user_id,r_profiles_ins_rec.application_id,
                             r_profiles_ins_rec.profile_option_id, 10001,
                             0, NULL,
                             NULL,l_run_date);

Line: 635

 END LOOP; -- process profile wovalue inserts

Line: 640

 FOR r_profiles_del_rec IN l_profiles_del_csr(l_prog_update_date) LOOP

  -- initialize the user list
  l_all_omfs_palm_user_list := l_null_user_list;

Line: 682

         UPDATE csm_profile_option_values_acc
         SET profile_option_value = r_profiles_rec.profile_option_value,
             level_id =  r_profiles_rec.level_id,
             level_value = r_profiles_rec.level_value,
             level_value_application_id = r_profiles_rec.level_value_application_id,
             last_update_date = l_run_date
         WHERE CURRENT OF l_profiles_del_csr;

Line: 695

         UPDATE csm_profile_option_values_acc
         SET profile_option_value = NULL,
             level_id =  10001,
             level_value = 0,
             level_value_application_id = NULL,
             last_update_date = l_run_date
         WHERE CURRENT OF l_profiles_del_csr;

Line: 709

         DELETE FROM csm_profile_option_values_acc WHERE profile_option_id = r_profiles_del_rec.profile_option_id
         AND user_id = l_user_id;

Line: 715

 END LOOP; -- process deletes

Line: 721

            UPDATE csm_profile_option_values_acc
            SET   profile_option_value = r_profiles_upd_rec.profile_option_value,
                  last_update_date     = l_run_date
            WHERE USER_ID             = r_profiles_upd_rec.user_id
            AND   profile_option_id   = r_profiles_upd_rec.profile_option_id
            AND   level_id            = r_profiles_upd_rec.level_id
            AND   level_value         = r_profiles_upd_rec.level_value;

Line: 737

 FOR r_profiles_ins_rec IN l_profiles_ins_csr(l_prog_update_date,
     l_csm_appl_id, l_csm_resp_id) LOOP

  -- initialize the user list
  l_all_omfs_palm_user_list := l_null_user_list;

Line: 769

           UPDATE csm_profile_option_values_acc
           SET profile_option_value = r_profiles_ins_rec.profile_option_value,
               level_id = r_profiles_ins_rec.level_id,
               level_value = r_profiles_ins_rec.level_value,
               level_value_application_id = r_profiles_ins_rec.level_value_application_id,
               last_update_date = l_run_date
           WHERE CURRENT OF l_get_old_profile_csr;

Line: 784

      ELSE -- not found so insert the record(mostly this case is not used as the record is already available)

        IF (r_profiles_ins_rec.level_id = 10004 AND r_profiles_ins_rec.level_value = l_user_id) OR
                   (r_profiles_ins_rec.level_id <> 10004) THEN

           -- get the access_id
           OPEN c_profile_seq;

Line: 795

           insert_profiles_acc(l_access_id,l_user_id,r_profiles_ins_rec.application_id,
                             r_profiles_ins_rec.profile_option_id, r_profiles_ins_rec.level_id,
                             r_profiles_ins_rec.level_value, r_profiles_ins_rec.level_value_application_id,
                             r_profiles_ins_rec.profile_option_value,l_run_date);

Line: 810

 END LOOP; -- process inserts

Line: 813

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

Line: 857

SELECT val.application_id, val.profile_option_id, val.level_id, val.level_value,
       val.level_value_application_id, val.profile_option_value, opt.profile_option_name
FROM  fnd_profile_options opt,
      fnd_profile_option_values val
WHERE (opt.profile_option_name = 'CSF_M_RECIPIENTS_BOUNDARY'
--  OR opt.profile_option_name = 'CSF_M_AGENDA_ALLOWCHANGESCOMPLETEDTASK'
  OR opt.profile_option_name = 'CSF_DEBRIEF_OVERLAPPING_LABOR'
  OR opt.profile_option_name = 'CSF_MOBILE_TASK_TIMES_UPDATABLE'
  OR opt.profile_option_name  = 'INC_DEFAULT_INCIDENT_SEVERITY'
  OR opt.profile_option_name  = 'INC_DEFAULT_INCIDENT_URGENCY'
  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  = 'INC_DEFAULT_INCIDENT_TYPE'
  OR opt.profile_option_name  = 'INC_DEFAULT_INCIDENT_STATUS'
  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'
  --bug4172005
  OR opt.profile_option_name = 'CSF_RETURN_REASON'
  --R 12 updates
  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'
  )
AND val.application_id IS NOT NULL
AND val.application_id = opt.application_id
AND val.profile_option_id = opt.profile_option_id
AND (  (val.level_id = 10001)
    OR (val.level_id = 10004 AND val.level_value = p_user_id)
    OR (val.level_id = 10002 AND val.level_value = p_csm_appl_id)
    OR (val.level_id = 10003 AND val.level_value = p_csm_resp_id)
    )
AND NOT EXISTS
(SELECT 1
 FROM csm_profile_option_values_acc acc
 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 val.level_id <> 10003
-- AND NVl(acc.level_value_application_id, -1) = NVL(val.level_value_application_id, -1)
 AND acc.user_id = p_user_id
 UNION
 SELECT 1
 FROM csm_profile_option_values_acc acc,
      fnd_responsibility resp
 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
 AND acc.level_value = resp.responsibility_id
 AND acc.level_value_application_id = resp.application_id
 AND acc.user_id = p_user_id
 AND SYSDATE BETWEEN nvl(resp.start_date, sysdate) AND nvl(resp.end_date, sysdate)
 )
 ORDER BY val.application_id, val.profile_option_id, val.level_id desc
 ;

Line: 957

SELECT access_id, profile_option_value, level_id
FROM csm_profile_option_values_acc
WHERE profile_option_id = p_profile_option_id
AND user_id = p_user_id
ORDER BY level_id desc
FOR UPDATE OF profile_option_value, level_id, level_value, last_update_date NOWAIT;

Line: 968

SELECT APPLICATION_ID
FROM fnd_application
WHERE application_short_name = 'CSM';

Line: 973

SELECT  RESPONSIBILITY_ID
FROM 	asg_user
WHERE   user_id = c_user_id;

Line: 978

SELECT csm_profiles_acc_s.NEXTVAL
FROM dual;

Line: 1005

           UPDATE csm_profile_option_values_acc
           SET profile_option_value = r_profiles_ins_rec.profile_option_value,
               level_id = r_profiles_ins_rec.level_id,
               level_value = r_profiles_ins_rec.level_value,
               level_value_application_id = r_profiles_ins_rec.level_value_application_id,
               last_update_date = l_run_date
           WHERE CURRENT OF l_get_old_profile_csr;

Line: 1033

           insert_profiles_acc(l_access_id,p_user_id,r_profiles_ins_rec.application_id,
                             r_profiles_ins_rec.profile_option_id, r_profiles_ins_rec.level_id,
                             r_profiles_ins_rec.level_value, r_profiles_ins_rec.level_value_application_id,
                             r_profiles_ins_rec.profile_option_value,l_run_date);

Line: 1052

   END LOOP; -- process inserts

Line: 1097

        OR l_profile_option_name  = 'CSM_ENABLE_UPDATE_ASSIGNMENTS'
        OR l_profile_option_name  = 'CSM_ENABLE_VIEW_CUST_PRODUCTS'
    	--bug4172005
	    OR l_profile_option_name = 'CSF_RETURN_REASON'
        OR l_profile_option_name  = 'INC_DEFAULT_INCIDENT_STATUS'
		  --R 12 updates
		OR l_profile_option_name  = 'CSFW_DEFAULT_DISTANCE_UNIT'
  		OR l_profile_option_name  = 'CSF_CAPTURE_TRAVEL'
  		OR l_profile_option_name  = 'CSM_LABOR_LINE_TOTAL_CHECK'
  		OR l_profile_option_name  = 'ICX_DATE_FORMAT_MASK'
  		OR l_profile_option_name  = 'JTM_TIMEPICKER_FORMAT'
  		OR l_profile_option_name  = 'CSM_TIME_REASONABILITY_CHECK_APPLY'
  		OR l_profile_option_name  = 'ICX_NUMERIC_CHARACTERS'
  		OR l_profile_option_name  = 'CSF_LABOR_DEBRIEF_DEFAULT_UOM'
  		OR l_profile_option_name  = 'CSF_UOM_HOURS'
  		OR l_profile_option_name  = 'CSZ_DEFAULT_CONTACT_BY'
		OR l_profile_option_name  = 'HZ_REF_TERRITORY'
  		OR l_profile_option_name  = 'HZ_REF_LANG'
  		OR l_profile_option_name  = 'HZ_LANG_FOR_COUNTRY_DISPLAY'
        OR l_profile_option_name  = 'CSM_MAX_ATTACHMENT_SIZE'  --For PPC
  		OR l_profile_option_name  = 'CSF_UOM_MINUTES'
  		OR l_profile_option_name  = 'CSF_DEFAULT_TASK_STATUS_PERSONAL'
  		OR l_profile_option_name  = 'CSF_DEFAULT_TASK_TYPE_PERSONAL'
        OR l_profile_option_name  = 'CSF:DEFAULT DEBRIEF BUSINESS PROCESS'
        OR l_profile_option_name  = 'CSF:DEFAULT DEBRIEF TRANSACTION TYPE'
        OR l_profile_option_name  = 'INV:EXPENSE_TO_ASSET_TRANSFER'
        OR l_profile_option_name  = 'JTF_PROFILE_DEFAULT_CURRENCY'
        OR l_profile_option_name  = 'CSF_DEFAULT_TASK_ASSIGNED_STATUS'
        OR l_profile_option_name  = 'JTF_TASK_DEFAULT_TASK_STATUS'
        OR l_profile_option_name  = 'JTF_TASK_DEFAULT_TASK_PRIORITY'
        OR l_profile_option_name  = 'CSFW_PLANNED_TASK_WINDOW'
        OR l_profile_option_name  = 'CS_SR_CONTACT_MANDATORY'
        OR l_profile_option_name  = 'CSM_RESTRICT_DEBRIEF'
        OR l_profile_option_name  = 'CSM_RESTRICT_ORDERS'
        OR l_profile_option_name  = 'CSM_RESTRICT_TRANSFERS'
        OR l_profile_option_name  = 'JTF_TASK_DEFAULT_TASK_TYPE'
		) THEN
        RETURN TRUE;