APPS.IBC_AUDIT_LOG_GRP SQL Statements

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

Line: 9

    SELECT *
      FROM IBC_AUDIT_LOGS
     WHERE audit_log_id = p_audit_log_id;

Line: 32

      SELECT meaning
        FROM FND_LOOKUP_VALUES
       WHERE lookup_type = p_lookup_type
         AND lookup_code = p_lookup_code
         AND language = p_language;

Line: 63

        SELECT user_name
          INTO l_result
          FROM fnd_user
         WHERE user_id = l_lookup_code;

Line: 68

        SELECT group_name resource_name
          INTO l_result
          FROM jtf_rs_groups_vl
         WHERE group_id = TO_NUMBER(l_lookup_code);

Line: 73

        SELECT responsibility_name
          INTO l_result
          FROM fnd_responsibility_vl
         WHERE sysdate BETWEEN start_date and NVL(end_date, sysdate)
           AND responsibility_id = l_lookup_code;

Line: 79

        SELECT meaning
          INTO l_result
          FROM ibc_lookups
         WHERE lookup_type = 'IBC_GRANTEE_TYPES'
           AND lookup_code = l_lookup_code;

Line: 85

        SELECT meaning
          INTO l_result
          FROM ibc_lookups
         WHERE lookup_type = 'IBC_SECURITY_ACTIONS'
           AND lookup_code = l_lookup_code;

Line: 121

      SELECT *
        FROM ibc_citems_v
       WHERE citem_Ver_id = p_citem_Ver_id
         AND language = p_language;

Line: 127

      SELECT *
        FROM ibc_content_items
       WHERE content_item_id = p_citem_id;

Line: 348

       	SELECT content_item_status
        INTO l_object_status
        FROM ibc_content_items
        WHERE content_item_id = p_object_value1;

Line: 357

	-- When the version is hard-deleted then this SQL
	-- will not return any value
	--
  	BEGIN
       	SELECT citem_version_status
        INTO l_object_status
        FROM ibc_citem_versions_b
        WHERE citem_version_id = p_object_value1;

Line: 371

     Ibc_Audit_Logs_Pkg.insert_row(
        px_audit_log_id            => audit_log_id
        ,p_activity                => p_activity
        ,p_parent_value            => p_parent_value
        ,p_user_id                 => Fnd_Global.user_id
        ,p_time_stamp              => SYSDATE
        ,p_object_type             => p_object_type
        ,p_object_value1           => p_object_value1
        ,p_object_value2           => p_object_value2
        ,p_object_value3           => p_object_value3
        ,p_object_value4           => p_object_value4
        ,p_object_value5           => p_object_value5
        ,p_object_status           => l_object_status
        ,p_internal_flag           => FND_API.G_FALSE
        ,p_message_application     => l_message_application
        ,p_message_name            => p_message_name
        ,p_extra_info1_type        => p_extra_info1_type
        ,p_extra_info1_ref_type    => p_extra_info1_ref_type
        ,p_extra_info1_value       => p_extra_info1_value
        ,p_extra_info2_type        => p_extra_info2_type
        ,p_extra_info2_ref_type    => p_extra_info2_ref_type
        ,p_extra_info2_value       => p_extra_info2_value
        ,p_extra_info3_type        => p_extra_info3_type
        ,p_extra_info3_ref_type    => p_extra_info3_ref_type
        ,p_extra_info3_value       => p_extra_info3_value
        ,p_extra_info4_type        => p_extra_info4_type
        ,p_extra_info4_ref_type    => p_extra_info4_ref_type
        ,p_extra_info4_value       => p_extra_info4_value
        ,p_extra_info5_type        => p_extra_info5_type
        ,p_extra_info5_ref_type    => p_extra_info5_ref_type
        ,p_extra_info5_value       => p_extra_info5_value
        ,p_object_version_number   => 1
        ,x_rowid                   => temp_rowid
     );

Line: 529

        SELECT EXTRA_INFO1_TYPE,
               EXTRA_INFO1_REF_TYPE,
               EXTRA_INFO1_VALUE
          INTO l_extra_info_type, l_extra_info_ref_type, l_extra_info_value
          FROM IBC_AUDIT_LOGS
         WHERE audit_log_id = p_audit_log_id;

Line: 536

        SELECT EXTRA_INFO2_TYPE,
               EXTRA_INFO2_REF_TYPE,
               EXTRA_INFO2_VALUE
          INTO l_extra_info_type, l_extra_info_ref_type, l_extra_info_value
          FROM IBC_AUDIT_LOGS
         WHERE audit_log_id = p_audit_log_id;

Line: 543

        SELECT EXTRA_INFO3_TYPE,
               EXTRA_INFO3_REF_TYPE,
               EXTRA_INFO3_VALUE
          INTO l_extra_info_type, l_extra_info_ref_type, l_extra_info_value
          FROM IBC_AUDIT_LOGS
         WHERE audit_log_id = p_audit_log_id;

Line: 550

        SELECT EXTRA_INFO4_TYPE,
               EXTRA_INFO4_REF_TYPE,
               EXTRA_INFO4_VALUE
          INTO l_extra_info_type, l_extra_info_ref_type, l_extra_info_value
          FROM IBC_AUDIT_LOGS
         WHERE audit_log_id = p_audit_log_id;

Line: 557

        SELECT EXTRA_INFO5_TYPE,
               EXTRA_INFO5_REF_TYPE,
               EXTRA_INFO5_VALUE
          INTO l_extra_info_type, l_extra_info_ref_type, l_extra_info_value
          FROM IBC_AUDIT_LOGS
         WHERE audit_log_id = p_audit_log_id;