APPS.FII_CCC_SEC_UPL_PKG SQL Statements

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

Line: 44

       SELECT distinct id INTO l_grantee_key
       FROM hri_dbi_cl_per_n_v
       WHERE value = x_grantee_name;

Line: 60

         SELECT id INTO l_dimension_id
           FROM fii_ccc_values_v
	      WHERE dimension = 'FII_COMPANIES'
		    AND value = x_dimension_value;

Line: 74

         SELECT id INTO l_dimension_id
	       FROM fii_ccc_values_v
          WHERE dimension = 'HRI_CL_ORGCC'
		    AND value = x_dimension_value;

Line: 90

   INSERT INTO fii_ccc_sec_interface
     (grantee_key,
      menu_name,
      start_date,
      end_date,
      dimension_code,
      dimension_id,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login
      )
     VALUES
     (l_grantee_key,
      x_role_name,
      x_start_date,
      x_end_date,
      x_dimension_code,
      l_dimension_id,
      g_sys_date,
      g_user_id,
      g_sys_date,
      g_user_id,
      g_user_id
     );

Line: 147

      SELECT grantee_key, menu_name, count(*)
      FROM
	  (
	   SELECT distinct grantee_key, menu_name, start_date, end_date
	   FROM  fii_ccc_sec_interface
	   WHERE status_code IS NULL
	   ) a
	   GROUP BY grantee_key, menu_name
	   HAVING COUNT(*) > 1;

Line: 158

	  SELECT distinct start_date, end_date
	  FROM  fii_ccc_sec_interface
	  WHERE status_code IS NULL
	  AND grantee_key = p_grantee_key
	  AND menu_name = p_menu_name;

Line: 198

	      SELECT distinct value INTO l_grant_to_name
          FROM  hri_dbi_cl_per_n_v
          WHERE id = l_grantee_key;

Line: 207

	      SELECT distinct role_user_name INTO l_role_user_name
		  FROM fii_ccc_sec_roles_v
	      WHERE role_name = l_menu_name;

Line: 236

	  UPDATE fii_ccc_sec_interface
         SET  status_code = 'ERR - DIFFERENT DATES',
		      last_update_date = g_sys_date,
              last_updated_by = g_user_id,
              last_update_login = g_user_id
	   WHERE status_code is NULL
	     AND grantee_key = l_grantee_key
	     AND menu_name = l_menu_name;

Line: 264

      dbg('validate: update remaining valid records to VALIDATED');

Line: 265

      UPDATE fii_ccc_sec_interface
         SET  status_code = 'VALIDATED',
              last_update_date = g_sys_date,
              last_updated_by = g_user_id,
              last_update_login = g_user_id
       WHERE status_code is NULL;

Line: 289

    SELECT grantee_key, menu_name,
           start_date, end_date,
           dimension_code, dimension_id
	FROM   fii_ccc_sec_interface
	WHERE status_code IS NULL
	ORDER BY grantee_key, menu_name, dimension_code;

Line: 298

   	SELECT g.grant_guid --, g.grantee_key, g.menu_id, int.menu_name
	FROM fnd_grants g,
	     fnd_menus  m,
	     (
          SELECT distinct grantee_key, menu_name
	      FROM   fii_ccc_sec_interface
	      WHERE status_code IS NULL
	     ) int
	WHERE int.grantee_key = g.grantee_key
	AND   int.menu_name = m.menu_name
	AND   m.menu_id = g.menu_id;

Line: 326

    dbg('upload: delete any existing grant for the grant to / role pair');

Line: 411

	-- update status_code column in the interface table to 'UPLOADED'
	dbg('upload: update status_code to UPLOADED in the interface table');

Line: 413

    UPDATE fii_ccc_sec_interface
       SET  status_code = 'UPLOADED',
	        upload_date = g_sys_date,
            last_update_date = g_sys_date,
            last_updated_by = g_user_id,
            last_update_login = g_user_id
      WHERE status_code IS NULL;

Line: 460

   SELECT count(*) INTO l_record_count
   	 FROM fii_ccc_sec_interface
	WHERE status_code IS null;